Hi Dave,

On DNN 6.2.2, I ran another attempted ugrade from SC 4.99 to SC 5.18 BETA. It failed as follows:

StartJob	Starting Installation
Info	Starting Installation - Smith.BuyNow
Info	Starting Installation - Script
Info	Begin Sql execution
Info	Created - 05.00.00.SqlDataProvider
Info	Executing 05.00.00.SqlDataProvider
Info	Start Sql execution: 05.00.00.SqlDataProvider file
Info	End Sql execution: 05.00.00.SqlDataProvider file
Info	Created - 05.10.00.SqlDataProvider
Info	Executing 05.10.00.SqlDataProvider
Info	Start Sql execution: 05.10.00.SqlDataProvider file
Info	End Sql execution: 05.10.00.SqlDataProvider file
Info	Created - 05.12.00.SqlDataProvider
Info	Executing 05.12.00.SqlDataProvider
Info	Start Sql execution: 05.12.00.SqlDataProvider file
Failure	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Create PROCEDURE dbo.Smith_ListVariantIDByVariantName @ProductID int, @VariantNameList nvarchar(1000) as SET NOCOUNT ON DECLARE @TempList table ( VariantName nvarchar(100) ) INSERT INTO @TempList (VariantName) select * from [dbo].[scSplit](@VariantNameList, '~') SELECT pv.VariantID FROM Smith_ProductVariant pv inner JOIN @TempList t ON pv.VariantName = t.VariantName where pv.ProductID = @ProductID
Info	End Sql execution: 05.12.00.SqlDataProvider file
Info	Finished Sql execution
Failure	Installation Failed - Script
Info	Installation Failed - Smith.BuyNow
Info	Starting Installation - Smith.AffiliateTracking
Info	Starting Installation - Module
Info	Module registered successfully - Smith.AffiliateTracking
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithAffiliateTracking.dll
Info	Created - bin\SmithAffiliateTracking.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.AffiliateTracking
Info	Starting Installation - Smith.CategoryMenu
Info	Starting Installation - Module
Info	Module registered successfully - Smith.CategoryMenu
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithCategoryMenu.dll
Info	Created - bin\SmithCategoryMenu.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.CategoryMenu
Info	Starting Installation - Smith.ManufacturerMenu
Info	Starting Installation - Module
Info	Module registered successfully - Smith.ManufacturerMenu
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithManufacturerMenu.dll
Info	Created - bin\SmithManufacturerMenu.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.ManufacturerMenu
Info	Starting Installation - Smith.FeaturedProducts
Info	Starting Installation - Module
Info	Module registered successfully - Smith.FeaturedProducts
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithFeaturedProducts.dll
Info	Created - bin\SmithFeaturedProducts.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.FeaturedProducts
Info	Starting Installation - Smith.MiniCart
Info	Starting Installation - Module
Info	Module registered successfully - Smith.MiniCart
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithMiniCart.dll
Info	Created - bin\SmithMiniCart.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.MiniCart
Info	Starting Installation - Smith.MyAccount
Info	Starting Installation - Module
Info	Module registered successfully - Smith.MyAccount
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithMyAccount.dll
Info	Created - bin\SmithMyAccount.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.MyAccount
Info	Starting Installation - Smith.QuickOrderEntry
Info	Starting Installation - Module
Info	Module registered successfully - Smith.QuickOrderEntry
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithQuickOrderEntry.dll
Info	Created - bin\SmithQuickOrderEntry.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.QuickOrderEntry
Info	Starting Installation - Smith.ProductDetail
Info	Starting Installation - Module
Info	Module registered successfully - Smith.ProductDetail
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithProductDetail.dll
Info	Created - bin\SmithProductDetail.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.ProductDetail
Info	Starting Installation - Smith.Vendor
Info	Starting Installation - Module
Info	Module registered successfully - Smith.Vendor
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithVendor.dll
Info	Created - bin\SmithVendor.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.Vendor
Info	Starting Installation - Smith.Search
Info	Starting Installation - Module
Info	Module registered successfully - Smith.Search
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithSearch.dll
Info	Created - bin\SmithSearch.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.Search
Info	Starting Installation - Smith.AddressBook
Info	Starting Installation - Module
Info	Module registered successfully - Smith.AddressBook
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithAddressBook.dll
Info	Created - bin\SmithAddressBook.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.AddressBook
Info	Starting Installation - Smith.SalesRep
Info	Starting Installation - Module
Info	Module registered successfully - Smith.SalesRep
Info	Component installed successfully - Module
Info	Starting Installation - Assembly
Info	Assembly registered - bin\SmithSalesRep.dll
Info	Created - bin\SmithSalesRep.dll
Info	Component installed successfully - Assembly
Failure	Package Installation aborted
Info	Installation Failed - Smith.SalesRep
Info	Deleted temporary install folder
EndJob	Installation Failed

Hi Kevin,

SQL Server version Enterprise 2008. More specifically:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 (Build 7601: Service Pack 1)
10.50.1600.1, RTM, Enterprise Edition (64-bit)

The DNN install was originally a fresh install of 6.0.0, which was then upgrade to 6.2.2 before upgrading the cart.

I can create a test portal for you if that would help?

Thanks,
Daniel.

What collation are you using in your sql database?

---

At your service,
Dave Smith

Hi Daniel,

That cannot be correct, the error clearly states another collation order (SQL_Latin1_General_CP1_CI_AS). Did you by any chance move this database from a different server, or is this an upgraded sql server, that was installed with a different db collation order?

I have tested upgrades of the Cart on a fresh install of DNN 6.2.2, from 4.99 to 5.18 BETA and 4.99 to 5.0 to 5.18 and in both cases the upgrades were successful.

Thanks,

Also, since the stored proc causing the trouble (Smith_ListVariantIDByVariantName) relates to product variants, I have looked at all the product variants and some of them use the following characters:
+
/
(
)
$
space

(I don't know if this matters at all).

Thanks Dave,

I added the highlighted code below into your 05.12.00.SqlDataProvider file from the 5.18 Beta install package. AND IT INSTALLS NOW.

Will you be changing your install package to include this?



IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'{databaseOwner}{objectQualifier}Smith_ListVariantIDByVariantName'))
drop procedure  {databaseOwner}{objectQualifier}Smith_ListVariantIDByVariantName
GO


Create  PROCEDURE {databaseOwner}{objectQualifier}Smith_ListVariantIDByVariantName
@ProductID int,
@VariantNameList nvarchar(1000)
as

SET NOCOUNT ON
DECLARE @TempList table
(
VariantName nvarchar(100)
)

INSERT INTO @TempList (VariantName)
select * from [dbo].[scSplit](@VariantNameList, '~')

SELECT pv.VariantID FROM {objectQualifier}Smith_ProductVariant pv inner JOIN @TempList t ON pv.VariantName COLLATE DATABASE_DEFAULT = t.VariantName COLLATE DATABASE_DEFAULT
where pv.ProductID = @ProductID


GO