Hi Mitchel,

I am migrating this issue from your article at http://www.mitchelsellers.com/Blogs/tabid/54/articleType/ArticleView/articleId/142/Upgrading-to-DotNetNuke-460-from-4x.aspx

However, I want to simpllify. My desired end result is to upgrade from 4.5.3 to 4.6.0.

In order to do so, I get the impression I first have to upgrade from 4.5.3 to 4.5.5. Maybe this particular upgrade installs the stored procedures and table having to do with 'Packages' currently not in the database connected to my 4.5.3 version.

So, I follwed instuctions for upgrading from 4.5.3 to 4.5.5 but get an error. I see what the error says, that  'Cannot insert the value NULL into column 'VersionId' , but how do I fix it? I looked at the code in VS2005 but am unsure how to adjust it. Could you please take a moment and look?

Cannot insert the value NULL into column 'VersionId', table 'db_PFGBOSS_TESTER.dbo.Version'; column does not allow nulls. INSERT fails.
The statement has been terminated.

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.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'VersionId', table 'db_PFGBOSS_TESTER.dbo.Version'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Source Error:

<pre>Line 171:                        Response.Write(&quot;<h2>Upgrade Status Report</h2>&quot;)
Line 172:                        Response.Flush()
<fontcolor="#ff0000">Line 173:                        Services.Upgrade.Upgrade.UpgradeDNN(strProviderPath, strDatabaseVersion.Replace(&quot;.&quot;, &quot;&quot;))
</font>Line 174:
Line 175:                        'Install Resources</pre>

Ok, I tried:

Table 'Version', I reset the Identity Specification of column 'VersionID' to Yes

Ran the /Install/Install.aspx?mode=install page againg but now I get a new error. I am in debug mode so I stopped execution after this first error:

Upgrading DotNetNuke

Current Assembly Version: 04.05.05

Current Database Version: 04.05.03

Upgrade Status Report

00:00:04.328 - Upgrading to Version: 4.5.5
00:00:04.344 -   Executing Script: 04.05.04.SqlDataProvider Error! (see 04.05.04.log for more information)
00:00:04.422 -   Executing Script: 04.05.05.SqlDataProvider Success
00:00:04.437 - Performing General Upgrades

BTW, where is  04.05.04.log?

Ok, I found the log I think in Providers\DataProviders\SqlDataProvider

The log states:

System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'IsSecure' in table 'dbo.Tabs' 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)

ALTER TABLE dbo.Tabs ADD
 IsSecure bit NOT NULL CONSTRAINT DF_Tabs_IsSecure DEFAULT (0)

I looked at the table 'Tabs' and I see the column IsSecure, but only once, as it should be.

What does this mean?

Ok, I decided that the error is because the constraint already exists on the table, so I will not worry about it.

And the upgrade copmpleted successfully to 4.5.5.

Now I will try upgrading to 4.6.0

Sorry for taking up extra space. I had tried and tried bfeore without success, so I thought I'd document each step and get help for each error, but of course, I was able to resolve them all once I posted it. Dohh!

Well, I tried doing the install from 4.3 to 4.6, but had problems. I will try again as a test.

In the meantime, I have performed the upgrade form 4.5.5 to 4.6, but not without errors:

Upgrading DotNetNuke

Current Assembly Version: 04.06.00

Current Database Version: 04.05.05

Upgrade Status Report

00:00:00.031 - Upgrading to Version: 4.6.0
00:00:00.062 -   Executing Script: 04.06.00.SqlDataProvider Error! (see 04.06.00.log for more information)
00:00:01.218 - Performing General Upgrades
00:00:01.812 - Installing Module File Adsense_01.00.01_Install:  Success
00:00:03.047 - Installing Module File HTML_04.06.00_Install:  Error!
00:00:04.047 - Installing Module File Links_03.03.07_Install:  Success
00:00:05.406 - Installing Package File LiveID_01.00.00_Install:  Success
00:00:06.469 - Installing Package File OpenID_01.00.00_Install:  Success

Upgrade Complete

The log is as follows:

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ModuleControlID', table 'db_PFGBOSS_TESTER.dbo.ModuleControls'; column does not allow nulls. INSERT fails.
The statement has been terminated.
   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)

/* Add new LogOff control to ModuleControls */
/********************************************/

IF (SELECT COUNT(*) FROM dbo.ModuleControls WHERE ModuleDefID IS NULL AND ControlKey = 'Logoff') = 0
 BEGIN
  INSERT INTO dbo.ModuleControls
   ( ControlKey, ControlTitle, ControlSrc, ControlType )
   VALUES ( 'Logoff', 'Account Logout', 'Admin/Authentication/Logoff.ascx', -1 )
 END

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ModuleControlID', table 'db_PFGBOSS_TESTER.dbo.ModuleControls'; column does not allow nulls. INSERT fails.
The statement has been terminated.
   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)

/* Add new Install/UnInstall controls to ModuleControls */
/********************************************************/

IF (SELECT COUNT(*) FROM dbo.ModuleControls WHERE ModuleDefID IS NULL AND ControlKey = 'Install') = 0
 BEGIN
  INSERT INTO dbo.ModuleControls
   ( ControlKey, ControlTitle, ControlSrc, ControlType )
   VALUES ( 'Install', 'Package Installer', 'Admin/Packages/Install.ascx', -1 )
 END

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ModuleControlID', table 'db_PFGBOSS_TESTER.dbo.ModuleControls'; column does not allow nulls. INSERT fails.
The statement has been terminated.
   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)

IF (SELECT COUNT(*) FROM dbo.ModuleControls WHERE ModuleDefID IS NULL AND ControlKey = 'UnInstall') = 0
 BEGIN
  INSERT INTO dbo.ModuleControls
   ( ControlKey, ControlTitle, ControlSrc, ControlType )
   VALUES ( 'UnInstall', 'Package UnInstaller', 'Admin/Packages/UnInstall.ascx', -1 )
 END

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ModuleControlID', table 'db_PFGBOSS_TESTER.dbo.ModuleControls'; column does not allow nulls. INSERT fails.
The statement has been terminated.
   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)

declare @ModuleDefID int

select @ModuleDefID = ModuleDefID
from   dbo.ModuleDefinitions
where  FriendlyName = 'Module Definitions'

insert into dbo.ModuleControls ( ModuleDefID, ControlKey, ControlTitle, ControlSrc, IconFile, ControlType, ViewOrder, HelpUrl, SupportsPartialRendering )
values ( @ModuleDefID, 'Import', 'Import Module Definition', 'Admin/ModuleDefinitions/ImportModuleDefinition.ascx', NULL, 3, NULL, NULL, 0 )

What should I do?

I set the ID column of Table ModuleControls to be an identity column, deleted all the files and started a freah upgrade form the 4.5.5 version.

Now when I run the /Install/Install.aspx page, after it runs for about 30 seconds, it just stays blank.

If I browse to the default page, I get:

I think I really am stuck now.

Value cannot be null.
Parameter name: type

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.ArgumentNullException: Value cannot be null.
Parameter name: type

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.

[ArgumentNullException: Value cannot be null.
Parameter name: type]
   System.Activator.CreateInstance(Type type, Boolean nonPublic) +2768503
   DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectProviderName, String ObjectNamespace, String ObjectAssemblyName, Boolean UseCache) +582
   DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectNamespace, String ObjectAssemblyName) +17
   DotNetNuke.Security.Membership.Data.DataProvider.CreateProvider() +38
   DotNetNuke.Security.Membership.Data.DataProvider..cctor() +13

[TypeInitializationException: The type initializer for 'DotNetNuke.Security.Membership.Data.DataProvider' threw an exception.]
   DotNetNuke.Security.Membership.Data.DataProvider.Instance() +0
   DotNetNuke.Security.Membership.AspNetMembershipProvider..cctor() +5

[TypeInitializationException: The type initializer for 'DotNetNuke.Security.Membership.AspNetMembershipProvider' threw an exception.]

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +103
   System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +261
   System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
   DotNetNuke.Framework.Reflection.CreateObject(String ObjectProviderType, String ObjectProviderName, String ObjectNamespace, String ObjectAssemblyName, Boolean UseCache) +582
   DotNetNuke.Security.Membership.MembershipProvider.CreateProvider() +38
   DotNetNuke.Security.Membership.MembershipProvider..cctor() +13

[TypeInitializationException: The type initializer for 'DotNetNuke.Security.Membership.MembershipProvider' threw an exception.]
   DotNetNuke.Security.Membership.MembershipProvider.Instance() +0
   DotNetNuke.Entities.Users.UserController..cctor() +5

[TypeInitializationException: The type initializer for 'DotNetNuke.Entities.Users.UserController' threw an exception.]
   DotNetNuke.Entities.Users.UserController.GetUserCountByPortal(Int32 portalId) +0
   DotNetNuke.Entities.Portals.PortalInfo.get_Users() +17
   DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +1302
   DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +83
   DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +2848
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

I started with 4.4.0

I have added a number of custom profile properties.

I am stuck

If 4.5.5 would work properly (profile property errors up the wazooo), I would try to run that. I would like to run it mainly for the SSL enhancement. Right now my live portal, all my pages are SSL, which obviously hurts performance.

I will revert back to 4.5.5, set the Required attribute for all profile properties to False and try the upgrade again. I do have empty values for some required fields because I imported users from another db, and wanted the users to enter missing data as soon as they login for the first time. Must have something to do with that. Thanks for your time, I appreciate your feedback.