Greetings Sebastian ...
My site (bamit.org) appears to be working fine. Again, I can safely add pages and modules to pages. Do you have any recommendations (other than backup) before attempting to upgrade from DNN706 to DNN721 based on the following excerpts from the upgrade log to DNN706? Thank you very much.
Roy
Error! (see 07.00.00.log.resources for more information)
System.Data.SqlClient.SqlException (0x80131904): 'IX_ModulePermission' is not a constraint. Could not drop constraint
-and-
Application Upgrades : 07.00.00 Error!
-----------------------------------------------------------------------------------------------------------------------
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