While upgrading from 05.04.00 to 05.05.00 (using the upgrade code), I received the error:
Executing Script: 05.05.00.SqlDataProvider Error! (see 05.05.00.log.resources for more information)
Reading the log at
/Providers/DataProviders/SqlDataProvider
The log said
System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
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()
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)
/* Fix incorrect culture codes assigned pre-5.5 */
/************************************************/
UPDATE dbo.Tabs
SET CultureCode = NULL
You
cannot fix the problem with this code:
UPDATE dbo.Tabs
SET CultureCode = NULL
WHERE CultureCode Is Not Null;
The reason is that the WHERE clause (as in my case) selected more than one row from the source table (see the first line of the log error).
Instead, run this code (assuming there are less than 110 rows in the dbo.Tabs table):
declare @counter int
set @counter = 0
while @counter < 110
begin
set @counter = @counter + 1
UPDATE dbo.Tabs
SET CultureCode = NULL
where TabID=@counter
end
This code supports my data mining portal implementation at
http://www.marktab.net