Wow,

Worst experience ever with DNN after 9 years.  I upgraded my site and it died with the following sql exception:

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. (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

Any suggestions would be greatly appreciated.

Site now in a broken state.  Hope my backups are good.