Host Partnership
If you are looking for good DNN hosting, then PowerDNN is the best DNN host around!
Need a custom module?
 Should you have any questions about custom DNN modules or web projects, please let us know.
|
Support Forum
| Author |
Messages |
|
Tom Doe
Posts:6
 |
| 11/26/2010 6:29 AM |
|
When I try to empty the recycle bin (which holds a deleted instance of UMG) from the Admin menu a critical error occurs that appears to be related to Ultra Media Gallery.
After this critical error, the Recycle Bin admin page is totally empty. I tried manually adding another "Recycle Bin" module to the page (named "Recycle Bin 2"), which works. However when I try to empty the recycle bin, I get another critical error and the module disappears again.
I'm running DNN v5.6.0 but also had the problem with v5.5.1
Error Message visible on the Recycle Bin admin page after emptying the Recycle bin:
A Critical error has occurred.
The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "DNN_PEM005", table "dbo.BizModules_UPG_AlbumModule", column 'ModuleId'. The statement has been terminated.
The Log created the following entry:
AssemblyVersion: 5.6.0
PortalID: 0
PortalName: [PORTALNAME]
UserID: 1
UserName: [PORTALNAME]
ActiveTabID: 54
ActiveTabName: Recycle Bin
RawURL: /Admin/RecycleBin.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.[PORTALNAME].com/Admin/RecycleBin.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: bf9699c3-d9ec-4dd9-988d-1acbf1e43062
InnerException: The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "DNN_PEM005", table "dbo.BizModules_UPG_AlbumModule", column 'ModuleId'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "DNN_PEM005", table "dbo.BizModules_UPG_AlbumModule", column 'ModuleId'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "DNN_PEM005", table "dbo.BizModules_UPG_AlbumModule", column 'ModuleId'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.DeleteModule(Int32 ModuleId) at DotNetNuke.Entities.Modules.ModuleController.DeleteModule(Int32 moduleId) at DotNetNuke.Entities.Modules.ModuleController.DeleteTabModule(Int32 tabId, Int32 moduleId, Boolean softDelete) at DotNetNuke.Modules.Admin.RecycleBin.RecycleBin.cmdEmpty_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: [SERVERNAME]
|
|
|
|
|
Pengtsen R
Posts:11533
|
| 11/29/2010 12:36 AM |
|
| I think you should delete albums in this module, otherwise there will be a confliction. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Tom Doe
Posts:6
|
| 11/29/2010 4:27 AM |
|
So I should delete the albums I created with an UMG module prior to deleting the UMG module?
How should I do this now the UMG Module already is deleted (The deleted module isn't available anymore in the recycle bin)? |
|
|
|
|
Pengtsen R
Posts:11533
|
| 12/04/2010 12:27 AM |
|
yes, that is suggested.
you can restored it to any DNN page. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Nathan Byrer
Posts:22
|
| 03/15/2011 10:24 AM |
|
I am getting pretty much the same error message when trying to delete a portal. I went back and made sure the albums were deleted, all of the modules were deleted, and everything was deleted from the Recycle Bin. I am still unable to remove the portal. The error I get is below:
DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "DotNetNuke", table "dbo.dnn_BizModules_UPG_AlbumModule", column 'ModuleId'. The DELETE statement conflicted with the REFERENCE constraint "FK_dnn_Modules_dnn_Portals". The conflict occurred in database "DotNetNuke", table "dbo.dnn_Modules", column 'PortalID'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "DotNetNuke", table "dbo.dnn_BizModules_UPG_AlbumModule", column 'ModuleId'. The DELETE statement conflicted with the REFERENCE constraint "FK_dnn_Modules_dnn_Portals". The conflict occurred in database "DotNetNuke", table "dbo.dnn_Modules", column 'PortalID'. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortal(PortalInfo portal, String serverPath) at DotNetNuke.Modules.Admin.Portals.Portals.grdPortals_DeleteCommand(Object source, DataGridCommandEventArgs e) --- End of inner exception stack trace --- |
|
|
|
|
Pengtsen R
Posts:11533
|
| 03/20/2011 5:26 AM |
|
are you sure all UMG albums are deleted?
you can give me your host password so I can manually fix it for you. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Nathan Byrer
Posts:22
|
| 03/20/2011 8:21 AM |
|
I sent the URL, username, and password to your host account. Do you need to know the portals where I am seeing this happen? As I continue to clean up old portals that use UMG, will I need to contact you again for this fix?
Thanks,
Nathan |
|
|
|
|
Nathan Byrer
Posts:22
|
| 03/22/2011 9:25 AM |
|
| Yes, I am sure that they are all deleted. I went to the trouble of deleting all of the modules and pages and then removing everything from the recycle bin. |
|
|
|
|
Pengtsen R
Posts:11533
|
| 03/22/2011 9:43 PM |
|
| I didnt' seem to get your email, did you send it in the Contact Us page of this website? |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Nathan Byrer
Posts:22
|
| 03/23/2011 5:05 AM |
|
| I sent the Email by clicking the Click to Send Email link in your profile. I will resend through your support form. |
|
|
|
|
Pengtsen R
Posts:11533
|
| 03/28/2011 6:16 AM |
|
| you should have got a reply. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Nathan Byrer
Posts:22
|
| 05/02/2011 11:34 AM |
|
Thank you. Whatever you did fixed the issue for that portal. I am now getting the same type of error on another portal:
DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "DotNetNuke", table "dbo.dnn_BizModules_UPG_AlbumModule", column 'ModuleId'. The DELETE statement conflicted with the REFERENCE constraint "FK_dnn_Modules_dnn_Portals". The conflict occurred in database "DotNetNuke", table "dbo.dnn_Modules", column 'PortalID'. The statement has been terminated. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "DotNetNuke", table "dbo.dnn_BizModules_UPG_AlbumModule", column 'ModuleId'. The DELETE statement conflicted with the REFERENCE constraint "FK_dnn_Modules_dnn_Portals". The conflict occurred in database "DotNetNuke", table "dbo.dnn_Modules", column 'PortalID'. The statement has been terminated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortalInfo(Int32 PortalId) at DotNetNuke.Entities.Portals.PortalController.DeletePortal(PortalInfo portal, String serverPath) at DotNetNuke.Modules.Admin.Portals.Portals.grdPortals_DeleteCommand(Object source, DataGridCommandEventArgs e) --- End of inner exception stack trace ---
If you wouldn't mind just sending the SQL that you ran, I would be happy to run it to clean up the references. |
|
|
|
|
Pengtsen R
Posts:11533
|
| 05/05/2011 3:01 AM |
|
| before deleting a module, you need to delete all albums within this module, that's the problem. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Nathan Byrer
Posts:22
|
| 07/19/2011 8:15 AM |
|
| I am still getting this error message when trying to delete portals. Would you mind sending the instructions you followed to clean this up last time? I have a few portals that I am having this issue with. I would like to add the instructions to my documentation for the future. |
|
|
|
|
Pengtsen R
Posts:11533
|
| 07/19/2011 10:27 AM |
|
| please recover all UMG instances, ensure all albums are deleted, then you should be able to delete this module of your entire album. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Nathan Byrer
Posts:22
|
| 07/19/2011 2:14 PM |
|
| Someone tried to delete the portal before removing the modules. Now, the modules are not in the Recycle Bin to restore. |
|
|
|
|
Pengtsen R
Posts:11533
|
| 07/19/2011 9:36 PM |
|
| so do you still have troulbe with it? if so you can give me your host password and let me try to delete it for you. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Nathan Byrer
Posts:22
|
| 07/20/2011 7:14 AM |
|
Yes, I get the error I posted above. That stops the delete process and it only partially completes.
I would really like to know if it is possible to run some SQL that will drop that reference constraint.
How would you like to get the information to access my server? |
|
|
|
|
Pengtsen R
Posts:11533
|
| 07/27/2011 9:21 AM |
|
if you drop the constrint it will definately fix your problem.
I don't have a sql statement to do this job, but you can connect to your server by Sql Server Management Studio and manually drop it.
thanks. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Nathan Byrer
Posts:22
|
| 07/27/2011 10:12 AM |
|
| I almost did that previously, but decided to wait until I heard back from you. I will do that. Thank you. |
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|