We have the same Problem but we have wait also to the Version 05.01.00 and have tested this but we have here the same error by the 05.00.00 Update-Script.
Our Content from our 05.00.00.log is:
System.Data.SqlClient.SqlException: 'FK_EventLog_EventLogTypes' is not a constraint.
Could not drop 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)
/* Fix OobjectQualifier for PK_EventLogTypes */
/**********************************************/
ALTER TABLE dbo.EventLog
DROP CONSTRAINT FK_EventLog_EventLogTypes
ALTER TABLE dbo.EventLogConfig
DROP CONSTRAINT FK_EventLogConfig_EventLogTypes
ALTER TABLE dbo.EventLogTypes
DROP CONSTRAINT PK_EventLogTypes
ALTER TABLE dbo.EventLogTypes
ADD CONSTRAINT PK_EventLogTypes PRIMARY KEY CLUSTERED ( LogTypeKey )
ALTER TABLE dbo.EventLogConfig
ADD CONSTRAINT FK_EventLogConfig_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.EventLogTypes ( LogTypeKey ) ON UPDATE NO ACTION ON DELETE NO ACTION
ALTER TABLE dbo.EventLog
ADD CONSTRAINT FK_EventLog_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.EventLogTypes ( LogTypeKey ) ON UPDATE NO ACTION ON DELETE NO ACTION
Guido