The problem is I am doing an upgrade not a fresh install so a blank db wont work.

Not sure how to do the case insensitive collation

5.0.1.2 Log File

System.Data.SqlClient.SqlException: Cannot find the object 'front_teamName', because it does not exist or you do not have permission.
Cannot find the object 'front_contactInfo', because it does not exist or you do not have permission.
Cannot find the object 'front_eventCategory', because it does not exist or you do not have permission.
Cannot find the object 'displayMax', because it does not exist or you do not have permission.
Cannot find the object 'filenamePage', because it does not exist or you do not have permission.
Cannot find the object 'findDeepest', because it does not exist or you do not have permission.
Cannot find the object 'homePageID', because it does not exist or you do not have permission.
Cannot find the object 'isRedirect', because it does not exist or you do not have permission.
Cannot find the object 'mainMenu', because it does not exist or you do not have permission.
Cannot find the object 'otherParents', because it does not exist or you do not have permission.
Cannot find the object 'selectChildren', because it does not exist or you do not have permission.
Cannot find the object 'selectChildrenAdmin', because it does not exist or you do not have permission.
Cannot find the object 'selectGrandparents', because it does not exist or you do not have permission.
Cannot find the object 'selectNextChildren', because it does not exist or you do not have permission.
Cannot find the object 'selectPage', because it does not exist or you do not have permission.
Cannot find the object 'selectParentStatus', because it does not exist or you do not have permission.
Cannot find the object 'selectSiblings', because it does not exist or you do not have permission.
Cannot find the object 'selectStaged', because it does not exist or you do not have permission.
Cannot find the object 'subMenu', because it does not exist or you do not have permission.
Cannot find the object 'subMenuAdmin', because it does not exist or you do not have permission.
Cannot find the object 'admin_councilDetails', because it does not exist or you do not have permission.
Cannot find the object 'admin_councils', because it does not exist or you do not have permission.
Cannot find the object 'admin_deleteEvent', because it does not exist or you do not have permission.
Cannot find the object 'admin_deleteRegistrant', because it does not exist or you do not have permission.
Cannot find the object 'admin_deleteUser', because it does not exist or you do not have permission.
Cannot find the object 'admin_distinctEvents', because it does not exist or you do not have permission.
Cannot find the object 'admin_distinctTeams', because it does not exist or you do not have permission.
Cannot find the object 'admin_eventCouncils', because it does not exist or you do not have permission.
Cannot find the object 'admin_eventDetails', because it does not exist or you do not have permission.
Cannot find the object 'admin_insertEvent', because it does not exist or you do not have permission.
Cannot find the object 'admin_insertUser', because it does not exist or you do not have permission.
Cannot find the object 'admin_logon', because it does not exist or you do not have permission.
Cannot find the object 'admin_registrantDetails', because it does not exist or you do not have permission.
Cannot find the object 'admin_updateCouncil', because it does not exist or you do not have permission.
Cannot find the object 'admin_updateEvent', because it does not exist or you do not have permission.
Cannot find the object 'admin_updateUser', because it does not exist or you do not have permission.
Cannot find the object 'admin_userDetails', because it does not exist or you do not have permission.
Cannot find the object 'admin_usersByCouncil', because it does not exist or you do not have permission.
Cannot find the object 'front_distinctCities', because it does not exist or you do not have permission.
Cannot find the object 'front_eventDetails', because it does not exist or you do not have permission.
Cannot find the object 'front_eventsByCity', because it does not exist or you do not have permission.
Cannot find the object 'front_eventsByCity_fa', because it does not exist or you do not have permission.
Cannot find the object 'front_eventsByCity_sp', because it does not exist or you do not have permission.
Cannot find the object 'front_eventsByCity_su', because it does not exist or you do not have permission.
Cannot find the object 'front_eventsByCity_wi', because it does not exist or you do not have permission.
Cannot find the object 'front_insertRegistrant', 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='scoutsdnn01')  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 [scoutsdnn01]'        execute (@exec)        fetch sp_cursor into @name       end     deallocate sp_cursor  end

If you need anyother please let me know.

Nolan

I am using 04.09.00

YEs

Do I need to restore my files or can I just put back the old web.config file.

Nolan

The upgrade seems to have worked but I have three questions.

1. is the admin and host buttons at the top supposed to do anything, nothing happens when I click on them.

2. I get this message but I have .Net 3.5 installed:

Note: You are running on an old version of the .NET Framework. Future upgrades of the DotNetNuke platform will require .NET 3.5 SP1 or later. If you believe you are running .NET 3.5 SP1 already, please check your web.config file and ensure that the 3.5 or above versions of both System.Core and System.Data.Linq are referenced in the assemblies node.

3. When I go to module definitions ( I am assuming that is where I add modules now) I get this:

Error: Module Definitions is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: C:\Inetpub\wwwroot\dnn\Admin\ModuleDefinitions\ModuleDefinitions.ascx.vb(61): error BC30311: Value of type 'String' cannot be converted to 'System.Version'. ---> System.Web.HttpCompileException: C:\Inetpub\wwwroot\dnn\Admin\ModuleDefinitions\ModuleDefinitions.ascx.vb(61): error BC30311: Value of type 'String' cannot be converted to 'System.Version'. at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc) at DotNetNuke.UI.Modules.ModuleHost.LoadModuleControl() --- End of inner exception stack trace ---

Nolan