I have tried to upgrade about 20 times from 4.9.5. First I tried to go to 5.4.4 (
http://www.dotnetnuke.com/Community/F... ) and then gave up because many of the errors are fixed in 5.5.0.532. Using the beta 5.5 did fix all the upgrade errors, except for one:
00:00:02.116 - Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log.resources for more information)
and when I click on the link to go to the site, the page just shows the DotNetNuke error page, with two copies of "An error has occurred." I have done many searches here to find a clue, and I think it might be because I (foolishly?) used an object qualifier when I first set up this site (dnn_).
Here is what the log says:
System.Data.SqlClient.SqlException: 'PK_EventLogMaster' 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.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)
/* Fix OobjectQualifier for PK_EventLogMaster */
/**********************************************/
ALTER TABLE dbo.dnn_EventLog
DROP CONSTRAINT PK_EventLogMaster
ALTER TABLE dbo.dnn_EventLog
ADD CONSTRAINT PK_dnn_EventLog PRIMARY KEY CLUSTERED ( LogGUID )
System.Data.SqlClient.SqlException: 'PK_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.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)
/* Fix OobjectQualifier for PK_EventLogTypes */
/**********************************************/
ALTER TABLE dbo.dnn_EventLog
DROP CONSTRAINT FK_dnn_EventLog_dnn_EventLogTypes
ALTER TABLE dbo.dnn_EventLogConfig
DROP CONSTRAINT FK_dnn_EventLogConfig_dnn_EventLogTypes
ALTER TABLE dbo.dnn_EventLogTypes
DROP CONSTRAINT PK_EventLogTypes
ALTER TABLE dbo.dnn_EventLogTypes
ADD CONSTRAINT PK_dnn_EventLogTypes PRIMARY KEY CLUSTERED ( LogTypeKey )
ALTER TABLE dbo.dnn_EventLogConfig
ADD CONSTRAINT FK_dnn_EventLogConfig_dnn_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.dnn_EventLogTypes ( LogTypeKey ) ON UPDATE NO ACTION ON DELETE NO ACTION
ALTER TABLE dbo.dnn_EventLog
ADD CONSTRAINT FK_dnn_EventLog_dnn_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.dnn_EventLogTypes ( LogTypeKey ) ON UPDATE NO ACTION ON DELETE NO ACTION
I'm not quite sure what this means, but it looks like it is trying to fix the object qualifier on the EventLog table, yes?
Any ideas on how I can get this to work?