 |
|
|
|
Joined: 6/26/2014
Posts: 12
|
|
|
Hi, I'm attempting to update an install from 6.2.5. I ran into some issues going straight to 7.3.4 so I'm trying to follow the upgrade path and simply take it to 6.2.8 first, which I believe is the correct step.
I'm unable to even begin the upgrade process (the one straight to 7.3.4 at least completed, but had errors on two of the upgrade steps). I can't allow it to insert a NULL value in the column it seems to want to, as it is a primary key, so I'm not sure the error means what I think it does.
This is as far as I get (debug mode on):
Upgrading DotNetNuke
Current Assembly Version: 06.02.08
Current Database Version: 06.02.05
Upgrade Status Report
00:00:00.031 - Upgrading to Version: 06.02.08
00:00:00.374 - Executing Script: 06.02.06.SqlDataProvider Success
Server Error in '/' Application.
Cannot insert the value NULL into column
'VersionId', table 'ebus_e2esummit.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
'ebus_e2esummit.dbo.Version'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Source Error:
Line 213: SchedulingProvider.Instance().Halt("Stopped by Upgrade Process");
Line 214:
Line 215: Upgrade.Upgrade.UpgradeDNN(strProviderPath, DataProvider.Instance().GetVersion());
Line 216:
Line 217: //Install optional resources if present
|
Source File: e:\Sites\Upgrading\e2esummit.com_fresh\Install\Install.aspx.cs Line: 215
Stack Trace:
[SqlException (0x80131904): Cannot insert the value NULL into column 'VersionId', table 'ebus_e2esummit.dbo.Version'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1791910
System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5347106
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1693
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +275
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +208
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +163
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +74
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +88
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) +87
DotNetNuke.Data.SqlDataProvider.UpdateDatabaseVersion(Int32 Major, Int32 Minor, Int32 Build, String Name) +236
DotNetNuke.Common.Globals.UpdateDataBaseVersion(Version version) +68
DotNetNuke.Services.Upgrade.Upgrade.UpgradeVersion(String scriptFile, Boolean writeFeedback) +126
DotNetNuke.Services.Upgrade.Upgrade.UpgradeDNN(String providerPath, Version dataBaseVersion) +255
DotNetNuke.Services.Install.Install.UpgradeApplication() in e:\Sites\Upgrading\e2esummit.com_fresh\Install\Install.aspx.cs:215
DotNetNuke.Services.Install.Install. (EventArgs e) in e:\Sites\Upgrading\e2esummit.com_fresh\Install\Install.aspx.cs:436
System.Web.UI.Control.LoadRecursive() +54
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772
|
|
| |
|
|
 | |
|
|
|
Did you unblock the upgrade package (right click, file properties, at the bottom of 1st tab), prior to unzipping the files contained?
|
| |
|
|
| |
|
|
|
Joined: 6/26/2014
Posts: 12
|
|
|
Thanks for the quick reply, Sebastian. I didn't unblock the file, but I have now and remerged/uploaded and I'm getting the same error.
|
| |
|
|
| |
|
|
|
please check table version in your database.
Column VersionID should be an integer with Identity (1,1) since DNN version one.
Did you transfer DNN using any other technique than database backup and restore before?
|
| |
|
|
| |
|
|
|
Joined: 6/26/2014
Posts: 12
|
|
|
This is one of a number of sites I inherited from another hosting company I absorbed, so the entire history isn't known to me. Their typical method seemed to do an install and not ever upgrade (of the 80 sites only two different versions of DNN exist).
This is the version table:
VersionId Major Minor Build Name CreatedDate
1 6 0 0 DNNCORP.CE 2013-01-21 09:13:57.840
2 6 0 1 DNNCORP.CE 2013-01-21 09:13:59.797
3 6 0 2 DNNCORP.CE 2013-01-21 09:13:59.950
4 6 1 0 DNNCORP.CE 2013-01-21 09:14:00.430
5 6 1 1 DNNCORP.CE 2013-01-21 09:14:00.593
6 6 1 2 DNNCORP.CE 2013-01-21 09:14:00.773
7 6 1 3 DNNCORP.CE 2013-01-21 09:14:01.000
8 6 1 4 DNNCORP.CE 2013-01-21 09:14:01.197
9 6 1 5 DNNCORP.CE 2013-01-21 09:14:02.317
10 6 2 0 DNNCORP.CE 2013-06-19 09:59:27.100
11 6 2 1 DNNCORP.CE 2013-06-19 09:59:27.693
12 6 2 2 DNNCORP.CE 2013-06-19 09:59:28.020
13 6 2 3 DNNCORP.CE 2013-06-19 09:59:28.513
14 6 2 4 DNNCORP.CE 2013-06-19 09:59:28.607
15 6 2 5 DNNCORP.CE 2013-06-19 09:59:28.637
I appreciate the help and apologize for the late reply. I'm getting pretty close to just installing a fresh copy of DNN and manually importing pages over so any input you offer is very welcomed.
|
| |
|
|
| |