I'm trying to upgrade from 4.09.01 to 5.01.00 and I keep getting an error that refers me to
00:00:33.404 - Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information) (The full screen of upgrade messages is pasted at the bottom of this post.)
I have looked at the log for 05.01.00 and it says:
****************************************************************************************************************
System.Data.SqlClient.SqlException: Table 'EventLog' already has a primary key defined on it.
Could not create constraint. See previous errors.
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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Change primary key of EventLog Table */
/****************************************/
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dbo.EventLog' AND COLUMN_NAME = 'LogEventID')
BEGIN
--Note this name does NOT have an object qualifier in 4.x upgrades
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLogMaster
--Note this name does have an object qualifier in 5.x installs
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLogMaster
ALTER TABLE dbo.EventLog
ADD LogEventID bigint NOT NULL IDENTITY (1, 1)
ALTER TABLE dbo.EventLog
ADD CONSTRAINT PK_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )
END
*************************************************************************************************************************
I googled this issue for hours before writting here, and I found others with this issue. Only one reported getting through it, and he did so by refreshing the Network Service permissions on the root and subfolders before upgrading to 5.01.00. I have tried that and I still get the same error.
I have found one URL where Sebastian Leupold seems to give advice to ignore this error if the log implies that the problem is only with the eventID column for the eventlog table. The site is in German, and I can't read it, however Yahoo translated it for me and that's what I think he said. The translation is not perfect. Here is the link. It would be great if Sebastian were reading this post and could explain this statement in English. And could verify that is my situation as well.
http://www.dnn-usergroup.de/Community...
If that is true, then what happens to the rest of the upgrade script "05.01.00SqlDataProvider" when something in the middle has an error like this? Does the rest of the script go ahead and run? Or does it kick out of this script in the middle and move on to the next?
What can I do to resolve this error please,so that the upgrade will proceed without errors?
****************************************************************************************************
Upgrade Status Report
00:00:00.242 - Upgrading to Version: 05.01.00
00:00:05.988 - Executing Script: 04.09.01.SqlDataProvider Success
00:00:13.523 - Executing Script: 05.00.00.SqlDataProvider Success
00:00:31.316 - Executing Script: 05.00.01.SqlDataProvider Success
00:00:33.404 - Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:40.131 - Executing Application Upgrades: 04.09.01 Success
00:00:40.131 - Executing Application Upgrades: 05.00.00 Success
00:01:01.131 - Executing Application Upgrades: 05.00.01 Success
00:01:01.247 - Executing Application Upgrades: 05.01.00 Success
00:01:11.654 - Cleaning Up Files: 04.09.01 Success
00:01:11.689 - Cleaning Up Files: 05.00.00 Success
00:01:15.612 - Cleaning Up Files: 05.00.01 Success
00:01:15.878 - Cleaning Up Files: 05.01.00 Success
00:01:16.408 - Updating Config Files: 04.09.01 Success
00:01:16.408 - Updating Config Files: 05.00.00 Success
00:01:16.408 - Updating Config Files: 05.00.01 Success
00:01:16.420 - Updating Config Files: 05.01.00 Success
00:01:16.466 - Performing General Upgrades
00:01:19.962 - Installing Optional Modules:
00:01:20.205 - Installing Package File HTML_Community_05.01.00_Install: Success
00:01:50.309 - Installing Optional Skins:
00:01:50.321 - Installing Optional Containers:
00:01:50.321 - Installing Optional Languages:
00:01:50.321 - Installing Optional Providers:
00:01:50.367 - Installing Package File AspNetMembershipProvider_05.01.00_Install: Success
00:01:51.094 - Installing Package File CorePermissionProvider_05.01.00_Install: Success
00:01:52.432 - Installing Package File DatabaseLoggingProvider_05.01.00_Install: Success
00:01:53.713 - Installing Package File DNNMembershipProvider_05.01.00_Install: Success
00:01:54.901 - Installing Package File DNNMenuNavigationProvider_05.01.00_Install: Success
00:01:55.432 - Installing Package File DNNTreeNavigationProvider_05.01.00_Install: Success
00:01:56.194 - Installing Package File FckHtmlEditorProvider_02.00.04_Install: Success
00:02:26.345 - Installing Package File FileBasedCachingProvider_05.01.00_Install: Success
00:02:26.898 - Installing Package File SchedulingProvider_05.01.00_Install: Success
00:02:27.852 - Installing Package File SearchIndexProvider_05.01.00_Install: Success
00:02:28.635 - Installing Package File SearchProvider_05.01.00_Install: Success
00:02:29.288 - Installing Package File SolpartMenuNavigationProvider_05.01.00_Install: Success
00:02:29.850 - Installing Optional AuthSystems:
00:02:29.870 - Installing Package File LiveID_01.00.01_Install: Success
00:02:31.487 - Installing Package File OpenID_02.00.00_Install: Success
00:02:32.511 - Installing Optional Packages:
Upgrade Complete
Click Here To Access Your Portal