Hello,

I attempted to upgrade my 3.2.2 site to 3.3.5 yesterday and blew away my site in the process. Ok, maybe I'm exaggerating a bit but my site is down. Here's what happens:

Version: 03.03.05


Installation Status Report
00: - Installing Version: 3.1.0
00: - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.140 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeC:\...\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:09.265 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeC:\...Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:10.140 - Installing MemberRole Provider:
00:00:10.140 - Executing InstallCommon.sql
00:00:12.140 - Executing InstallMembership.sql
00:00:13.999 - Executing InstallProfile.sql
00:00:14.453 - Executing InstallRoles.sql
Error!


Server Error in '/' Application.
Parameter count does not match Parameter Value count.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Parameter count does not match Parameter Value count.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentException: Parameter count does not match Parameter Value count.]
Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues)
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
DotNetNuke.Data.SqlDataProvider.UpdateDatabaseVersion(Int32 Major, Int32 Minor, Int32 Build) +146
DotNetNuke.Services.Upgrade.Upgrade.InstallDNN(String strProviderPath) +1232
DotNetNuke.Framework.Install.InstallApplication() +1179
DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) +266
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750


The errors in the first two scripts seem to indicate simply that the changes have already been made and as you can see the framework ignores them. What does the second error indicate? Some kind of mismatch? I downloaded the upgrade .zip, uploaded and extracted it over my existing code. That should upgrade the code at the same time as the upgrade scripts, right?

I'm about a day away from rebuilding my site from scratch but I'd prefer to salvage it.

thanks for any help you can provide. I notice there are quite a few unanswered upgrade/install posts. I hope this doesn't mean people have given up on DNN. When it works it's a great portal. On the other hand it's so darn complex that it's about impossible to figure out what's going on under the hood.

Sander