I have set up MS SQL 2008 DB, changed the settings inthe Web.config file, installed virtual dir on folder (www.myweb.com/portal) and ran the install wizard. The first step using custom option which completes ok. We use an object qualifier 'lwg_'  then when it gets to running the DB scripts the following progress shows:

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 error log is:
System.Data.SqlClient.SqlException: Constraint 'PK_EventLogMaster' does not belong to table 'lwg_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)

/* Change primary key of EventLog Table */
/****************************************/

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dbo.lwg_EventLog' AND COLUMN_NAME = 'LogEventID')
 BEGIN
  --Note this name does NOT have an object qualifier in 4.x upgrades
  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
   ALTER TABLE dbo.lwg_EventLog
    DROP CONSTRAINT PK_EventLogMaster

  --Note this name does have an object qualifier in 5.x installs
  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_lwg_EventLogMaster'))
   ALTER TABLE dbo.lwg_EventLog
    DROP CONSTRAINT PK_lwg_EventLogMaster

  --Some scenarios have the primary key as PK_lwg_EventLog
  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_lwg_EventLog'))
   ALTER TABLE dbo.lwg_EventLog
    DROP CONSTRAINT PK_lwg_EventLog

  ALTER TABLE dbo.lwg_EventLog
   ADD LogEventID bigint NOT NULL IDENTITY (1, 1)
   
  ALTER TABLE dbo.lwg_EventLog
   ADD CONSTRAINT PK_lwg_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )  
 END

Any help on what to do to sort this out?

I would ignore it, if the install wizard continued, but it stops at this point and the Next button doesn't get enabled.

I set up a site with 5.2.2 a while ago and I didn't have this issue. I was thinking of deleting what's in the DB and the site folder and starting again with 5.2.2.

Any advise?

I abandoned using the 5.2.3 install and went back to 5.2.2 Install zip file which worked previously. SAME ERROR!! The DB scripts stop running at the same place and the Install Wizard stops. The difference between the 5.2.2 installation I did successfully some time back and this one is that the successful install went into an EMPTY MSSQL 2008 database. This installation is using a database MSSQL 2008 DB with other tables in it, including a DNN installation WITHOUT a prefix qualifier.

The picture is 5.2.2 install into clean DB worked.
5.2.2 and 5.2.3 installs (using Prefix qalifier "lwg_") into DB with another DNN without prefix qualifier.

Where are the DB scripts the Install Wizard uses, maybe I can find the problem there, fix it and move on - ANY help please.