My client's
website is running DNN v7.4.2 and Cart Viper v3.0.2. I went to upgrade to Cart Viper 3.5.9 and got a number of errors starting with "Invalid column name 'additionalFreeShipping'".
After the upgrade, the Host > Extensions says all the Cart Viper modules are 3.5.9 with the exception of "Cart Viper Admin" which is still at v3.0.2.
I tried doing a "Repair Install" of the Cart Viper v3.5.9 module but got the same errors and same result.
The store is basically running OK however the "Checkout" problem reported in my previous post still persists.
How can I complete the upgrade?
I've emailed Nigel Host credentials for the website.
Below are some more details about the installation errors:
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 - CartViperAdmin
Info Starting Installation - Script
Info Begin Sql execution
Info Created - 03.01.01.SqlDataProvider
Info Executing 03.01.01.SqlDataProvider
Info Start Sql execution: 03.01.01.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'additionalFreeShipping'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d24b32a5-67a6-4ced-b8fa-a60d1530d7e0 Error Number:207,State:1,Class:16 alter procedure dbo.[CVStore_InsertUpdateCouponInformation] ( @couponId int, @couponCode nvarchar(255), @description nvarchar (255), @minSubTotal decimal (18,2), @ispercentagediscount bit, @discount decimal (18,2), @canUseMultipleTimes bit, @expiryDate datetime, @hasBeenUsed bit, @portalId int, @emailAddress nvarchar(255), @startDate datetime, @productSku nvarchar(255), @couponType nvarchar(50), @categoryId nvarchar(max), @remainingNumberOfUses int, @additionalFreeShipping bit ) as set nocount on if exists(select null from dbo.[CVStore_Coupons] where couponId = @couponId) begin update dbo.[CVStore_Coupons] set couponCode = @couponCode, description = @description, MinimumSubTotal =@minSubTotal, IsPercentageDiscount = @IsPercentageDiscount, discount = @discount, canUseMultipleTimes = @canUseMultipleTimes, expiryDate = @expiryDate, hasBeenUsed = @hasBeenUsed, portalId = @portalId, customerEmailAddress =@emailAddress, couponStartDate = @startDate, productSku = @productSku, couponType =@couponType, categoryId = @categoryId, RemainingNumberOfUses = @RemainingNumberOfUses, additionalFreeShipping = @additionalFreeShipping where couponId = @couponId SELECt @couponId end else insert into dbo.[CVStore_Coupons] (couponCode, description, MinimumSubTotal, isPercentageDiscount, discount, canUseMultipleTimes, expiryDate, hasBeenUsed, portalId, customerEmailAddress, couponStartDate, productSku, couponType, categoryId, RemainingNumberOfUses,additionalFreeShipping) values (@couponCode, @description, @MinSubTotal, @isPercentageDiscount, @discount, @canUseMultipleTimes, @expiryDate, @hasBeenUsed, @portalId, @emailAddress, @startDate, @productSku, @couponType, @categoryId, @RemainingNumberOfUses, @additionalFreeShipping) SELECT SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'additionalFreeShipping'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:d24b32a5-67a6-4ced-b8fa-a60d1530d7e0 Error Number:207,State:1,Class:16 alter procedure dbo.[CVStore_InsertUpdateCouponInformation] ( @couponId int, @couponCode nvarchar(255), @description nvarchar (255), @minSubTotal decimal (18,2), @ispercentagediscount bit, @discount decimal (18,2), @canUseMultipleTimes bit, @expiryDate datetime, @hasBeenUsed bit, @portalId int, @emailAddress nvarchar(255), @startDate datetime, @productSku nvarchar(255), @couponType nvarchar(50), @categoryId nvarchar(max), @remainingNumberOfUses int, @additionalFreeShipping bit, @NoTimesBeenUsed int ) as set nocount on if exists(select null from dbo.[CVStore_Coupons] where couponId = @couponId) begin update dbo.[CVStore_Coupons] set couponCode = @couponCode, description = @description, MinimumSubTotal =@minSubTotal, IsPercentageDiscount = @IsPercentageDiscount, discount = @discount, canUseMultipleTimes = @canUseMultipleTimes, expiryDate = @expiryDate, hasBeenUsed = @hasBeenUsed, portalId = @portalId, customerEmailAddress =@emailAddress, couponStartDate = @startDate, productSku = @productSku, couponType =@couponType, categoryId = @categoryId, RemainingNumberOfUses = @RemainingNumberOfUses, additionalFreeShipping = @additionalFreeShipping, NoTimesBeenUsed = @NoTimesBeenUsed where couponId = @couponId end else insert into dbo.[CVStore_Coupons](couponCode, description, MinimumSubTotal, isPercentageDiscount, discount, canUseMultipleTimes, expiryDate, hasBeenUsed, portalId, customerEmailAddress, couponStartDate, productSku, couponType, categoryId, RemainingNumberOfUses,additionalFreeShipping,NoTimesBeenUsed) values (@couponCode, @description, @MinSubTotal, @isPercentageDiscount, @discount, @canUseMultipleTimes, @expiryDate, @hasBeenUsed, @portalId, @emailAddress, @startDate, @productSku, @couponType, @categoryId, @RemainingNumberOfUses, @additionalFreeShipping, @NoTimesBeenUsed)
Info End Sql execution: 03.01.01.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - CartViperAdmin
Info Starting Installation - CartViperAccount
Info Starting Installation - Module
Info Module registered successfully - Cart Viper Account
Info Component installed successfully - Module
Info Starting Installation - File
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - CartViperAccount
Info Starting Installation - CartViperCatalog
Info Starting Installation - Module
Info Module registered successfully - Cart Viper Catalog
Info Component installed successfully - Module
Info Starting Installation - File
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - CartViperCatalog
Info Starting Installation - CartViperMiniCart
Info Starting Installation - Module
Info Module registered successfully - Cart Viper Mini Cart
Info Component installed successfully - Module
Info Starting Installation - File
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - CartViperMiniCart
Info Starting Installation - CartViperMenu
Info Starting Installation - Module
Info Module registered successfully - Cart Viper Menu
Info Component installed successfully - Module
Info Starting Installation - File
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - CartViperMenu
Info Starting Installation - CartViperNewsletterSubscription
Info Starting Installation - Module
Info Module registered successfully - Cart Viper Newsletter Subscription
Info Component installed successfully - Module
Info Starting Installation - File
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - CartViperNewsletterSubscription
Info Starting Installation - CartViperProductWidget
Info Starting Installation - Module
Info Module registered successfully - Cart Viper Product Widget
Info Component installed successfully - Module
Info Starting Installation - File
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - CartViperProductWidget
Info Starting Installation - CartViperRecentlyViewedItems
Info Starting Installation - Module
Info Module registered successfully - Cart Viper Recently Viewed Items
Info Component installed successfully - Module
Info Starting Installation - File
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - CartViperRecentlyViewedItems
Info Starting Installation - CartViperSearch
Info Starting Installation - Module
Info Module registered successfully - Cart Viper Search Module
Info Component installed successfully - Module
Info Starting Installation - File
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - CartViperSearch
Info Starting Installation - CartViperEventsCalendar
Info Starting Installation - Module
Info Module registered successfully - Cart Viper Events Calendar
Info Component installed successfully - Module
Info Starting Installation - File
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - CartViperEventsCalendar
Info Deleted temporary install folder
EndJob Installation Failed
Return