| 
							
								|  |  
								|  |  
								| Joined: 12/9/2010
 
									Posts: 2
								 |  | 
							
								|  |  
								| 
									
										| 
											I tried to uninstall vers 3.88 of the cart and install 3.99 version and I get this error 
    
        
            |  |  
            | 
                
                    
                        | 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 | Folder Created -  C:\inetpub\vhosts\tonersoutlet.com\httpdocs\DesktopModules\Smith.BuyNow\ |  
                                    | Info | Created - 01.00.00.SqlDataProvider |  
                                    | Info | Executing 01.00.00.SqlDataProvider |  
                                    | Info | Start Sql execution: 01.00.00.SqlDataProvider file |  
                                    | Failure | SQL Execution resulted in following Exceptions:  System.Data.SqlClient.SqlException: Column names in each table must be unique.  Column name 'PortalID' in table 'dbo.Smith_StoreOrders' 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) BEGIN ALTER TABLE dbo.Smith_StoreOrders ADD PortalID int Null  END System.Data.SqlClient.SqlException: Column names in each table must be  unique. Column name 'Surcharge' in table 'dbo.Smith_StoreOrders' 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) BEGIN ALTER TABLE dbo.Smith_StoreOrders ADD Surcharge money  Default(0) Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'PDTextbox' in table 'dbo.Smith_StoreOrders'  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) BEGIN ALTER TABLE dbo.Smith_StoreOrders ADD PDTextbox  varchar(50) Default('') Null END System.Data.SqlClient.SqlException: Column  names in each table must be unique. Column name 'PortalID' in table  'dbo.Smith_PayHist' 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) BEGIN ALTER TABLE dbo.Smith_PayHist ADD PortalID int Null END  System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it.  Could not create constraint. See previous errors. 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) BEGIN ALTER TABLE dbo.Smith_Customer ADD CONSTRAINT  DF_Customer_DateCreated DEFAULT GETDATE() FOR DateCreated END  System.Data.SqlClient.SqlException: Column names in each table must be unique.  Column name 'PortalID' in table 'dbo.Smith_Customer' 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) BEGIN ALTER TABLE dbo.Smith_Customer ADD PortalID int Null END  System.Data.SqlClient.SqlException: Column names in each table must be unique.  Column name 'RoleExpireDays' in table 'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD RoleExpireDays  nvarchar(500) Default('') Null END System.Data.SqlClient.SqlException: Column  names in each table must be unique. Column name 'MemberPrice' in table  'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD MemberPrice money  Default(0) Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'TaxExempt' in table 'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD TaxExempt bit  Default(0) Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'PortalID' in table 'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD PortalID int Null END  System.Data.SqlClient.SqlException: Column names in each table must be unique.  Column name 'ShipCodes' in table 'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD ShipCodes varchar(100)  Default('') Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'ShipText' in table 'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD ShipText nvarchar(500)  Default('') Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'AffiliateURL' in table 'dbo.Smith_Products'  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) BEGIN ALTER TABLE dbo.Smith_Products ADD AffiliateURL  nvarchar(1000) Default('') Null END System.Data.SqlClient.SqlException: Column  names in each table must be unique. Column name 'TitleTag' in table  'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD TitleTag varchar(85)  Default('') Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'DescriptionTag' in table 'dbo.Smith_Products'  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) BEGIN ALTER TABLE dbo.Smith_Products ADD DescriptionTag  nvarchar(200) Default('') Null END System.Data.SqlClient.SqlException: Column  names in each table must be unique. Column name 'KeywordTag' in table  'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD KeywordTag  nvarchar(300) Default('') Null END System.Data.SqlClient.SqlException: Column  names in each table must be unique. Column name 'ShipCost' in table  'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD ShipCost money  Default(0) Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'RequireCoupon' in table 'dbo.Smith_Products'  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) BEGIN ALTER TABLE dbo.Smith_Products ADD RequireCoupon bit  Default(0) Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'ShowPDUDF' in table 'dbo.Smith_Products' 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) BEGIN ALTER TABLE dbo.Smith_Products ADD ShowPDUDF bit  Default(0) Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'VariantRequired' in table  'dbo.Smith_ProductVariant' 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) BEGIN ALTER TABLE dbo.Smith_ProductVariant ADD VariantRequired  bit Default(0) Null END System.Data.SqlClient.SqlException: Column names in each  table must be unique. Column name 'VariantDisplayType' in table  'dbo.Smith_ProductVariant' 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) BEGIN ALTER TABLE dbo.Smith_ProductVariant ADD  VariantDisplayType varchar(50) Default('') Null END  System.Data.SqlClient.SqlException: Column names in each table must be unique.  Column name 'PortalID' in table 'dbo.Smith_Manufacturer' 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) BEGIN ALTER TABLE dbo.Smith_Manufacturer ADD PortalID int Null  END System.Data.SqlClient.SqlException: Column names in each table must be  unique. Column name 'ParentID' in table 'dbo.Smith_Category' 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) BEGIN ALTER TABLE dbo.Smith_Category ADD ParentID INT Null END  System.Data.SqlClient.SqlException: Column names in each table must be unique.  Column name 'PortalID' in table 'dbo.Smith_Category' 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) BEGIN ALTER TABLE dbo.Smith_Category ADD PortalID INT Null END  System.Data.SqlClient.SqlException: Column names in each table must be unique.  Column name 'DiscountPercent' in table 'dbo.Smith_Coupons' 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) BEGIN ALTER TABLE dbo.Smith_Coupons ADD DiscountPercent  decimal(18, 0) Default(0) Null END System.Data.SqlClient.SqlException: Column  names in each table must be unique. Column name 'PortalID' in table  'dbo.Smith_Coupons' 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) BEGIN ALTER TABLE dbo.Smith_Coupons ADD PortalID INT Null END  System.Data.SqlClient.SqlException: Column names in each table must be unique.  Column name 'PortalID' in table 'dbo.Smith_GiftCertificates' 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) BEGIN ALTER TABLE dbo.Smith_GiftCertificates ADD PortalID INT  Null END System.Data.SqlClient.SqlException: Column names in each table must be  unique. Column name 'PortalID' in table 'dbo.Smith_ShipMethods' 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) BEGIN ALTER TABLE dbo.Smith_ShipMethods ADD PortalID INT Null  END |  
                                    | Info | End Sql execution: 01.00.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 registered -  bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll |  
                                    | Info | Created -  bin\App_Web_affiliatetrackingsettings.ascx.9167e184.dll |  
                                    | Info | Assembly registered -  bin\App_Web_trackaffiliateid.ascx.9167e184.dll |  
                                    | Info | Created -  bin\App_Web_trackaffiliateid.ascx.9167e184.dll |  
                                    | Info | Component installed successfully - Assembly |  
                                    | 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 registered -  bin\App_Web_categorymenu.ascx.dd2a0b6c.dll |  
                                    | Info | Created - bin\App_Web_categorymenu.ascx.dd2a0b6c.dll |  
                                    | Info | Assembly registered -  bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll |  
                                    | Info | Created -  bin\App_Web_catmenusettings.ascx.dd2a0b6c.dll |  
                                    | Info | Component installed successfully - Assembly |  
                                    | 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 registered -  bin\App_Web_featuredproducts.ascx.338729a9.dll |  
                                    | Info | Created -  bin\App_Web_featuredproducts.ascx.338729a9.dll |  
                                    | Info | Assembly registered -  bin\App_Web_featuredsettings.ascx.338729a9.dll |  
                                    | Info | Created -  bin\App_Web_featuredsettings.ascx.338729a9.dll |  
                                    | Info | Component installed successfully - Assembly |  
                                    | 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 registered -  bin\App_Web_minicart.ascx.d1cb3a5.dll |  
                                    | Info | Created - bin\App_Web_minicart.ascx.d1cb3a5.dll |  
                                    | Info | Assembly registered -  bin\App_Web_minicartSettings.ascx.d1cb3a5.dll |  
                                    | Info | Created -  bin\App_Web_minicartSettings.ascx.d1cb3a5.dll |  
                                    | Info | Component installed successfully - Assembly |  
                                    | 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 registered -  bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll |  
                                    | Info | Created -  bin\App_Web_myaccountinvoice.ascx.e7220eaf.dll |  
                                    | Info | Assembly registered -  bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll |  
                                    | Info | Created -  bin\App_Web_myaccountmanageorders.ascx.e7220eaf.dll |  
                                    | Info | Assembly registered -  bin\App_Web_myaccountsettings.ascx.e7220eaf.dll |  
                                    | Info | Created -  bin\App_Web_myaccountsettings.ascx.e7220eaf.dll |  
                                    | Info | Component installed successfully - Assembly |  
                                    | Failure | Package Installation aborted |  
                                    | Info | Installation Failed - Smith.MyAccount |  
                                    | Info | Starting Installation - Smith.QuickOrderEntry |  
                                    | Info | Starting Installation - Module |  
                                    | Info | Module registered successfully -  Smith.QuickOrderEntry |  
                                    | Info | Component installed successfully - Module |  
                                    | Info | Starting Installation - Assembly |  
                                    | Info | Assembly registered -  bin\App_Web_QuickOrderEntry.ascx.fa850494.dll |  
                                    | Info | Created -  bin\App_Web_QuickOrderEntry.ascx.fa850494.dll |  
                                    | Info | Assembly registered -  bin\App_Web_QuickOrderSettings.ascx.fa850494.dll |  
                                    | Info | Created -  bin\App_Web_QuickOrderSettings.ascx.fa850494.dll |  
                                    | Info | Component installed successfully - Assembly |  
                                    | Failure | Package Installation aborted |  
                                    | Info | Installation Failed - Smith.QuickOrderEntry |  
                                    | Info | Starting Installation - Smith.ProductDetail |  
                                    | Info | Starting Installation - Module |  
                                    | Info | Module registered successfully - Smith.ProductDetail |  
                                    | Info | Component installed successfully - Module |  
                                    | Info | Starting Installation - Assembly |  
                                    | Info | Assembly registered -  bin\App_Web_ProductDetails.ascx.2f4527b6.dll |  
                                    | Info | Created -  bin\App_Web_ProductDetails.ascx.2f4527b6.dll |  
                                    | Info | Assembly registered -  bin\App_Web_ProductDetailsettings.ascx.2f4527b6.dll |  
                                    | Info | Created -  bin\App_Web_ProductDetailsettings.ascx.2f4527b6.dll |  
                                    | Info | Assembly registered -  bin\App_Web_WriteReviews.ascx.2f4527b6.dll |  
                                    | Info | Created - bin\App_Web_WriteReviews.ascx.2f4527b6.dll |  
                                    | Info | Component installed successfully - Assembly |  
                                    | Failure | Package Installation aborted |  
                                    | Info | Installation Failed - Smith.ProductDetail |  
                                    | Info | Deleted temporary install folder |  
                                    | EndJob | Installation Failed |  |  |  |  
										|  |  |  |