We recently received a SQL Server backup and a backup for site files to setup on our testing environment.

After setting everything up correctly, pointing the web.config file to our database server, and adding our IP to the PortalAlias table, I browse to the site to find that it needs to upgrade?  The upgrade process reports the following:

Current Assembly Version: 5.01.00
Current Database Version: 04.09.04

Note:  When I browse to the LIVE site and login as host, the host settings state that the version of DNN is 04.09.00.

If I run through the upgrade process on our testing environment, I receive the following

Upgrade Status Report

00:00:00.015 - Upgrading to Version: 05.01.00
00:00:00.171 -   Executing Script: 05.00.00.SqlDataProvider Success
00:00:01.875 -   Executing Script: 05.00.01.SqlDataProvider Success
00:00:02.218 -   Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:03.750 -   Executing Application Upgrades: 05.00.00 Success
00:00:06.969 -   Executing Application Upgrades: 05.00.01 Success
00:00:06.984 -   Executing Application Upgrades: 05.01.00 Success
00:00:08.891 -   Cleaning Up Files: 05.00.00 Success
00:00:08.891 -   Cleaning Up Files: 05.00.01 Success
00:00:08.891 -   Cleaning Up Files: 05.01.00 Success
00:00:08.891 -   Updating Config Files: 05.00.00 Success
00:00:08.891 -   Updating Config Files: 05.00.01 Success
00:00:08.891 -   Updating Config Files: 05.01.00 Success
00:00:08.891 - Performing General Upgrades
00:00:09.828 - Installing Optional Modules:
00:00:09.828 - Installing Optional Skins:
00:00:09.828 - Installing Optional Containers:
00:00:09.828 - Installing Optional Languages:
00:00:09.828 - Installing Optional Providers:
00:00:09.828 - Installing Optional AuthSystems:
00:00:09.828 - Installing Optional Packages:

Upgrade Complete

 

After upgrading the site, if/when I can log in as Host, the site states that it is running DNN 04.09.00.

Has anyone seen this before?

Thanks for the quick reply Sebastian,

Ideally we are only trying to get the site up and running before attempting any upgrade... and there in lies the problem.  We were told we were given backup files of the current site and database, but when we use those files to re-create the site, we are faced with an automatic upgrade procedure...

Here is the contents of the 05.01.00.log file.

System.Data.SqlClient.SqlException: Table 'EventLog' already has a primary key defined on it.
Could not create 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.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.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_EventLogMaster'))
   ALTER TABLE dbo.EventLog
    DROP CONSTRAINT PK_EventLogMaster

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

Sebastian, I've checked the site files and the database user and all permissions seem to be in order.
I'm going to continue working on this, but at the moment I'm left scratching my head... None of us have seen behavior like this before...

Thanks again for your feedback.