I have cloned a site and upgraded it to 5.4.4 I attempted to then upgrade our Catalook to version 6.08... I have installed two PA's without a problem (CAT_Modules and CAT_StoreSettings) but I get a really long SQL error when installing the CATALooKStore.zip (listed below) Any ideas???
tx,
JR
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Could not drop object 'dbo.CAT_Products' because it is referenced by a FOREIGN KEY constraint. 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 exists (select * from sysobjects where id = object_id(N'dbo.[CAT_Products]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table dbo.[CAT_Products] System.Data.SqlClient.SqlException: Could not drop object 'dbo.CAT_ProductFiles' because it is referenced by a FOREIGN KEY constraint. 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 exists (select * from sysobjects where id = object_id(N'dbo.[CAT_ProductFiles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table dbo.[CAT_ProductFiles] System.Data.SqlClient.SqlException: There is already an object named 'CAT_ProductFiles' in the database. 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 TABLE dbo.[CAT_ProductFiles] ( [FileID] [int] IDENTITY (1, 1) NOT NULL , [ProductID] [int] NOT NULL , [FileName] [nvarchar] (50) NOT NULL , [Description] [nvarchar] (50) NULL , [MediaType] [char] (1) NOT NULL , [ViewOrder] [int] NULL CONSTRAINT [PK_CAT_ProductFiles] PRIMARY KEY NONCLUSTERED ( [FileID] ) ON [PRIMARY] ) ON [PRIMARY] System.Data.SqlClient.SqlException: The operation failed because an index or statistics with name 'IX_CAT_ProductFiles' already exists on table 'dbo.CAT_ProductFiles'. 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 INDEX [IX_CAT_ProductFiles] ON dbo.[CAT_ProductFiles]([ProductID], [MediaType]) ON [PRIMARY] System.Data.SqlClient.SqlException: There is already an object named 'CAT_Products' in the database. 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 TABLE dbo.[CAT_Products] ( [ProductID] [int] IDENTITY (1, 1) NOT NULL , [CategoryID] [int] , [Category2ID] [int] , [Category3] [nvarchar](50) , [ProductName] [nvarchar] (50) , [ProductNumber] [nvarchar] (50) , [EAN] [nvarchar] (50) , [ISBN] [nvarchar] (50) , [Free1] [nvarchar] (50) , [Free2] [nvarchar] (50) , [Free3] [nvarchar] (50) , [KeyWords] [nvarchar] (1000) , [ProductImage] [nvarchar] (255) , [UnitCost] [money] NOT NULL , [UnitCost2] [money] NULL , [UnitCost3] [money] NULL , [UnitCost4] [money] NULL , [UnitCost5] [money] NULL , [UnitCost6] [money] NULL , [Description] [nvarchar] (2000) , [DescriptionHTML] [ntext] NOT NULL , [URL] [nvarchar] (200) , [Stock] [int] NULL , [OrderQuant] [nvarchar] (200) NOT NULL Default (''), [Weight] [decimal](8, 2) NULL , [Volume] [decimal](8, 2) NULL , [Length] [decimal](8, 2) NULL , [Width] [decimal](8, 2) NULL , [Height] [decimal](8, 2) NULL , [FreightCosts1] [money] NULL , [FreightCosts2] [money] NULL , [Featured] [bit] NOT NULL Default (0) , [SalePrice] [money] NOT NULL Default (0) , [SaleStart] [datetime] NULL Default ('1/1/2050') , [SaleEnd] [datetime] NULL Default ('1/1/1900') , [DownLoad] [bit] NULL DEFAULT (0), [ZIPPassWord] [nvarchar] (30) , [DownLoadFile] [nvarchar] (255) , [Archive] [bit] NULL DEFAULT (1), [CreatedByUser] [int] NOT NULL , [BulkPriceLimit1] [int] NOT NULL DEFAULT (0) , [BulkPriceLimit2] [int] NOT NULL DEFAULT (0) , [BulkPriceLimit3] [int] NOT NULL DEFAULT (0) , [BulkPriceLimit4] [int] NOT NULL DEFAULT (0) , [BulkPriceLimit5] [int] NOT NULL DEFAULT (0) , [DateCreated] [datetime] NULL , [RoleID] [int] NULL, [SubscriptionPeriod] [int] NULL, [RecurringBilling] [bit] NULL, [TaxExempt] [bit] NULL , [ShipExempt] [bit] NULL , [InsuredValue] [money] NOT NULL DEFAULT (0) , [PublicationStart] [datetime] NULL Default ('1/1/1900') , [PublicationEnd] [datetime] NULL Default ('1/1/2050') , [Status] [char] (1) NOT NULL DEFAULT ('0') , [DonationItem] [bit] NOT NULL Default (0) , [PayPalSubscription] [bit] NOT NULL Default (0) , [UseRoleFees] [bit] NOT NULL Default (0) CONSTRAINT [PK_CAT_Products] PRIMARY KEY NONCLUSTERED ( [ProductID] ) ON [PRIMARY] ) ON [PRIMARY] System.Data.SqlClient.SqlException: The operation failed because an index or statistics with name 'IX_CAT_Products' already exists on table 'dbo.CAT_Products'. 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 INDEX [IX_CAT_Products] ON dbo.[CAT_Products]([CategoryID], [Category2ID], [Category3], [ProductName], [ProductNumber], [CreatedByUser], [Stock], [Featured], [SaleStart], [Archive], [SaleEnd], [DateCreated], [PublicationStart], [PublicationEnd], [Status]) ON [PRIMARY] |