Hi, I'm having major problems upgrading to 4.5.1. I had a working DNN installation, but the upgrade failed. As this was a new site, there wasn't much content, so I thought it would be easier to start from scratch (I had installed a custom skin and XMod so thought there could be a conflict there somewhere).

So, I deleted the entire DNN installation and the SQL2005 db and started a fresh installation of 4.5.0 (CrystalTech automated). This was successful. Before I did anything else, I went through the procedure to upgrade to 4.5.1. Despite following the steps in Mitchel Sellers upgrade guide, I received the following error:

00:00:00.031 - Installing Version: 4.4.0
00:00:00.046 - Executing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.343 - Executing Script: DotNetNuke.Schema.SqlDataProvider Error! (see DotNetNuke.Schema.log for more information)
00:00:26.047 - Executing Script: DotNetNuke.Data.SqlDataProvider Error! (see DotNetNuke.Data.log for more information)
00:00:26.875 - Installing MemberRole Provider:
00:00:26.875 - Executing Script: InstallCommon.sql
00:00:27.953 - Executing Script: InstallMembership.sql
00:00:28.719 - Executing Script: InstallProfile.sql
00:00:29.031 - Executing Script: InstallRoles.sql
00:00:29.594 - Upgrading to Version: 4.5.1
00:00:29.625 - Executing Script: 04.04.01.SqlDataProvider Success
00:00:29.859 - Executing Script: 04.05.00.SqlDataProvider Success
00:00:31.828 - Executing Script: 04.05.01.SqlDataProvider Success
00:00:32.000 - Performing General Upgrades
00:00:32.953 - Loading Host Settings:
00:00:33.375 - Configuring SuperUser:
00:00:33.672 - Installing Modules:
00:00:33.672 - Executing Additional Scripts:
00:00:33.687 - Creating Portal: My Website
00:00:33.828 - Error: Error creating Profile Definitions
00:00:33.828 - Portal failed to install:Error!
00:00:33.828 - Installing Optional Resources:

Installation Complete

Viewing the Schema log shows the following errors:

System.Data.SqlClient.SqlException: There is already an object named 'PK_EventLogMaster' in the database.
System.Data.SqlClient.SqlException: There is already an object named 'PK_EventLogTypes' in the database.
System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.EventLogTypes' that match the referencing column list in the foreign key 'FK_EventLog_EventLogTypes'.
System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.EventLogTypes' that match the referencing column list in the foreign key 'FK_EventLogConfig_EventLogTypes'.

and the Data log:

System.Data.SqlClient.SqlException: 'FK_EventLogConfig_EventLogTypes' is not a constraint.

This is the error in the browser:
Server Error in '/' Application.
Runtime Error

What have I done wrong? More importantly, how do I correct it? Whilst I could delete everything and start again, I'm going to be confronted with the same problem! All help much appreciated.

Hi there, I meant to say, your [b]excellent[/b] guide :) .

I did actually delete everything and start again. CrystalTech's install is now at 4.5.0, so I thought I'd leave the upgrade for now. But to answer your question, I did have an installation date setting, and I copied that over from the saved web.config.old: into the new web.config.

Is that good or bad that there is one?

(I come in peace from the land of ColdFusion, so am on a bit of a learning curve with ASP.NET :) )

If it runs the 4.4.0 script again then it is probably because that is what version it thinks the DB is at (Versions table).

The output of that upgrade looks like new install to me.  Maybe the {objectQualifier} or {databaseOwner} were different so it tried to install a fresh copy (still should have worked though).

---