Hi!
I have upgraded 6 sites now to 5.5 ( 4 test and developmentsites and 2 live sites ). In one instance , ofcourse in the first of the live sites I upgraded I get an error on the SQL provider. I have tracked it down to this part of the sql-code, edited to run in the SQL executor on the site :

/* Copy ModuleTitle, Header, Footer to TabModule table */
/*******************************************************/
-- this was done in 5.2.0 script - but any modules added since would not be updated - so redo
UPDATE dbo.TabModules
SET ModuleTitle = M.ModuleTitle,
Header = M.Header,
Footer = M.Footer
FROM dbo.Modules M
INNER JOIN dbo.TabModules TM ON M.ModuleID = TM.ModuleID
GO

Error message:
System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. Invalid column name 'Header'. Invalid column name 'Footer'. 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 ConnectionString, String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String ConnectionString, String Script) UPDATE dbo.TabModules SET ModuleTitle = M.ModuleTitle, Header = M.Header, Footer = M.Footer FROM dbo.Modules M INNER JOIN dbo.TabModules TM ON M.ModuleID = TM.ModuleID

Since it  only occurs once in 6 sites I do not know if I should report it in Gemini...
Any solution to this, or can I just ignore it?

BR
Jari Ivanoff

Hi! Thanks for Your answer!
The 05.02.00 log is empty and the table has the fields mentioned. I do have rights to alter table too..
It is also reported as a bug now.

BR
Jari

Hi again!
The Modules Table did not have the columns,  I added them and then the script executed without problems...

BR
Jari