First of all backups were made, db restored to SQL2005 test environment. DNN490 Website content copied over test-IIS7 enviroment. I changed the db compatibility mode to 90 (SQL2005).
All looks working ok, testsite is working without any problem, also no module problems. So I proceeded with DNN5.2.1 upgrade.

The upgrade gave the following result:
 

 

I have three problems now:
problem1: The sqldataprovider logs all contain only one error, which are all the same for all 9 log files:
"System.Data.SqlClient.SqlException: Cannot find the object 'ColumnAlreadyExists', because it does not exist or you do not have permission.
   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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantUserDefinedFunctionsPermission(String ScalarPermission, String TablePermission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='media7_dnn50')  begin    declare @exec nvarchar(2000)     declare @name varchar(150)     declare @isscalarfunction int     declare @istablefunction int     declare sp_cursor cursor for select o.name as name, OBJECTPROPERTY(o.id, N'IsScalarFunction') as IsScalarFunction     from dbo.sysobjects o     where ( OBJECTPROPERTY(o.id, N'IsScalarFunction') = 1 OR OBJECTPROPERTY(o.id, N'IsTableFunction') = 1 )       and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0       and o.name not like N'#%%'       and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_')     open sp_cursor     fetch sp_cursor into @name, @isscalarfunction     while @@fetch_status >= 0       begin         if @IsScalarFunction = 1           begin            select @exec = 'grant EXECUTE on [' +  @name  + '] to [media7_dnn50]'            execute (@exec)            fetch sp_cursor into @name, @isscalarfunction            end         else           begin            select @exec = 'grant SELECT on [' +  @name  + '] to [media7_dnn50]'            execute (@exec)            fetch sp_cursor into @name, @isscalarfunction            end       end     deallocate sp_cursor  end
"
Strange is that I cannot find the failing SQL statement in the install/05.00.00 SQLDataprovider scripts. I searched the forums, and If I understand it correctly this error is generated because it tries to grant some rights to the SQL user on this database. However the dbuser has dbo rights, so probably I can forget about this error. There are no other errors in de db upgrade logs

 

 

problem2: The TextHTML module 5.2.0 is not installed and the old 4.x module does only display exceptions.
First I tried to install the module manually, as I could not find the error-log for the failed install during upgrade. (Are those errorlogs stored somewhere???).
The manual install failed with the errors "System.Data.SqlClient.SqlException: Invalid column name 'DesktopHtml'. Invalid column name 'CreatedByUser'. Invalid column name 'CreatedDate'. Invalid column name 'CreatedByUser'. Invalid column name 'CreatedDate'. ......."
I opened the db in SQL Studio and listed db content. And indeed the script tries to drop columns which do really not exist.
I searched the forum and found multiple matches for my problem, but not a real solution that works. (checked form threads 321905, 342696, 333683, 345323, 322576). Any clue how to fix this? Just install the binaries of the html module manually?

problem3: Host settings not working
My problem is exactly as in thread: http://www.dotnetnuke.com/Community/F... (exception DotNetNuke.Services.Exceptions.ModuleLoadException: Property accessor 'filteredkey' on object 'VB$AnonymousType_1`2[[System.String, mscorlib, Version=2.0.0.0, Culture=neutral,.... ), however I cannot find a real solution in the forums either.
My web.config is ok, checked 3 times. I even did the upgrade a second time after restoring backup, but nothing helped. My hosting provider runs at ASP3.5 SP1 he says.

 

Thanks for any input, however the forum does not respond very well (exceptions, errors), so probably many others have issues at the moment, or using the new year to get their sites upgraded like me I guess???

 

Best regards, Jan-Pieter