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
Michael TobischDNN★MVP
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 dedicated to the discussion of DNN Platform.
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.