Hi everyone,
I am wondering if anyone can help me. I am working with a custom module on one of our sites, and I have uninstalled the module, but when I am trying to reinstall it I get the following error:
StartJob
Starting Installation
Info
Starting Installation - IMUK.Products Categories
Info
Starting Installation - Script
Info
Begin Sql execution
Info
Creating backup of previous version - 01.00.00.SqlDataProvider
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 (0x80131904): The ALTER TABLE
statement conflicted with the FOREIGN KEY constraint
"FK_IMUK_PR_Products_IMUK_PRD_Cats". The conflict occurred in database
"chiesiservicedb", table "dbo.IMUK_PRD_Cats", column 'CategoryId'.
at System.Data.SqlClient.SqlConnection. (SqlException
exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection. (SqlException
exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1
completion, String methodName, Boolean sendToPipe, Int32 timeout,
Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String
connectionString, String script)
ClientConnectionId:8e15c981-6e66-4118-a0fc-6ddcdcfc47f0
-- *************** Create relations (foreign keys) ******************
-- *** Create relations for IMUK_PR_Products ***
if not exists (select * from dbo.sysobjects where id =
object_id(N'FK_IMUK_PR_Products_IMUK_PRD_Cats') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE dbo.IMUK_PR_Products ADD CONSTRAINT
FK_IMUK_PR_Products_IMUK_PRD_Cats FOREIGN KEY (CategoryId)
REFERENCES dbo.IMUK_PRD_Cats (CategoryId)
Info
End Sql execution: 01.00.00.SqlDataProvider file
Info
Finished Sql execution
Failure
Installation Failed - Script
Info
Installation Failed - IMUK.Products Categories
Info
Starting Installation - IMUK.Products Products
Could someone perhaps give me an idea what I need to check in the database please.