I have an install of 4.4.1 and want to upgrade to 4.5.1.  I have followed the upgrade instructions but get errors during the execution of the sql scripts and nothing works after(get nice asp.net error).  One very curious thing is that when I navigate to the site to start the upgrade process(after very carefully following the upgrade instructions found here) I actually get the Installation Wizard screen as opposed to an Upgrade Wizard screen as I have read about in other posts.  After it is done I get this:

Version: 04.05.01

Installation Status Report

00:00:00.031 - Installing Version: 4.4.0
00:00:00.031 -   Executing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.093 -   Executing Script: DotNetNuke.Schema.SqlDataProvider Error! (see DotNetNuke.Schema.log for more information)
00:00:04.953 -   Executing Script: DotNetNuke.Data.SqlDataProvider Error! (see DotNetNuke.Data.log for more information)
00:00:06.500 - Installing MemberRole Provider:
00:00:06.500 -   Executing Script: InstallCommon.sql
00:00:07.125 -   Executing Script: InstallMembership.sql
00:00:07.625 -   Executing Script: InstallProfile.sql
00:00:07.843 -   Executing Script: InstallRoles.sql
00:00:08.187 - Upgrading to Version: 4.5.1
00:00:08.203 -   Executing Script: 04.04.01.SqlDataProvider Success
00:00:08.343 -   Executing Script: 04.05.00.SqlDataProvider Success
00:00:09.359 -   Executing Script: 04.05.01.SqlDataProvider Success
00:00:09.546 - Performing General Upgrades
00:00:10.421 - Loading Host Settings:
00:00:10.578 - Configuring SuperUser:
00:00:10.734 - Installing Modules:
00:00:10.750 - Executing Additional Scripts:
00:00:10.750 -   Creating Portal: My Website
00:00:10.890 -   Error: Error creating Profile Definitions
00:00:10.890 -   Portal failed to install:Error!
00:00:10.890 - Installing Optional Resources:

Installation Complete

Click Here To Access Your Portal

Then I get "Object reference not set to an instance of an object" when I click the link or navigate to the site.  Why would it be installing version 4.4.0 when Im on 4.4.1?  It just doesn't seem to be doing the upgrade correctly and I don't have any clue as to why.  Any help or advice would be greatly appreciated.

-Steve

Here is the DotNetNuke.Schema.log file:

System.Data.SqlClient.SqlException: There is already an object named 'PK_EventLogMaster' in the database.
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)

ALTER TABLE dbo.[EventLog] ADD CONSTRAINT [PK_EventLogMaster] PRIMARY KEY CLUSTERED  ([LogGUID])

System.Data.SqlClient.SqlException: There is already an object named 'PK_EventLogTypes' in the database.
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)

ALTER TABLE dbo.[EventLogTypes] ADD CONSTRAINT [PK_EventLogTypes] PRIMARY KEY CLUSTERED  ([LogTypeKey])

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'.
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)

ALTER TABLE dbo.[EventLog] ADD
CONSTRAINT [FK_EventLog_EventLogTypes] FOREIGN KEY ([LogTypeKey]) REFERENCES dbo.[EventLogTypes] ([LogTypeKey]),
CONSTRAINT [FK_EventLog_EventLogConfig] FOREIGN KEY ([LogConfigID]) REFERENCES dbo.[EventLogConfig] ([ID])

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'.
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)

ALTER TABLE dbo.[EventLogConfig] ADD
CONSTRAINT [FK_EventLogConfig_EventLogTypes] FOREIGN KEY ([LogTypeKey]) REFERENCES dbo.[EventLogTypes] ([LogTypeKey])

The DotNetNuke.Data.log file is very long and the only error I could find in it is the following:

System.Data.SqlClient.SqlException: 'FK_EventLogConfig_EventLogTypes' is not a constraint.
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)

The other log files are blank.  It seems to me that it is running a db script for 4.4.0 when my current install version is past that at 4.4.1......just a guess, but I hope this can give you a clue.

-Steve

I have found the problem........I inherited this installation from someone else and didn't know it was previously setup with a

objectQualifier="dnn_"

I inserted this into the web.config along with the connection strings, InstallationDate, machine keys and the upgrade seems to have worked perfectly.  Funny how one little mistake on my part blew up the entire upgrade.  Thanks for the help though.

-Steve