I followed the usual upgrade procedure:
- did backups
- changed machine keys / object qualifier / connection strings in new web.config
- uploaded new files over top of old files
- visited site and...
Current Assembly Version: 04.05.00
Current Database Version: 04.00.02
00:00:00.046 - Executing Script: Upgrade.SqlDataProvider Success
Upgrade Status Report
00:00:00.968 - Upgrading to Version: 4.5.0
00:00:01.078 - Executing Script: 04.00.03.SqlDataProvider Success
00:00:01.359 - Executing Script: 04.00.04.SqlDataProvider Error! (see 04.00.04.log for more information)
00:00:04.406 - Executing Script: 04.00.05.SqlDataProvider Success
00:00:04.406 - Executing Script: 04.00.06.SqlDataProvider Success
00:00:04.421 - Executing Script: 04.00.07.SqlDataProvider Success
00:00:04.421 - Executing Script: 04.03.00.SqlDataProvider Success
00:00:04.500 - Executing Script: 04.03.01.SqlDataProvider Success
00:00:04.593 - Executing Script: 04.03.02.SqlDataProvider Success
00:00:04.796 - Executing Script: 04.03.03.SqlDataProvider Success
00:00:05.078 - Executing Script: 04.03.04.SqlDataProvider Success
00:00:05.125 - Executing Script: 04.03.05.SqlDataProvider Success
00:00:05.437 - Executing Script: 04.03.06.SqlDataProvider Success
00:00:05.984 - Executing Script: 04.03.07.SqlDataProvider Success
00:00:06.078 - Executing Script: 04.04.00.SqlDataProvider Error! (see 04.04.00.log for more information)
00:00:07.765 - Executing Script: 04.04.01.SqlDataProvider Success
00:00:07.859 - Executing Script: 04.05.00.SqlDataProvider Success
00:00:09.562 - Performing General Upgrades
00:00:10.468 - Installing Module File HTML_04.05.00_Install: Success
00:00:10.859 - Installing Module File Links_03.03.07_Install: Success
Upgrade Complete
I can now visit the site an everything is mostly ok (aside from some tweaking of the skin) but I'm nervous about the error.
The log (04.00.04) of the error in question:
System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
"FK_dnn_Files_dnn_Folders". The conflict occurred in database "spiasfljkjsdfdb", table "dbo.dnn_Folders",
column 'FolderID'.
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 (SELECT dbo.dnn_fn_GetVersion(3,2,3)) = 0
BEGIN
ALTER TABLE dbo.dnn_Files ADD CONSTRAINT
FK_dnn_Files_dnn_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.dnn_Folders
(
FolderID
)
END
(the other error logged was:
Error: HelpURL
which I read in another thread was ... not an issue. Though it still left me feeling nervous I'm marginally more accepting of this.)
Any suggestions about what I should do?