Getting an error installing DNN Community Edition 05.05.01 on a new install. Have installed a number of earlier versions of DNN.

This is on a Windows server with a separate MSSQL server on a web hosting company. Do not know what versions they are running of the OS.

Selected Custom install.

Getting error on the page Run Database Installation Scripts. Message says: Failure installing Database Scripts.

Installing Database - Version 05.00.00...Success
Upgrading Database to Version 05.00.01...Success
Upgrading Database to Version 05.01.00...FAILURE ERROR: (see 05.01.00.log for more information)

The 05.01.00.log.resources file has
System.Data.SqlClient.SqlException: Constraint 'PK_EventLogMaster' does not belong to table 'dnn_EventLog'.
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)

Hello Sebastian,

The collation on the database is SQL_Latin1_General_CP1_CI_AS.

Looks that is already case insensitive.

Thank you,
Andrew

please log the error at support.dotnetnuke.com (if not already been logged). Thank you.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN