Well, I've discovered some more things. First I made a bad mistake when updating my web.config file. I have two DNN installs on the same database so I use an objectQualifier. To make matters more complicated I also needed to use a non-dbo username. I forgot to make these two changes to my web.config file. Or rather the merging of the old with the new did not retain those changes. Sigh.

During the transfer of my DNN site from my previous provider to this one I was given dbo permissions. So when the script ran and created new tables it happily created dbo.bla tables. So now I have tables with the same name, 1 owned by dbo and one by my username. What a mess.

I fixed the web.config file and I'm trying to run the upgrade again. It hobbles along for a while and then bombs:

Installation Status Report
00:00:00.015 - Installing Version: 3.1.0
00:00:00.015 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.156 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeC:\...\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:08.874 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeC:\...\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:09.562 - Installing MemberRole Provider:
00:00:09.562 - Executing InstallCommon.sql
00:00:10.296 - Executing InstallMembership.sql
00:00:11.609 - Executing InstallProfile.sql
00:00:12.249 - 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) +144
DotNetNuke.Services.Upgrade.Upgrade.InstallDNN(String strProviderPath) +1226
DotNetNuke.Framework.Install.InstallApplication() +1162
DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) +265
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750


That seems fixable but I don't know what causes this mismatch. Anyone?

I was about to throw in the towel and recreate my site but maybe I'll give this some more time.