Ken,
Excuse for intervening,
I just started to have exactly the same issue.
I'm running DNN 7.3.2
My log reads:
ModuleId:321
ModuleDefId:63
FriendlyName:Site Management
ModuleControlSource:DesktopModules/Admin/Portals/Portals.ascx
AssemblyVersion:7.3.3
PortalID:0
PortalName:InteliBrain™
UserID:3
UserName:InteliBrainGRSuperUser
ActiveTabID:17
ActiveTabName:Site Management
RawURL:/en-us/Host/Site-Management/portalid/0
AbsoluteURL:/Default.aspx
AbsoluteURLReferrer:http://intelibrain.gr/en-us/Host/Site-Management/portalid/0
UserAgent:Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:ebbf7f97-324e-4347-9c08-d0feac27b519
InnerException:The DELETE statement conflicted with the REFERENCE constraint "FK_FolderPermission_Roles". The conflict occurred in database "InteliBrainGR", table "dbo.FolderPermission", column 'RoleID'. The statement has been terminated.
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:System.Data.SqlClient.SqlConnection.
StackTrace:
Message:
DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_FolderPermission_Roles". The conflict occurred in database "InteliBrainGR", table "dbo.FolderPermission", column 'RoleID'.
The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_FolderPermission_Roles". The conflict occurred in database "InteliBrainGR", table "dbo.FolderPermission", column 'RoleID'.
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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at PetaPoco.Database.Execute(String sql, Object[] args)
at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteNonQuery(String connectionString, CommandType type, Int32 timeout, String sql, Object[] args)
at DotNetNuke.Data.SqlDataProvider.ExecuteNonQuery(String procedureName, Object[] commandParameters)
at DotNetNuke.Data.DataProvider.DeletePortalInfo(Int32 PortalId)
at DotNetNuke.Entities.Portals.PortalController.DeletePortalInternal(Int32 portalId)
at DotNetNuke.Entities.Portals.PortalController.DeletePortal(PortalInfo portal, String serverPath)
at DotNetNuke.Modules.Admin.Portals.Portals.OnGridDeleteCommand(Object source, GridCommandEventArgs e)
--- End of inner exception stack trace ---
Should we expect the resolvement soon?
Is there any super safe way to do the deletions manually?
Is The issue open and unresolved since 2004?
Note: I'm watching DNN-4351, DNN-3831, DNN-5737 on JRA.
I guess no need to create a new Issue, or is there for the requests to grow?
Please advice.