Hi,
I am getting the following error when attempting to upgrade my website on my production machine. The odd thing is that on my test server the upgrade works fine. I checked file permissions on my production machine and test machine, and the root of my website has the same permissions on both machines. I ran the upgrade on my production server, but it failed. I realized I was authenticating to the database using the sa user account in my webconfig on my test server, but on my production server I was authenticating using a user ID "BrookhavenDNN" that had DBOwner priveliges to my website db. After the upgrade failed, I restored my website (it worked fine after restor), but I noticed in [websiteroot]\Providers\DataProviders\SqlDataProvider there were "05.00.00.SqlDataProvider" files through "05.02.03.SqlDataProvider" without any corresponding log files. Before the failed upgrade, these files were not present, there were only SqlDataProvider files up to 4.9.5(my current version of DNN) with log files. I don't think this is a problem because I grabbed a back-up of website after the failed production upgrade and ran the upgrade on my test without a problem. The next day I changed my the connection settings in my webconfig to login to the db using the sa user account on my production server, however the upgrade failed with the below log errors. I am getting errors on the 5.00.00, 5.01.01, and 5.02.00 logs and not the rest of them.
5.00.00 log
System.Data.SqlClient.SqlException: There is already an object named 'GetPackageTypes' in the database.
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)
5.01.01 log
System.Data.SqlClient.SqlException: There is already an object named 'Tmp_Packages' in the database.
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)
5.02.00 log
System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'FriendlyName' in table 'dbo.Schedule' is specified more than once.
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)
Thanks in advance!
Matt