Hello Joe,
I have 5.2.3 running on powerdnn in fact I have already done as you suggested I brought down a backup they specifically made for me manually since the one I did via the backup manager on their Plesk Control Panel got corrupted and they told me this can happen if you aren't using Plesk to interface with your IIS 7.5 so they just went ahead and made this backup for me manually not using Plesk to do it.
At any rate I have tried the upgrade several times and using different version upgrades from 5.2.3 but get these errors anyway.
Now I will say this that I found that when I first downloaded the fresh backup from powerdnn that I did have to go into my site and uninstall two modules as it was interfering with my upgrade and that is the chat module and the xml/xls module. The chat module came off without incident but the xml module had some issues which are seen below
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Info
Reading Component Manifest - Script
Info
Reading Component Manifest - Cleanup
Info
Reading Component Manifest - Cleanup
Info
Reading Component Manifest - Cleanup
Info
Reading Component Manifest - Module
Info
Module Manifest read successfully
Info
Reading Component Manifest - File
Info
Reading Component Manifest - File
StartJob
Starting Package Uninstall
Info
Starting Package Uninstall - DNN_XML
Info
Starting Component Uninstall - Script
Info
Begin Sql UnInstall
Info
Deleted - Providers\DataProviders\SqlDataProvider\03.03.00.SqlDataProvider
Info
Deleted - Providers\DataProviders\SqlDataProvider\03.03.02.SqlDataProvider
Info
Deleted - Providers\DataProviders\SqlDataProvider\04.03.02.SqlDataProvider
Info
Deleted - Providers\DataProviders\SqlDataProvider\04.03.04.SqlDataProvider
Info
Folder Deleted - SqlDataProvider
Info
Folder Deleted - DataProviders
Info
Folder Deleted - Providers
Info
Executing Uninstall.SqlDataProvider
Info
Start Sql execution: Uninstall.SqlDataProvider file
Failure
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.stevenson_Xml_Parameter_AddParameter', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.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) /** Drop Stored Procedures **/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.[stevenson_Xml_Parameter_Add]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.stevenson_Xml_Parameter_AddParameter System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.stevenson_Xml_Parameter_GetParameters', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.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) IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.[stevenson_Xml_Parameter_GetList]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.stevenson_Xml_Parameter_GetParameters System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.stevenson_Xml_Parameter_GetParameter', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.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) IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.[stevenson_Xml_Parameter_Get]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.stevenson_Xml_Parameter_GetParameter System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.stevenson_Xml_Parameter_UpdateParameter', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.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) IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.[stevenson_Xml_Parameter_Update]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.stevenson_Xml_Parameter_UpdateParameter System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.stevenson_Xml_Parameter_DeleteParameter', because it does not exist or you do not have permission. at System.Data.SqlClient.SqlConnection.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) IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.[stevenson_Xml_Parameter_Delete]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE dbo.stevenson_Xml_Parameter_DeleteParameter System.Data.SqlClient.SqlException: Incorrect syntax near '*'. at System.Data.SqlClient.SqlConnection.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) DELETE * FROM stevenson_ModuleSettings WHERE SettingName Like N'XML_%' DELETE * FROM stevenson_TabModuleSettings WHERE SettingName Like N'XML_%'
Info
End Sql execution: Uninstall.SqlDataProvider file
Info
Deleted - Uninstall.SqlDataProvider
Info
End Sql UnInstall
Info
Component uninstalled successfully - Script
Warning
Component Uninstalled with Warnings - Script
Info
Starting Component Uninstall - Cleanup
Info
Component uninstalled successfully - Cleanup
Info
Component Uninstall Successful - Cleanup
Info
Starting Component Uninstall - Cleanup
Info
Component uninstalled successfully - Cleanup
Info
Component Uninstall Successful - Cleanup
Info
Starting Component Uninstall - Cleanup
Info
Component uninstalled successfully - Cleanup
Info
Component Uninstall Successful - Cleanup
Info
Starting Component Uninstall - Module
Info
Module un-registered successfully - DNN_XML
Info
Component uninstalled successfully - Module
Info
Component Uninstall Successful - Module
Info
Starting Component Uninstall - File
Info
Deleted - Components\ControllerBase.vb
Info
Deleted - Components\DataProvider.vb
Info
Deleted - Components\GlobalConstants.vb
Info
Deleted - Components\Utils.vb
Info
Deleted - Components\XmlController.vb
Info
Folder Deleted - Components
Info
Deleted - Parameters\ParameterController.vb
Info
Deleted - Parameters\ParameterInfo.vb
Info
Deleted - Parameters\ParameterList.vb
Info
Deleted - Parameters\ParameterType.vb
Info
Folder Deleted - Parameters
Info
Deleted - Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb
Info
Folder Deleted - SqlDataProvider
Info
Deleted - Handlers\download.vb
Info
Folder Deleted - Handlers
Info
Component uninstalled successfully - File
Info
Component Uninstall Successful - File
Info
Starting Component Uninstall - File
Info
Deleted - App_LocalResources\EditXml.ascx.resx
Info
Deleted - App_LocalResources\XmlModule.ascx.resx
Info
Folder Deleted - App_LocalResources
Info
Deleted - Parameters\ParameterEditor.ascx
Info
Deleted - Parameters\ParameterEditor.ascx.vb
Info
Folder Deleted - Parameters
Info
Deleted - download.ashx
Info
Deleted - EditXml.ascx
Info
Deleted - EditXml.ascx.vb
Info
Deleted - XmlModule.ascx
Info
Deleted - XmlModule.ascx.vb
Info
Folder Deleted - XML
Info
Component uninstalled successfully - File
Info
Component Uninstall Successful - File
Warning
Uninstalled with Warnings - DNN_XML
EndJob
Uninstalled with Warnings
--------------------------------------------------------------------------------------------------------------
Now a couple other bizarre things I noticed just this time when I reinstated that fresh backup I had from powerdnn again on my local computer. One is that when I restored the database and my files and tweaked the web.config to reflect the correct connection string to my local computer and a couple other tweaks I noticed that when the site came up it came up logged into my site as host. Maybe I never logged out before I had DNN do the backup for me or perhaps not recycling the app pool locally caused this but it was bizarre never the less.
Anyway the other unique thing that happened locally that did not happen on powerdnn is that if I didn't comment out the module node and the first line of the http nodes I got errors. In the case of the modules I was told by IIS 7.5 that I had a 500.19 internal error and this was do to the fact that I had duplicates in the web.config file and the duplicates were under two different nodes one being modules and the other being httpmodules so I commented out the modules node and than I got another error that said that the first line in my httpmodules had already been added so I commented that out and the site resolved without further incident.
Here is the details of this section of my web.config file so you can see it:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
<!--
-->
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------'
Here's the other line that I had to comment out in httpmodules node in order to get my install to work on my local computer. I asked powerdnn how come this stuff didn't have to be commented out to work on their server and they didn't have any real good answer for me except that their Plesk Control Panel and admin tools do all the work for them and they really don't know all they are doing behind the scenes so couldn't tell me why this stuff didn't need commenting out on their environmetn. Maybe do to the fact that they had a lot of things under managed where I don't since I have no higher level software like Plesk Control Panel installed that is managing my IIS for me. They also told me that they were running under vmhost or something like that but I don't think that should be a thing I should be concerned about setting up on my local IIS since this is just a development sort of thing that only I do and no other person has to get into.
---------------------------------------------------------------------------------------------------------------
<!-- add name="Authentication" type="DotNetNuke.HttpModules.AuthenticationModule, DotNetNuke.HttpModules.Authentication" / -->
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Below is the line I left uncommented and I think this is the line that IIS said was already added so the above was an addition which was unacceptable to the web.config file
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Hopefully this information will be of better service for helping to nail down this upgrade issue. Maybe it wouldn't hurt for me to request from powerdnn another manual backup and insure I am not logged in as host when they do this backup so I can be 100% sure that this was not the case of all these issues.