We have also so a problem with a Update from 04.09.02 to 05.01.00 CE.
What we have made by the first Test:
- Update to 05.01.00 CE (Backup-DB,Backup-Files,Customizer new web.config, copy updatefiles over the running version and start the Update)
- The first Update-Script is for Version 05.00.00 (No Update-Script for Version 04.09.04?) here is displayed the first errror and the Info to look in the Log
- The second Script is 05.01.00, here comes the second Error and also the info to look in the log.
We think that here is a Problem with the update from Version 04.09.02 to 05.00.01 goes back to Version 04.09.02 and made folled Steps:
- The 1. Update-Script is for Version 04.09.04 here is all ok
- The 2. Update-Script is for Version 05.00.00 here is displayed the first errror and the Info to look in the Log
- The 3. Update Script is 05.00.01, here comes a OK.
Content from Log 05.00.00.log is follwed:
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