Dave,
All of my products have variants. I was running 2.88 before jumping up to 2.90 yesterday. I have rolled back to 2.88, but I am still seeing the same issue. I tried to upgrade to 2.91 and the installation failed. Here is the install log:
Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - Smith.BuyNow
Info Starting Installation - Script
Info Begin Sql execution
Info Created - 02.91.00.SqlDataProvider
Info Executing 02.91.00.SqlDataProvider
Info Start Sql execution: 02.91.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near '@VariantGroup'. 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) CREATE PROCEDURE dbo.Smith_CopyProductVariant @ProductID INT, @VariantGroup VARCHAR(50) AS BEGIN INSERT Smith_ProductVariant (ProductID,VariantGroup,VariantName,VariantDisplayType,VariantImage,PriceAdjustment,WeightAdjustment,SortOrder, PortalId,VariantRequired) SELECT @ProductID as 'ProductID', VariantGroup, VariantName, VariantDisplayType, VariantImage, PriceAdjustment, WeightAdjustment, SortOrder, PortalId, VariantRequired FROM Smith_ProductVariant where variantid = @VariantGroup
Info End Sql execution: 02.91.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 updated - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll
Info Creating backup of previous version - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll
Info Created - bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll
Info Assembly updated - bin\App_Web_trackaffiliateid.ascx.9167e184.dll
Info Creating backup of previous version - bin\App_Web_trackaffiliateid.ascx.9167e184.dll
Info Created - bin\App_Web_trackaffiliateid.ascx.9167e184.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - AffiliateTrackingSettings.ascx
Info Created - AffiliateTrackingSettings.ascx
Info Creating backup of previous version - TrackAffiliateId.ascx
Info Created - TrackAffiliateId.ascx
Info Component installed successfully - File
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 updated - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll
Info Creating backup of previous version - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll
Info Created - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll
Info Assembly updated - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll
Info Creating backup of previous version - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll
Info Created - bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - CategoryMenu.ascx
Info Created - CategoryMenu.ascx
Info Creating backup of previous version - CategoryMenu.css
Info Created - CategoryMenu.css
Info Creating backup of previous version - CatMenuSettings.ascx
Info Created - CatMenuSettings.ascx
Info Creating backup of previous version - tv_collapser.gif
Info Created - tv_collapser.gif
Info Creating backup of previous version - tv_expander.gif
Info Created - tv_expander.gif
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - Smith.CategoryMenu
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 updated - bin\App_Web_featuredproducts.ascx.338729a9.dll
Info Creating backup of previous version - bin\App_Web_featuredproducts.ascx.338729a9.dll
Info Created - bin\App_Web_featuredproducts.ascx.338729a9.dll
Info Assembly updated - bin\App_Web_featuredsettings.ascx.338729a9.dll
Info Creating backup of previous version - bin\App_Web_featuredsettings.ascx.338729a9.dll
Info Created - bin\App_Web_featuredsettings.ascx.338729a9.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - FeaturedProducts.ascx
Info Created - FeaturedProducts.ascx
Info Creating backup of previous version - FeaturedProducts.css
Info Created - FeaturedProducts.css
Info Creating backup of previous version - FeaturedSettings.ascx
Info Created - FeaturedSettings.ascx
Info Component installed successfully - File
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 updated - bin\App_Web_minicart.ascx.d1cb3a5.dll
Info Creating backup of previous version - bin\App_Web_minicart.ascx.d1cb3a5.dll
Info Created - bin\App_Web_minicart.ascx.d1cb3a5.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - checkout.gif
Info Created - checkout.gif
Info Creating backup of previous version - MiniCart.ascx
Info Created - MiniCart.ascx
Info Creating backup of previous version - minicart.css
Info Created - minicart.css
Info Component installed successfully - File
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 updated - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll
Info Creating backup of previous version - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll
Info Created - bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll
Info Assembly updated - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll
Info Creating backup of previous version - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll
Info Created - bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll
Info Assembly updated - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll
Info Creating backup of previous version - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll
Info Created - bin\App_Web_myaccountsettings.ascx.e7220eaf.dll
Info Component installed successfully - Assembly
Info Starting Installation - File
Info Creating backup of previous version - myaccount.css
Info Created - myaccount.css
Info Creating backup of previous version - MyAccountInvoice.ascx
Info Created - MyAccountInvoice.ascx
Info Creating backup of previous version - MyAccountManageOrders.ascx
Info Created - MyAccountManageOrders.ascx
Info Creating backup of previous version - MyAccountSettings.ascx
Info Created - MyAccountSettings.ascx
Info Component installed successfully - File
Failure Package Installation aborted
Info Installation Failed - Smith.MyAccount
Info Deleted temporary install folder
EndJob Installation Failed