I just installed 2.95 and started to update the variant group table for my existing variants. I received the following error:

An error has occurred.
DotNetNuke.Services.Exceptions.PageLoadException: Cannot have multiple items selected in a DropDownList. ---> System.Web.HttpException: Cannot have multiple items selected in a DropDownList. at System.Web.UI.WebControls.DropDownList.VerifyMultiSelect() at System.Web.UI.WebControls.ListControl.RenderContents(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.WebControls.MultiView.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.desktopmodules_smith_buynow_addproducts_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer) at DotNetNuke.UI.Modules.ModuleHost.RenderContents(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.portals__default_skins_minimalextropy_index_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.default_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Page.Render(HtmlTextWriter writer) at DotNetNuke.Framework.PageBase.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

I received the error with the following path:

Store Admin

Edit Product

Variants

Edit Variants

Since the existing variant isn't in the drop down, I copy the variant name from the existing item and Click "Manage Variant Groups".

Paste the existing variant name in the "Group Name" Field

Leave the Help URL blank since the help page isn't available yet.

Click Add Variant Group

Click Back

Click Variants again

Click Edit on the same variant I started with to see the Variant Group Name appear for editing.

The drop down does not show the value of the variant group so I select it.

Click "Update Variant Group"

Click the same Variant again so I can see that the editted group is now selected.

Receive error message !

I absolutely need to be able to add the help for the existing variants as there are hundreds. How do I add thei feature to the existing variants. I can not start over.

-- Art

The same error message occurs when I add a New Variant Group first and then add the first member to that group. When I try to edit the variant again, the system blows up. For whatever reason, even though I only added 1 test variant, I now have two of the same test variants on the list. I have no idea why the new value would be duplicated as I didn't add the value twice.

I have no other DNN install so that is not possible. The project has too much data in it at this point to destroy it and start over like I did a bunch of times in April and May. How did you do your testing to see if this worked with existing data?

I am not copying anything. I am trying to use the base enhancement I bought.

Again, Here are the steps I used that showed me the bug.

---------------------------------------------------------------------------------------------------------

received the error with the following path:

Store Admin

Edit Product

Variants

Edit Variants

Since the existing variant isn't in the drop down, I copy the variant name from the existing item and Click "Manage Variant Groups".

Paste the existing variant name in the "Group Name" Field

Leave the Help URL blank since the help page isn't available yet.

Click Add Variant Group

Click Back

Click Variants again

Click Edit on the same variant I started with to see the Variant Group Name appear for editing.

The drop down does not show the value of the variant group so I select it.

Click "Update Variant Group"

Click the same Variant again so I can see that the editted group is now selected.

Receive error message !

---------------------------------------------------------------------------------------------------------

Continuing my testing, I have added the 11 variants to the group table for the existing product.

1) I then tried to delete the test variant group. I received a new error:

"The Stored Procedure dbo.DNN_SMITH_DeletevariantGroup doesn't exist".

2) I added a new product called test. I then went to variants and clicked on Manage Groups to add the first variant name.

I saved the variant and then clicked back. I add a new variant under the new variant group. I try to edit the variant after saving. It blows up with the same message as above.

I wouldn't put this out as a production release yet.

What stored procedures should I have?

Hi Art,

David just emailed you cart version 2.96 which should fix the issue you reported with the new variant group screen.

-Scott

---

Scott Kelly
Project Manager

