I did my first few attempts that upgrading today. The process was:
1. Backup files and database at PowerDNN
2. Copy zip file to local host (have to stop/restart IIS and sometimes reboot to
Delete files.) Note: I already have a old local copy working on the localhost/ASI3
3. Restore files.
Delete old local database and create/restore the PowerDNN backup database
Add ASPNET as database user with db_owner rights
4. Edit web.config to:
Local database info
Disable PageBlaster and iFinity’s Friendly URL
Enable debugging
5. In Firefox goto http://localhost/asi3 to test that the site works ok, which it does
6. Unzip the Upgrade version of DNN522 in a directory and copy the files into the web root of my localhost site.
7. goto http://localhost/ASI3 and watch the upgrade occur

8. Try to fix errors and loop thru this process as needed = Yuk

My log files show the same error while upgrading:
System.Data.SqlClient.SqlException: Cannot find the object 'NTForums_GetForumsByGroup2', 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.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='public') begin declare @exec nvarchar(2000) declare @name varchar(150) declare sp_cursor cursor for select o.name as name from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 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 while @@fetch_status >= 0 begin select @exec = 'grant EXECUTE on [' + @name + '] to [public]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end

The rest of the log looks ok except that the “Community line” just has an "error"  with no text or description.

When I goto to the site I get

Line 119: Public Overrides Function GetHtmlText(ByVal moduleId As Integer) As IDataReader
Line 120: Return CType(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner & ObjectQualifier & "GetHtmlText", moduleId), IDataReader)
Line 121: End Function

Removing Active Forums which I don’t use and “appears” to be part of the database problem doesn’t help.

Any suggestions?