Looking for the old forum?

For topics posted before June 2015, please click here to visit the old support forum. Post your questions in this forum if you have any questions.

Support Forums
PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 14 Dec 2015 12:44 PM by  Duane Sims
Update Error
 1 Replies
You are not authorized to post a reply.
Author Messages

New Member

New Member

14 Dec 2015 12:44 PM
    When upgrading to v1.79 I got the following failure
    SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_FlexEventCategory_Category". The conflict occurred in database "DBRDB2012", table "dbo.FlexCategory", column 'ItemId'. at System.Data.SqlClient.SqlConnection.OnError(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:7ce10650-14c8-4c89-8373-84924e796bb7 Error Number:547,State:0,Class:16 IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'FK_FlexEventCategory_Category') AND parent_object_id = OBJECT_ID(N'dbo.FlexEventCategory')) ALTER TABLE dbo.FlexEventCategory WITH CHECK ADD CONSTRAINT FK_FlexEventCategory_Category FOREIGN KEY(CategoryId) REFERENCES dbo.FlexCategory (ItemID) ON DELETE CASCADE
    Info End Sql execution: datatables.SqlDataProvider file

    Basic Member

    Basic Member

    23 Dec 2015 08:53 PM
    it seems to be caused by corrupted data.

    if you are still in trouble with it, can you send me your host password so I an manually correct it for you?
    You are not authorized to post a reply.

    Copyright © 2005-2013 BizModules Contact us