Firstly I did an upgrade from 4.93 to 4.94 this succeeded flawlessly.... no problems or glitches at all.

Afterwards I did an upgrade of the same instance to 5.10 CE (773) ... but this failed miserably... The site still works but admin and host menus are crippled... and maybe something more (behind teh curtains ;))

The following is the upgradelog of teh failed instance...

I tried to use the 5.10 upgrade pacakge on multiple instances with the same results (IIS 7.5; SQL 2008 SP1)

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.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

Where normally the systemicons are located there is now a red 'X' which tells me that the picture (icon) could not be found. Besides the icons, there is normally the name of the menu, however, that is gone and replaced by an 'X' as well..., but if you click on teh 'X' it will redirect you normally to the configuration page of that menuheading...

It's not the whole menubar, only the "Admin" and "Host" menus that are crippled... I read some similar issues in this forum as well, but i'll have to look the up again to link to...