When trying to delete a page from the trash bin I run into an error that tells me to check my internet connection... As that can't be the reason I investigated a bit and found out that there is a foreign key constraint in the table Community_Visits (FK_Community_Visits_Tabs) blocking the deletion.
When deleting all records in this table with tab_id = (TabId of this page from the Tabs table) and restarting the app pool, the page can be deleted from the trash bin.
The strange thing is: I searched all *.SqlDataProvider files in the installation for "Community_Visits" and "FK_Community_Visits_Tabs", but could not find any appearance. I suspect it has to do something with Active Forums, but as I said, I could not find a SQL script creating or updating this table and/or foreign key.
Does anybody know where that comes from?
Happy DNNing! Michael
Found it - it is coming from the Dnn.WebAnalytics module - see here.
This constraint blocks deletions from the Tabs table, and it is in fact done from the wrong side (should be from the master = Tabs table to the Community Visits table with the ON DELETE CASCADE option - but this is a change to the core system, and therefore not a good practice for modules).
The constraint should be removed, and to keep that table "clean" a task could check from time to time if all values of the tab_id column exist in the Tabs table and delete these records if not.
I'll open an issue on the GitHub site...
The issue is here: Foreign key constraint blocks (final) tab deletion · Issue #42 · DNNCommunity/Dnn.WebAnalytics (github.com)
Nice... Thanks, Michael! 💪🏽
These Forums are for the discussion of the open source CMS DNN platform and ecosystem.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.