My site is upgraded to DNN706 in preparation to go to DNN721. My DNN706 looks and functions fine. However, I am unable to add new pages or add modules to existing pages. Reverted back to DNN628 and found I was unable to add new pages or add modules with that revision. My site is somewhat static - just updates to existing pages for quite some time. So now that I've decided to overhaul my site, I am just now discovering these issues.
Page Add Error
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'TabPath', table 'dotnetnuke455.dbo.Tabs'; column does not allow nulls. INSERT fails. The statement has been terminated. The 'AddTab' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
Module Add Error
Cannot insert the value NULL into column 'TabPath', table 'dotnetnuke455.dbo.Tabs'; column does not allow nulls. INSERT fails. The statement has been terminated. The 'AddTab' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
Appreciate your feedback regarding the following the update log and 07.00.00.log.resources file. Can connect to database with SQL Server Management Server but not sure how to use to best investigate my issues.
Curious to know what was not upgraded at 00:00:03.375 - Application Upgrades : 07.00.00 Error!
Thank you very much for your time.
Upgrading DotNetNuke
Current Assembly Version: 07.00.06
Current Database Version: 06.02.08
Upgrade Status Report
00:00:00.078 - Upgrading to Version: 07.00.06
00:00:00.125 - Executing Script:07.00.00.SqlDataProvider Error! (see 07.00.00.log.resources for more information)
00:00:01.781 - Executing Script:07.00.01.SqlDataProvider Success
00:00:02.171 - Executing Script:07.00.02.SqlDataProvider Success
00:00:02.203 - Executing Script:07.00.03.SqlDataProvider Success
00:00:02.453 - Executing Script:07.00.04.SqlDataProvider Success
00:00:03.062 - Executing Script:07.00.05.SqlDataProvider Success
00:00:03.218 - Executing Script:07.00.06.SqlDataProvider Success
00:00:03.375 - Application Upgrades : 07.00.00 Error!
00:00:03.828 - Application Upgrades : 07.00.01 Success
00:00:03.828 - Application Upgrades : 07.00.02 Success
00:00:03.828 - Application Upgrades : 07.00.03 Success
00:00:03.828 - Application Upgrades : 07.00.04 Success
00:00:03.828 - Application Upgrades : 07.00.05 Success
00:00:03.843 - Application Upgrades : 07.00.06 Success
00:00:03.843 - Cleaning Up Files: 07.00.00 Success
00:00:03.890 - Cleaning Up Files: 07.00.01 Success
00:00:03.968 - Cleaning Up Files: 07.00.02 Success
00:00:03.984 - Cleaning Up Files: 07.00.03 Success
00:00:03.984 - Cleaning Up Files: 07.00.04 Success
00:00:03.984 - Cleaning Up Files: 07.00.05 Success
00:00:03.984 - Cleaning Up Files: 07.00.06 Success
00:00:03.984 - Updating Config Files: 07.00.00 Success
00:00:04.171 - Updating Config Files: 07.00.01 Success
00:00:04.171 - Updating Config Files: 07.00.02 Success
00:00:04.187 - Updating Config Files: 07.00.03 Success
00:00:04.203 - Updating Config Files: 07.00.04 Success
00:00:04.218 - Updating Config Files: 07.00.05 Success
00:00:04.250 - Updating Config Files: 07.00.06 Success
00:00:04.265 - Performing General Upgrades
00:00:04.421 - Installing Optional Modules:
00:00:04.421 - Installing Package File DDRMenu_02.00.03_Install: Success
00:00:05.171 - Installing Package File DNNCE_CoreMessaging_07.00.06_Install: Success
00:00:05.876 - Installing Package File DNNCE_HTML_07.00.06_Install: Success
00:00:06.625 - Installing Package File DNNCE_Journal_07.00.06_Install: Success
00:00:07.750 - Installing Package File DNNCE_MemberDirectory_07.00.06_Install: Success
00:00:08.812 - Installing Package File DNNCE_MobileManagement_07.00.06_Install: Success
00:00:09.265 - Installing Package File DNNCE_PreviewProfileManagement_07.00.06_Install: Success
00:00:09.687 - Installing Package File DNNCE_RazorHost_07.00.06_Install: Success
00:00:10.828 - Installing Package File DNNCE_SocialGroups_07.00.06_Install: Success
00:00:11.828 - Installing Package File DNNCE_Taxonomy_07.00.06_Install: Success
00:00:12.500 - Installing Package File Telerik_07.00.06_Install: Success
00:00:15.187 - Installing Optional Skins:
00:00:15.187 - Installing Optional Containers:
00:00:15.203 - Installing Optional Languages:
00:00:15.203 - Installing Optional Providers:
00:00:15.203 - Installing Package File DNNMenuNavigationProvider_07.00.06_Install: Success
00:00:15.406 - Installing Package File FiftyOneClientCapabilityProvider_07.00.06_Install: Success
00:00:16.187 - Installing Package File RadEditorProvider_07.00.06_Install: Success
00:00:20.843 - Installing Optional AuthSystems:
00:00:20.859 - Installing Optional Packages:
Upgrade Complete
--------------------------------------------------------------------------------------------------
07.00.00.log.resources
System.Data.SqlClient.SqlException (0x80131904): 'IX_ModulePermission' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
ClientConnectionId:490a40ab-e3df-4ec6-8353-531dce4579ed
ALTER TABLE dbo.ModulePermission
DROP CONSTRAINT IX_ModulePermission
System.Data.SqlClient.SqlException (0x80131904): 'IX_ModuleDefinitions' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
ClientConnectionId:3f581d7c-77d3-438f-8429-65a88d5be13b
IF EXISTS (SELECT * FROM dbo.[ModuleDefinitions] WHERE DefinitionName = '')
BEGIN
UPDATE dbo.[ModuleDefinitions] SET DefinitionName = FriendlyName
ALTER TABLE dbo.[ModuleDefinitions]
DROP CONSTRAINT DF_ModuleDefinitions_DefinitionName
ALTER TABLE dbo.[ModuleDefinitions]
DROP CONSTRAINT IX_ModuleDefinitions
CREATE UNIQUE NONCLUSTERED INDEX IX_ModuleDefinitions ON dbo.[ModuleDefinitions]
(
DefinitionName
)
END
---------------------------------------------------------------------------------------------
DNN Revision History
| 7.0.6 |
21 Feb 2014 10:26 |
| 6.2.8 |
21 Feb 2014 08:17 |
| 6.2.2 |
04 Aug 2012 19:26 |
| 6.1.4 |
19 Mar 2012 13:07 |
| 6.1.1 |
23 Nov 2011 07:14 |
| 6.0.1 |
07 Sep 2011 08:03 |
| 5.6.1 |
26 Jan 2011 15:25 |
| 5.5.0 |
20 Sep 2010 06:21 |
| 5.4.2 |
16 Jun 2010 07:53 |
| 4.8.0 |
03 Sep 2009 08:32 |
| 4.7.0 |
03 Sep 2009 08:31 |
| 4.5.5 |
07 Aug 2007 19:58 |
| 4.4.1 |
03 Feb 2007 09:16 |
| 4.3.7 |
05 Dec 2006 15:03 |
| 3.2.1 |
10 Feb 2006 16:0 |