Last week I upgraded DNN from 5.4.x to 5.5.0 as it was a critical update and we were feeling the effects of the issues with 5.4.
Overall everything was working fine. The only problem I found was when trying to checkout it would throw an error as ( do not remember exactly) but the Object reference not set to an instance of an object.
So I checked for a later release of CataLook as I was using 5.8.9 and saw 6.0.8 and downloaded it. I followed the install instructions and all went well until installing the CATALookStore extension. I get the following error:
Package Installation Report See below for the results of the package installation
Error loading files from temporary folder - see below
StartJob
Starting Installation
Info
Starting Installation - CATALooKStore
Starting Installation - Script
Begin Sql execution
Creating backup of previous version - Providers\DataProviders\SqlDataProvider\05.09.00.SqlDataProvider
Created - Providers\DataProviders\SqlDataProvider\05.09.00.SqlDataProvider
Executing 05.09.00.SqlDataProvider
Start Sql execution: 05.09.00.SqlDataProvider file
Failure
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'ApplyFormulaTo' in table 'dbo.CAT_CartPriceRules' is specified more than once. 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(TdsParserStateObject stateObj) 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) -- =============================================================================== -- CONFIG CATALooK.netStore DATABASE http://www.dnnsoft.com -- Copyright (c) 2003-2010 CATALooK Software -- Version: 05.09.00 -- support@catalook.de -- -- Note: To manually execute this script you must -- perform a search and replace operation -- for dbo. and -- Specify values fordbo. and in web.config -- You don't need to replace dbo. and if you execute -- this script or parts of this script via DotNetNuke Host -> SQL -- =============================================================================== -- ================================================================== -- Data Base Update from v05.08.09 to v05.09.00 -- ================================================================== ALTER TABLE dbo.[CAT_CartPriceRules] ADD [ApplyFormulaTo] [int]
End Sql execution: 05.09.00.SqlDataProvider file
Finished Sql execution
Installation Failed - Script
Installation Failed - CATALooKStore
Deleted temporary install folder
EndJob
Installation Failed
If I go to the main store tab/page I get the following error at the main module:
A critical error has occurred.Column 'FraktguideUserCode' does not belong to table .
The first two extensions installed without errors. I did try a second time with the same result.