Just for fun I upgraded a test instance of my live portal system to the DotNetNuke_Community_7.0.0.1065_Upgrade release and although everything's a total mess, it only returned one error during the upgrade. So I'm reporting that error here in case something needs to be fixed. This was upgraded from 6.2.4, which itself has been upgraded since about 4.3 or so.

Regards
Rob

The upgrade log says this:

System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'PortalID', table 'testsystem.dbo.ModulePermission'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
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.ExecuteScriptInternal(String connectionString, String script)

ALTER TABLE dbo.ModulePermission
ALTER COLUMN PortalID int NOT NULL

 

Hi,
this looks like the error I posted at http://www.dotnetnuke.com/Resources/F...
The question for me becomes should I restore the old site, then run the script above and then upgrade, or as the site seems to be running ok, leave it?
What might have happened or not happened when this part of the upgrade script stopped?
Thanks
Paul