Hi,

When I try to remove a page from Add/Edit pages, e.g. the Forums page, I get an error:

Beschrijving: Er is een onverwerkte uitzondering opgetreden tijdens het uitvoeren van de huidige webaanvraag. Raadpleeg de stacktracering voor meer informatie over deze fout en de oorsprong ervan in de code.

Details van uitzondering: System.Data.SqlClient.SqlException: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_mp_PageModules_mp_PageModules'. The conflict occurred in database 'Portal_Vuren', table 'mp_PageModules', column 'PageID'.
The statement has been terminated.

Fout in bron:

Regel 3805:			{
Regel 3806:				Connection.Close();
Regel 3807:				throw ex;
Regel 3808:			}
Regel 3809:		}

[SqlException (0x80131904): DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_mp_PageModules_mp_PageModules'. The conflict occurred in database 'Portal_Vuren', table 'mp_PageModules', column 'PageID'.
The statement has been terminated.]
   mojoPortal.Data.dbPortal.PageSettings_DeletePage(Int32 PageID) in D:\VurenPortal\MSSQLData\dbPortal.cs:3807
   mojoPortal.Business.PageSettings.DeletePage(Int32 PageID) in D:\VurenPortal\Business\PageSettings.cs:472
   mojoPortal.Web.Pages.btnDelete_Click(Object sender, ImageClickEventArgs e) in D:\VurenPortal\Web\Admin\Pages.ascx.cs:149
   System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105
   System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
   System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Serverfout in toepassing /RBSV.

---

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_mp_PageModules_mp_PageModules'. The conflict occurred in database 'Portal_Vuren', table 'mp_PageModules', column 'PageID'.
The statement has been terminated.

I've setup a VurenPortal (copy of Mojo) and run all the scripts.

When I add my own page and delete it directly, I do not receive an error.

Anybody has a solution?

Jan

I'm not sure about the other databases, but for MS SQL you could use the cascaded delete functionality.

Cheers,

Jan