On my upgrade today, I got a foreign key constriant problem. Anyone have ideas? Error:
26% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): Introducing FOREIGN KEY constraint 'FK_FolderPermission_Users' on table 'FolderPermission' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Could not create constraint. See previous errors.
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:98faf03e-77b4-4f3f-9b56-ede91781371a
ALTER TABLE dbo.[FolderPermission]
ADD CONSTRAINT FK_FolderPermission_Users FOREIGN KEY (UserId)
REFERENCES dbo.[Users] (UserId)
ON UPDATE NO ACTION
ON DELETE CASCADE