Trying upgrade from 5.1.0 to 5.1.1 on my test installation i got this error.

System.Data.SqlClient.SqlException: Column name 'LogEventID' does not exist in the target table or view.
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)

/************************************************************/
/***** SqlDataProvider *****/
/***** *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for dbo. and *****/
/***** *****/
/************************************************************/


/* Fix bug in changing the primary key of EventLog Table */
/*********************************************************/

--Some scenarios had the primary key as PK_EventLog
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLog'))
BEGIN
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLog

ALTER TABLE dbo.EventLog
ADD CONSTRAINT PK_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )
END

Thanks, Sandro

---

Sandro De Matteis Microsoft IT Pro: Enterprise Admin, Enterprise Messaging Admin Technology Specialist: Microsoft Virtualization Dnn portals: http://www.dbdog.it , http://www.royalcrestgoldn.it, http://www.retrieversclub.it

Ok so the fix for the 5.1.0 Script error didn't account for the column not being added in the 5.1.0 script.

As with the original issue it is not critical (it is a nuisance as you don;t get the perf improvements with a different index)

We will get it right in 5.1.2 :)

---

Charles Nurse Chief Architect Evoq Content Team Lead, DNN Corp. Want to contribute to the Platform project? - See here

MVP (ASP.NET) and ASPInsiders Member