HomeHome Product Discus... Product Discus...SmithCartSmithCartUpgrade failed upgrading to 4.93Upgrade failed upgrading to 4.93
Previous
 
Next
New Post
4/9/2012 8:31 PM
 

I was upgrading the cart to 4.93 using DNN 6.  I recieved an install failure and now when I do a repair I get:

StartJobStarting InstallationInfoStarting Installation - Smith.BuyNowInfoStarting Installation - ScriptInfoBegin Sql executionInfoCreating backup of previous version - 04.35.00.SqlDataProviderInfoCreated - 04.35.00.SqlDataProviderInfoExecuting 04.35.00.SqlDataProviderInfoStart Sql execution: 04.35.00.SqlDataProvider fileFailureSQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'PortalID' in table 'dbo.Smith_Tax' is specified more than once. at System.Data.SqlClient.SqlConnection.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) ALTER TABLE dbo.Smith_Tax ADD PortalID INT NullInfoEnd Sql execution: 04.35.00.SqlDataProvider fileInfoFinished Sql executionFailureInstallation Failed - ScriptInfoInstallation Failed - Smith.BuyNowInfoStarting Installation - Smith.AffiliateTrackingInfoStarting Installation - ModuleInfoModule registered successfully - Smith.AffiliateTrackingInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dllInfoCreating backup of previous version - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dllInfoCreated - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dllInfoAssembly already registered - bin\App_Web_trackaffiliateid.ascx.9167e184.dllInfoCreating backup of previous version - bin\App_Web_trackaffiliateid.ascx.9167e184.dllInfoCreated - bin\App_Web_trackaffiliateid.ascx.9167e184.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.AffiliateTrackingInfoStarting Installation - Smith.CategoryMenuInfoStarting Installation - ModuleInfoModule registered successfully - Smith.CategoryMenuInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_categorymenu.ascx.dd2a0b6c.dllInfoCreating backup of previous version - bin\App_Web_categorymenu.ascx.dd2a0b6c.dllInfoCreated - bin\App_Web_categorymenu.ascx.dd2a0b6c.dllInfoAssembly already registered - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dllInfoCreating backup of previous version - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dllInfoCreated - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.CategoryMenuInfoStarting Installation - Smith.FeaturedProductsInfoStarting Installation - ModuleInfoModule registered successfully - Smith.FeaturedProductsInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_featuredproducts.ascx.338729a9.dllInfoCreating backup of previous version - bin\App_Web_featuredproducts.ascx.338729a9.dllInfoCreated - bin\App_Web_featuredproducts.ascx.338729a9.dllInfoAssembly already registered - bin\App_Web_featuredsettings.ascx.338729a9.dllInfoCreating backup of previous version - bin\App_Web_featuredsettings.ascx.338729a9.dllInfoCreated - bin\App_Web_featuredsettings.ascx.338729a9.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.FeaturedProductsInfoStarting Installation - Smith.MiniCartInfoStarting Installation - ModuleInfoModule registered successfully - Smith.MiniCartInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_minicart.ascx.d1cb3a5.dllInfoCreating backup of previous version - bin\App_Web_minicart.ascx.d1cb3a5.dllInfoCreated - bin\App_Web_minicart.ascx.d1cb3a5.dllInfoAssembly already registered - bin\App_Web_minicartSettings.ascx.d1cb3a5.dllInfoCreating backup of previous version - bin\App_Web_minicartSettings.ascx.d1cb3a5.dllInfoCreated - bin\App_Web_minicartSettings.ascx.d1cb3a5.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.MiniCartInfoStarting Installation - Smith.MyAccountInfoStarting Installation - ModuleInfoModule registered successfully - Smith.MyAccountInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dllInfoCreating backup of previous version - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dllInfoCreated - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dllInfoAssembly already registered - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dllInfoCreating backup of previous version - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dllInfoCreated - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dllInfoAssembly already registered - bin\App_Web_myaccountsettings.ascx.e7220eaf.dllInfoCreating backup of previous version - bin\App_Web_myaccountsettings.ascx.e7220eaf.dllInfoCreated - bin\App_Web_myaccountsettings.ascx.e7220eaf.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.MyAccountInfoStarting Installation - Smith.QuickOrderEntryInfoStarting Installation - ModuleInfoModule registered successfully - Smith.QuickOrderEntryInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_QuickOrderEntry.ascx.fa850494.dllInfoCreating backup of previous version - bin\App_Web_QuickOrderEntry.ascx.fa850494.dllInfoCreated - bin\App_Web_QuickOrderEntry.ascx.fa850494.dllInfoAssembly already registered - bin\App_Web_QuickOrderSettings.ascx.fa850494.dllInfoCreating backup of previous version - bin\App_Web_QuickOrderSettings.ascx.fa850494.dllInfoCreated - bin\App_Web_QuickOrderSettings.ascx.fa850494.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.QuickOrderEntryInfoStarting Installation - Smith.ProductDetailInfoStarting Installation - ModuleInfoModule registered successfully - Smith.ProductDetailInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_ProductDetails.ascx.2f4527b6.dllInfoCreating backup of previous version - bin\App_Web_ProductDetails.ascx.2f4527b6.dllInfoCreated - bin\App_Web_ProductDetails.ascx.2f4527b6.dllInfoAssembly already registered - bin\App_Web_ProductDetailsettings.ascx.2f4527b6.dllInfoCreating backup of previous version - bin\App_Web_ProductDetailsettings.ascx.2f4527b6.dllInfoCreated - bin\App_Web_ProductDetailsettings.ascx.2f4527b6.dllInfoAssembly already registered - bin\App_Web_WriteReviews.ascx.2f4527b6.dllInfoCreating backup of previous version - bin\App_Web_WriteReviews.ascx.2f4527b6.dllInfoCreated - bin\App_Web_WriteReviews.ascx.2f4527b6.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.ProductDetailInfoStarting Installation - Smith.VendorInfoStarting Installation - ModuleInfoModule registered successfully - Smith.VendorInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_VendorMenu.ascx.49fa9a96.dllInfoCreating backup of previous version - bin\App_Web_VendorMenu.ascx.49fa9a96.dllInfoCreated - bin\App_Web_VendorMenu.ascx.49fa9a96.dllInfoAssembly already registered - bin\App_Web_VendorSettings.ascx.49fa9a96.dllInfoCreating backup of previous version - bin\App_Web_VendorSettings.ascx.49fa9a96.dllInfoCreated - bin\App_Web_VendorSettings.ascx.49fa9a96.dllInfoAssembly already registered - bin\App_Web_ManageVendors.ascx.49fa9a96.dllInfoCreating backup of previous version - bin\App_Web_ManageVendors.ascx.49fa9a96.dllInfoCreated - bin\App_Web_ManageVendors.ascx.49fa9a96.dllInfoAssembly already registered - bin\App_Web_AddVendor.ascx.49fa9a96.dllInfoCreating backup of previous version - bin\App_Web_AddVendor.ascx.49fa9a96.dllInfoCreated - bin\App_Web_AddVendor.ascx.49fa9a96.dllInfoAssembly already registered - bin\App_Web_VendorProducts.ascx.49fa9a96.dllInfoCreating backup of previous version - bin\App_Web_VendorProducts.ascx.49fa9a96.dllInfoCreated - bin\App_Web_VendorProducts.ascx.49fa9a96.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.VendorInfoStarting Installation - Smith.SearchInfoStarting Installation - ModuleInfoModule registered successfully - Smith.SearchInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_Search.ascx.4b2067ba.dllInfoCreating backup of previous version - bin\App_Web_Search.ascx.4b2067ba.dllInfoCreated - bin\App_Web_Search.ascx.4b2067ba.dllInfoAssembly already registered - bin\App_Web_SearchSettings.ascx.4b2067ba.dllInfoCreating backup of previous version - bin\App_Web_SearchSettings.ascx.4b2067ba.dllInfoCreated - bin\App_Web_SearchSettings.ascx.4b2067ba.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.SearchInfoStarting Installation - Smith.AddressBookInfoStarting Installation - ModuleInfoModule registered successfully - Smith.AddressBookInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_AddressBook.ascx.59fd2cee.dllInfoCreating backup of previous version - bin\App_Web_AddressBook.ascx.59fd2cee.dllInfoCreated - bin\App_Web_AddressBook.ascx.59fd2cee.dllInfoAssembly already registered - bin\App_Web_AddressBookSettings.ascx.59fd2cee.dllInfoCreating backup of previous version - bin\App_Web_AddressBookSettings.ascx.59fd2cee.dllInfoCreated - bin\App_Web_AddressBookSettings.ascx.59fd2cee.dllInfoAssembly already registered - bin\App_Web_ManageABCustomers.ascx.59fd2cee.dllInfoCreating backup of previous version - bin\App_Web_ManageABCustomers.ascx.59fd2cee.dllInfoCreated - bin\App_Web_ManageABCustomers.ascx.59fd2cee.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.AddressBookInfoStarting Installation - Smith.SalesRepInfoStarting Installation - ModuleInfoModule registered successfully - Smith.SalesRepInfoComponent installed successfully - ModuleInfoStarting Installation - AssemblyInfoAssembly already registered - bin\App_Web_SalesRep.ascx.be7a4022.dllInfoCreating backup of previous version - bin\App_Web_SalesRep.ascx.be7a4022.dllInfoCreated - bin\App_Web_SalesRep.ascx.be7a4022.dllInfoAssembly already registered - bin\App_Web_SalesRepSettings.ascx.be7a4022.dllInfoCreating backup of previous version - bin\App_Web_SalesRepSettings.ascx.be7a4022.dllInfoCreated - bin\App_Web_SalesRepSettings.ascx.be7a4022.dllInfoAssembly already registered - bin\App_Web_SalesRepCommissionRpt.ascx.be7a4022.dllInfoCreating backup of previous version - bin\App_Web_SalesRepCommissionRpt.ascx.be7a4022.dllInfoCreated - bin\App_Web_SalesRepCommissionRpt.ascx.be7a4022.dllInfoComponent installed successfully - AssemblyFailurePackage Installation abortedInfoInstallation Failed - Smith.SalesRepInfoDeleted temporary install folderEndJobInstallation Failed 

 

 

Please help, thought the upgrade would have been easy as befor.

 

Thanks,

 
New Post
4/10/2012 3:51 PM
 

Hello,

Which version of the Cart did you upgrade from?

Did you upgrade by installing v.4.93 over the previous version or did you uninstall the module first?

To get a working cart on your site I recommend following the instructions in the following forum post to do a clean install of your Cart: http://www.smith-consulting.com/Forum...

Thanks,

 
New Post
4/10/2012 5:07 PM
 

Upgraded from version 4.34 and I installed on top of it.  No uninstall was done.  wouldnt I loose my products and history?

 
New Post
4/10/2012 7:56 PM
 
Hello,

In the post I provided above, you will also find instructions to backup, export, and import your store data so you can retain your data when doing the clean install.

When upgrading, it is always recommend the you first do the upgrade in a test environment and make sure you have a full backup before installing on your live site just in case you have you need to rollback.

Thanks,
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartUpgrade failed upgrading to 4.93Upgrade failed upgrading to 4.93