I had a small error during the upgrade (ie site still seems to work fine)...
Upgrading DotNetNuke
Current Assembly Version: 04.05.01
Current Database Version: 04.05.00
Upgrade Status Report
00:00:00.031 - Upgrading to Version: 4.5.1
00:00:00.156 - Executing Script: 04.05.01.SqlDataProvider Error! (see 04.05.01.log for more information)
00:00:00.968 - Performing General Upgrades
00:00:01.515 - Installing Module File HTML_04.05.00_Install: Success
00:00:02.937 - Installing Module File Links_03.03.07_Install: Success
Upgrade Complete
and in the log...
System.Data.SqlClient.SqlException: Invalid object name 'Folders'.
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)
/* correct any File folderpaths which do not match the value in the Folders table */
update dnn_Files
set Folder = FolderPath
from Folders
where Files.FolderID = Folders.FolderID
and Folder <> FolderPath
It looks like the object qualifier doesn't exist on the "folders" object.
So, should I just rerun this from host > sql as:
update dnn_Files
set Folder = FolderPath
from dnn_Folders Folders
where dnn_Files.FolderID = dnn_Folders.FolderID
and Folder <> FolderPath
?
Or is there another solution? I've had enough problems in the past that I don't always jump at what seems to be the obvious solution -- at least before seeking consensus.
(and funny that this table is the one giving me problems -- as in my previous upgrade
www.dotnetnuke.com/Community/Forums/tabid/795/forumid/108/threadid/124706/scope/posts/Default.aspx
Just coincidental ... I hope.)