Well I decided to ignore that message and received the following error instead:

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.96.00.SqlDataProvider Info Executing 02.96.00.SqlDataProvider Info Start Sql execution: 02.96.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'END'. 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) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.DNN_Smith_ProductRestrictedState')) BEGIN CREATE TABLE dbo.[DNN_Smith_ProductRestrictedState]( [RestrictedStateId] [int] IDENTITY(1,1) NOT NULL, [ProductID] [int] NOT NULL, [StateText] [varchar](200) NULL, [State] [varchar](50) NULL, [CountryCode] [varchar](50) NULL, CONSTRAINT [PK_Smith_RestrictedState] PRIMARY KEY CLUSTERED ( [RestrictedStateId] ASC ) END System.Data.SqlClient.SqlException: Incorrect syntax near ')'. 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.DNN_Smith_AddRestrictedState @ProductID int, @State varchar(50) = NULL, @StateText varchar(50) = NULL, @Country varchar(50) = NULL ) AS INSERT INTO DNN_Smith_ProductRestrictedStates ( [ProductID], [State], [StateText], [CountryCode] ) VALUES ( @ProductID, @State, @StateText, @Country ) SELECT CAST(SCOPE_IDENTITY() as INT) Info End Sql execution: 02.96.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

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.96.00.SqlDataProvider Info Executing 02.96.00.SqlDataProvider Info Start Sql execution: 02.96.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'END'. 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) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.DNN_Smith_ProductRestrictedState')) BEGIN CREATE TABLE dbo.[DNN_Smith_ProductRestrictedState]( [RestrictedStateId] [int] IDENTITY(1,1) NOT NULL, [ProductID] [int] NOT NULL, [StateText] [varchar](200) NULL, [State] [varchar](50) NULL, [CountryCode] [varchar](50) NULL, CONSTRAINT [PK_Smith_RestrictedState] PRIMARY KEY CLUSTERED ( [RestrictedStateId] ASC ) END System.Data.SqlClient.SqlException: Incorrect syntax near ')'. 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.DNN_Smith_AddRestrictedState @ProductID int, @State varchar(50) = NULL, @StateText varchar(50) = NULL, @Country varchar(50) = NULL ) AS INSERT INTO DNN_Smith_ProductRestrictedStates ( [ProductID], [State], [StateText], [CountryCode] ) VALUES ( @ProductID, @State, @StateText, @Country ) SELECT CAST(SCOPE_IDENTITY() as INT) Info End Sql execution: 02.96.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

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.96.00.SqlDataProvider Info Executing 02.96.00.SqlDataProvider Info Start Sql execution: 02.96.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'END'. 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) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.DNN_Smith_ProductRestrictedState')) BEGIN CREATE TABLE dbo.[DNN_Smith_ProductRestrictedState]( [RestrictedStateId] [int] IDENTITY(1,1) NOT NULL, [ProductID] [int] NOT NULL, [StateText] [varchar](200) NULL, [State] [varchar](50) NULL, [CountryCode] [varchar](50) NULL, CONSTRAINT [PK_Smith_RestrictedState] PRIMARY KEY CLUSTERED ( [RestrictedStateId] ASC ) END System.Data.SqlClient.SqlException: Incorrect syntax near ')'. 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.DNN_Smith_AddRestrictedState @ProductID int, @State varchar(50) = NULL, @StateText varchar(50) = NULL, @Country varchar(50) = NULL ) AS INSERT INTO DNN_Smith_ProductRestrictedStates ( [ProductID], [State], [StateText], [CountryCode] ) VALUES ( @ProductID, @State, @StateText, @Country ) SELECT CAST(SCOPE_IDENTITY() as INT) Info End Sql execution: 02.96.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

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.96.00.SqlDataProvider Info Executing 02.96.00.SqlDataProvider Info Start Sql execution: 02.96.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'END'. 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) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.DNN_Smith_ProductRestrictedState')) BEGIN CREATE TABLE dbo.[DNN_Smith_ProductRestrictedState]( [RestrictedStateId] [int] IDENTITY(1,1) NOT NULL, [ProductID] [int] NOT NULL, [StateText] [varchar](200) NULL, [State] [varchar](50) NULL, [CountryCode] [varchar](50) NULL, CONSTRAINT [PK_Smith_RestrictedState] PRIMARY KEY CLUSTERED ( [RestrictedStateId] ASC ) END System.Data.SqlClient.SqlException: Incorrect syntax near ')'. 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.DNN_Smith_AddRestrictedState @ProductID int, @State varchar(50) = NULL, @StateText varchar(50) = NULL, @Country varchar(50) = NULL ) AS INSERT INTO DNN_Smith_ProductRestrictedStates ( [ProductID], [State], [StateText], [CountryCode] ) VALUES ( @ProductID, @State, @StateText, @Country ) SELECT CAST(SCOPE_IDENTITY() as INT) Info End Sql execution: 02.96.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

Those files were added in this build for the first data web service integration we recently did we will remove from the install and send you a new build

---

Scott Kelly
Project Manager

Dear Scott and Dave,

I still receive an error message. It tells me that the package is already installed and do I want to repair the install. I said yes and then went through a very scary warning that said all of my files would be overwritten. I hoped that was only the files and not the SQL database files. That seems to be the case. At any rate, the install failed. The buyNow is still at 2.95. I still can't edit variants, and the error message is as follows:

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 - Smith.BuyNow Info Starting Installation - Script Info Begin Sql execution Info Creating backup of previous version - 02.96.00.SqlDataProvider Info Created - 02.96.00.SqlDataProvider Info Executing 02.96.00.SqlDataProvider Info Start Sql execution: 02.96.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near ')'. 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.DNN_Smith_AddRestrictedState @ProductID int, @State varchar(50) = NULL, @StateText varchar(50) = NULL, @Country varchar(50) = NULL ) AS INSERT INTO DNN_Smith_ProductRestrictedStates ( [ProductID], [State], [StateText], [CountryCode] ) VALUES ( @ProductID, @State, @StateText, @Country ) SELECT CAST(SCOPE_IDENTITY() as INT) Info End Sql execution: 02.96.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 already registered - 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 already registered - 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 already registered - 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 already registered - 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 already registered - 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 already registered - 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 already registered - 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 already registered - 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 already registered - 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 already registered - 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