|
|
|
|
|
Joined: 5/28/2010
Posts: 471
|
|
|
This was AFTER wiping out all of the tables and trying to do a clean install.
|
Start Sql execution: 01.00.00.SqlDataProvider file
|
Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_BuyNow_StoreOrderDetails' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_StoreOrderDetails')) BEGIN CREATE TABLE dbo.[Smith_StoreOrderDetails]( [OrderDetailID] [int] IDENTITY(1,1) NOT NULL, [OrderID] [int] NOT NULL, [ProductID] [int] NOT NULL, [Quantity] [int] NOT NULL, [UnitCost] [money] NOT NULL, [ProductName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ProductSKU] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Shipped] [bit] NULL, [Returned] [bit] NULL, [DateUpdated] [datetime] NULL, [PortalID] [int] NULL, CONSTRAINT [PK_Smith_BuyNow_StoreOrderDetails] PRIMARY KEY CLUSTERED ( [OrderDetailID] ASC ) ) END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_StoreOrderDetails" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) Alter Table dbo.Smith_StoreOrderDetails Alter Column Quantity decimal(10,2) NOT NULL System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_BuyNow_StoreOrders' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_StoreOrders')) BEGIN CREATE TABLE dbo.[Smith_StoreOrders]( [OrderID] [int] IDENTITY(1,1) NOT NULL, [CustomerID] [int] NOT NULL, [OrderDate] [datetime] NOT NULL, [PayHistID] [int] NULL, [ShippingTotal] [money] NULL, [TaxTotal] [money] NULL, [HandlingCharge] [money] NULL, [ShipFirstName] [nvarchar](50) NULL, [ShipLastName] [nvarchar](50) NULL, [ShipAddress1] [varchar](200) NULL, [ShipAddress2] [varchar](200) NULL, [ShipCity] [varchar](60) NULL, [ShipState] [varchar](60) NULL, [ShipZipcode] [varchar](25) NULL, [ShipCountry] [varchar](50) NULL, [Status] [varchar](20) NULL, [ShipMethod] [nvarchar](50) NULL, [AffiliateId] [varchar](20) NULL, [CouponId] [int] NULL, [Discount] [money] NULL , [MemberDiscount] [money] NULL , [MemberRole] [nvarchar](50) NULL, [TrackingNumber] [varchar](50) NULL, CONSTRAINT [PK_Smith_BuyNow_StoreOrders] PRIMARY KEY CLUSTERED ( [OrderID] ASC ) ) END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_StoreOrders" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_StoreOrders ADD PortalID int Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_StoreOrders" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_StoreOrders ADD Surcharge money Default(0) Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_StoreOrders" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_StoreOrders ADD PDTextbox varchar(50) Default('') Null END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_BuyNow_PayHist' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_PayHist')) BEGIN CREATE TABLE dbo.[Smith_PayHist]( [PayHistID] [int] IDENTITY(1,1) NOT NULL, [CustomerID] [int] NOT NULL, [PayType] [varchar](50) NULL, [PayDate] [datetime] NULL, [Amount] [money] NULL, [Quantity] [int] NULL, [AcctNo] [varchar](50) NULL, [ExpRoute] [varchar](50) NULL, [TransID] [varchar](50) NULL, [BillingAddress] [varchar](50) NULL, [BillingCity][varchar](50) NULL, [BillingState][varchar](50) NULL, [BillingZip] [varchar](50) NULL, [BillingCountry][varchar](50) NULL, [Coupon] [varchar](50) NULL, [Notes] [varchar](50) NULL, [Status] [varchar](50) NULL, [AuthCode] [varchar](50) NULL, [BillingName] [varchar](50) NULL, CONSTRAINT [PK_Smith_BuyNow_PayHist] PRIMARY KEY CLUSTERED ( [PayHistID] ASC ) ) END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_PayHist" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_PayHist ADD PortalID int Null END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_BuyNow_Customer' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_Customer')) BEGIN CREATE TABLE dbo.[Smith_Customer]( [CustomerID] [int] IDENTITY(1,1) NOT NULL, [FirstName] [varchar](50) NULL, [LastName] [varchar](50) NULL, [Address1] [varchar](50) NULL, [Address2] [varchar](50) NULL, [City] [varchar](50) NULL, [Country] [varchar](50) NULL, [State] [varchar](50) NULL, [Zip] [varchar](50) NULL, [HomePhone] [varchar](50) NULL, [CellPhone] [varchar](50) NULL, [WorkPhone] [varchar](50) NULL, [Email] [varchar](50) NULL, [AccountNo] [varchar](50) NULL, [MaskAccountNo] [varchar](50) NULL, [ABAExpire] [varchar](50) NULL, [BillingAdress] [varchar](50) NULL, [BillingZip] [varchar](50) NULL, [DNNLogin] [varchar](50) NULL, [DateCreated] [datetime] NULL, [Contact] bit NULL, [IPAddress] [varchar](50) NULL, [UDF] [varchar](50) NULL, CONSTRAINT [PK_Smith_BuyNow_Customer] PRIMARY KEY CLUSTERED ( [CustomerID] ASC ) ) END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Customer" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Customer ADD CONSTRAINT DF_Customer_DateCreated DEFAULT GETDATE() FOR DateCreated END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Customer" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Customer ADD PortalID int Null END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_Products_1' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_Products')) BEGIN CREATE TABLE dbo.[Smith_Products]( [ProductID] [int] IDENTITY(1,1) NOT NULL, [CategoryID] [int] NOT NULL, [Manufacturer] [nvarchar](50) NULL, [ModelNumber] [nvarchar](50) NULL, [ModelName] [nvarchar](200) NULL, [ProductImage] [nvarchar](500) NULL, [ThumbnailImage] [nvarchar](500) NULL, [UnitCost] [money] NOT NULL, [QuantityOnHand] [int] NULL, [Summary] [nvarchar](1000) NULL, [Description] [ntext] NULL, [DownloadUrl] [nvarchar](1000) NULL, [Featured] [bit] NOT NULL, [Archived] [bit] NOT NULL, [Weight] [decimal](12, 2) NULL, [SortOrder] [int] NULL, [ExcludeCoupon] [bit] NULL, [Items] [int] NULL, [Share] [bit] NULL, [TabModuleId] [int] NULL, [CreatedByUser] [nvarchar](100) NULL, [CreatedDate] [datetime] NULL, [LogicallyDeleted] [bit] NULL, [Recurring] [bit] NULL, [SubscriptionInterval] [varchar](50) NULL, [RecurringOccurances] [int] NULL, [UrlGUID] [varchar](50) NULL, [EncryptUrl] [bit] NULL, [AddDNNRole] [varchar](50) NULL, [RequireLogin] [bit] NULL, [UsePriPriceWght] [bit] NULL, [MasterBundleID] [int] NULL, [BundleID] [int] NULL, CONSTRAINT [PK_Smith_Products_1] PRIMARY KEY CLUSTERED ( [ProductID] ASC ) ) END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD RoleExpireDays nvarchar(500) Default('') Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD MemberPrice money Default(0) Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD TaxExempt bit Default(0) Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD PortalID int Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD ShipCodes varchar(100) Default('') Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD ShipText nvarchar(500) Default('') Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD AffiliateURL nvarchar(1000) Default('') Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD TitleTag varchar(85) Default('') Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD DescriptionTag nvarchar(200) Default('') Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD KeywordTag nvarchar(300) Default('') Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD ShipCost money Default(0) Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD RequireCoupon bit Default(0) Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Products" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Products ADD ShowPDUDF bit Default(0) Null END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_Manufacturer' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_Manufacturer')) BEGIN CREATE TABLE dbo.[Smith_Manufacturer]( [ManufacturerID] [int] IDENTITY(1,1) NOT NULL, [ManufacturerName] [nvarchar](50) NOT NULL, CONSTRAINT [PK_Smith_Manufacturer] PRIMARY KEY CLUSTERED ( [ManufacturerID] ASC ) ) END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Manufacturer" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Manufacturer ADD PortalID int Null END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_Category' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_Category')) BEGIN CREATE TABLE dbo.[Smith_Category]( [CategoryID] [int] IDENTITY(1,1) NOT NULL, [CategoryName] [varchar](50) NOT NULL, [SortOrder] [int] NULL , [Share] [bit] NULL , [TabModuleId] [INT] NULL , CONSTRAINT [PK_Smith_Category] PRIMARY KEY CLUSTERED ( [CategoryID] ASC ) ) END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Category" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Category ADD ParentID INT Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Category" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Category ADD PortalID INT Null END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_CategoryProduct' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_CategoryProduct')) BEGIN CREATE TABLE dbo.[Smith_CategoryProduct]( [Id] [int] IDENTITY(1,1) NOT NULL, [CategoryID] [int] NULL, [ProductID] [int] NULL, CONSTRAINT [PK_Smith_CategoryProduct] PRIMARY KEY CLUSTERED ( [Id] ASC ) ) END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_Coupons' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_Coupons')) BEGIN CREATE TABLE dbo.[Smith_Coupons]( [CouponID] [int] IDENTITY(1,1) NOT NULL, [CouponCode] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CouponName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CouponAmount] [money] NOT NULL, [CouponQuantity] [varchar](50) NULL, [DiscountByItem] bit NULL , [CreatedByUser] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CreatedDate] [datetime] NULL, [ProductId] [int] NULL , [CouponLimit] [int] NULL, [CouponShipping] [money] NULL CONSTRAINT [PK_Smith_Coupons] PRIMARY KEY CLUSTERED ( [CouponID] ASC ) ) END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Coupons" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Coupons ADD DiscountPercent decimal(18, 0) Default(0) Null END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_Coupons" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_Coupons ADD PortalID INT Null END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_ShipMethods' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_ShipMethods')) BEGIN CREATE TABLE dbo.[Smith_ShipMethods]( [ShipMethodID] [int] IDENTITY(1,1) NOT NULL, [ShipMethodName] [varchar](50) NULL, [ShipMethodAmount] [decimal](18, 2) NULL, [Share] [bit] NULL, [TabModuleId] [int] NULL, [SortOrder] [int] NULL CONSTRAINT [PK_Smith_ShipMethods] PRIMARY KEY CLUSTERED ( [ShipMethodID] ASC ) ) END System.Data.SqlClient.SqlException: Cannot find the object "dbo.Smith_ShipMethods" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) BEGIN ALTER TABLE dbo.Smith_ShipMethods ADD PortalID INT Null END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_Tax' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /********* Drop tables and recreate **********/ IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.Smith_Tax')) BEGIN CREATE TABLE dbo.[Smith_Tax] ( [TaxId] [int] IDENTITY(1,1) NOT NULL, [State] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [County] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [City] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [TaxRate] [float] NOT NULL, CONSTRAINT [PK_Smith_Tax] PRIMARY KEY CLUSTERED ( [TaxId] ASC ) ) END System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_Country' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TABLE dbo.[Smith_Country] ( [CountryId] [int] IDENTITY(1,1) NOT NULL, [Country] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Code] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SortOrder] [int] NULL, CONSTRAINT [PK_Smith_Country] PRIMARY KEY CLUSTERED ( [CountryId] ASC ) ) System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_State' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TABLE dbo.[Smith_State] ( [StateId] [int] IDENTITY(1,1) NOT NULL, [State] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [StateCode] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CountryCode] [VARCHAR](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SortOrder] [int] NULL, CONSTRAINT [PK_Smith_State] PRIMARY KEY CLUSTERED ( [StateId] ASC ) ) System.Data.SqlClient.SqlException: There is already an object named 'PK_Smith_ShoppingCart_1' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TABLE dbo.[Smith_ShoppingCart]( [CartID] [int] IDENTITY(1,1) NOT NULL, [ProductID] [int] NOT NULL, [Manufacturer] [varchar](50) NULL, [ModelName] [varchar](50) NULL, [UnitCost] [decimal](18, 0) NULL, [QuantityOnHand] [int] NULL, [Quantity] [int] NULL, [Weight] [decimal](18, 0) NULL, [ProductName] [varchar](50) NULL, [ProductSku] [varchar](50) NULL, [IsRequired] [bit] NULL, [BundleID] [int] NULL, [AddDnnRole] [varchar](50) NULL, [Recurring] [bit] NULL, [RequireLogin] [bit] NULL, [UsePriPriceWght] [bit] NULL, [MasterBundleID] [int] NULL, [LineItem] [int] NULL, [RoleExpireDays] [varchar](50) NULL, [MemberPrice] [decimal](18, 0) NULL, [TaxExempt] [bit] NULL, [ShipCodes] [varchar](100) NULL, [ShipText] [nvarchar](500) NULL, [ShipCost] [money] NULL, CONSTRAINT [PK_Smith_ShoppingCart_1] PRIMARY KEY CLUSTERED ( [CartID] ASC ) ) |
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Looks like you deleted all the tables and sprocs but not the constraints.
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 5/28/2010
Posts: 471
|
|
|
I ended up blowing out all of the tables and SP's.... doing a clean install of the cart, then using identity inserts in SQL, brought over all the data for products, orders, saved carts, etc. from my backup.
Since I had an upgrade blow up several versions ago, I have not had success doing upgrades since then. Hopefully that is all resolved with this clean install.
And before I get beat up TOO bad.... no, I didn't install it on my sandbox first (bad bad bad!) but since my production site was the one that the upgrades always fail on, this will hopefully fix all of that.
I should renew my sandbox, so that it is in sync with my current site.
|
|
|
|
| |