I got this in my 04.05.01.log file.  I assume I was supposed to run the query below the error (I did and I got no errors and now I'm crossing my fingers that I did the right thing???)

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 

Mitchel,

Thanx for the reply.  I think that the query is the problem.  It doesn't seem to use the same qualifiers throughout the query.  Notice it's updating dnn_files (that's correct for my install) but doesn't apply the same object qualifier to the joins.