Hi,
I was at DNN 4.03.07 and have successfully upgraded to 4.09.05 by upgrading from 4.03.07 to 4.4.1, then 4.4.1 to 4.6.2, then 4.6.2 to 4.09.05. Now I am attempting to upgrade to 05.01.04 and I get the following errors and the error logs are listed below. I click to access my portal after the upgrade and everything is a mess. Any ideas?
Upgrading DotNetNuke
Current Assembly Version: 05.01.04
Current Database Version: 04.09.05
Upgrade Status Report
00:00:00.015 - Upgrading to Version: 05.01.04
00:00:00.031 - Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
00:00:07.812 - Executing Script: 05.00.01.SqlDataProvider Error! (see 05.00.01.log for more information)
00:00:09.703 - Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:13.515 - Executing Script: 05.01.01.SqlDataProvider Error! (see 05.01.01.log for more information)
00:00:15.093 - Executing Script: 05.01.02.SqlDataProvider Error! (see 05.01.02.log for more information)
00:00:16.593 - Executing Script: 05.01.03.SqlDataProvider Error! (see 05.01.03.log for more information)
00:00:18.187 - Executing Script: 05.01.04.SqlDataProvider Error! (see 05.01.04.log for more information)
00:00:19.906 - Executing Application Upgrades: 05.00.00 Success
00:00:34.921 - Executing Application Upgrades: 05.00.01 Success
00:00:34.937 - Executing Application Upgrades: 05.01.00 Success
00:00:37.156 - Executing Application Upgrades: 05.01.01 Success
00:00:37.203 - Executing Application Upgrades: 05.01.02 Success
00:00:37.203 - Executing Application Upgrades: 05.01.03 Success
00:00:37.656 - Executing Application Upgrades: 05.01.04 Success
00:00:37.656 - Cleaning Up Files: 05.00.00 Success
00:00:37.906 - Cleaning Up Files: 05.00.01 Success
00:00:37.937 - Cleaning Up Files: 05.01.00 Success
00:00:38.046 - Cleaning Up Files: 05.01.01 Success
00:00:38.046 - Cleaning Up Files: 05.01.02 Success
00:00:38.046 - Cleaning Up Files: 05.01.03 Success
00:00:38.046 - Cleaning Up Files: 05.01.04 Success
00:00:38.046 - Updating Config Files: 05.00.00 Success
00:00:38.046 - Updating Config Files: 05.00.01 Success
00:00:38.046 - Updating Config Files: 05.01.00 Success
00:00:38.046 - Updating Config Files: 05.01.01 Success
00:00:38.046 - Updating Config Files: 05.01.02 Success
00:00:38.046 - Updating Config Files: 05.01.03 Success
00:00:38.046 - Updating Config Files: 05.01.04 Success
00:00:38.046 - Performing General Upgrades
00:00:38.156 - Installing Optional Modules:
00:00:38.156 - Installing Package File HTML_Community_05.01.04_Install: Error!
00:00:42.187 - Installing Optional Skins:
00:00:42.187 - Installing Package File DNN-MinimalExtropySkin_01.00.04_Install: Success
00:00:42.640 - Installing Optional Containers:
00:00:42.640 - Installing Package File DNN-MinimalExtropyContainer_01.00.04_Install: Success
00:00:42.796 - Installing Optional Languages:
00:00:42.796 - Installing Optional Providers:
00:00:42.796 - Installing Package File AspNetMembershipProvider_05.01.03_Install: Success
00:00:42.843 - Installing Package File CorePermissionProvider_05.01.01_Install: Success
00:00:42.859 - Installing Package File DatabaseLoggingProvider_05.01.01_Install: Success
00:00:42.906 - Installing Package File DNNMembershipProvider_05.01.03_Install: Success
00:00:42.937 - Installing Package File DNNMenuNavigationProvider_05.01.00_Install: Success
00:00:42.968 - Installing Package File DNNTreeNavigationProvider_05.01.00_Install: Success
00:00:43.031 - Installing Package File FckHtmlEditorProvider_02.00.04_Install: Success
00:00:45.421 - Installing Package File FileBasedCachingProvider_05.01.03_Install: Success
00:00:45.453 - Installing Package File SchedulingProvider_05.01.00_Install: Success
00:00:45.515 - Installing Package File SearchIndexProvider_05.01.00_Install: Success
00:00:45.562 - Installing Package File SearchProvider_05.01.01_Install: Success
00:00:45.593 - Installing Package File SolpartMenuNavigationProvider_05.01.00_Install: Success
00:00:45.625 - Installing Optional AuthSystems:
00:00:45.625 - Installing Package File LiveID_01.00.01_Install: Success
00:00:45.687 - Installing Package File OpenID_02.00.00_Install: Success
00:00:45.765 - Installing Optional Packages:
Upgrade Complete
ERROR LOG
System.Data.SqlClient.SqlException: Cannot find the object 'prSTSUpdateUserDefinedTableProperties', 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='dotnetnuke') 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 [dotnetnuke]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end
All help is appreciated!
Thanks!