Deleting one site removes all pages from other sites (multisite)

[nordmanndev]

Description

In a multisite Vvveb installation, deleting a single site causes all pages belonging to all other sites to disappear from the admin panel. Pages are either cascade-deleted or their site_id association is broken, making them unreachable.

---

Steps to reproduce

1. Set up Vvveb CMS with two or more sites (multisite)
2. Create at least one page on each site
3. Navigate to Settings → Sites, select any site, and delete it
4. Switch to another site and open Pages
5. All previously created pages are gone

---

Observed behavior

After deleting site A, all pages associated with site B (and any further sites) are no longer visible or accessible in the admin panel. It is unclear whether they are hard-deleted from the database or merely orphaned.

---

Expected behavior

Deleting a site should only remove content belonging to that specific site. Pages, posts, and media of all other sites must remain fully intact.

A confirmation dialog warning about permanent content deletion for the targeted site would also be recommended.

---

Impact

⚠️ High — silent data loss across all sites when any single site is deleted.
Content may be unrecoverable without a prior database backup.
Affects any multisite Vvveb installation.

---

Likely root cause

An overly broad ON DELETE CASCADE on the site_id foreign key in the pages table, or a site delete handler that clears all pages regardless of site_id.

To investigate: check whether pages are hard-deleted from the DB or orphaned (null site_id) after the delete — this affects urgency of the fix.

---

Environment

Vvveb version	Latest (2026-03-24)
Setup	Multisite (2+ sites)
Likely area	Site delete controller / DB cascade rules

[givanz]

Thanks for the bug report, the posts without a site are hidden but not deleted.

Posts can be assigned to multiple sites and are not deleted when a site is deleted.

If a post is assigned to only one site when the site is deleted the post will not be visible in the list for any other site unless the all sites filter is used.

You can then edit the post and reassign the post to another site.

To avoid this issue you can assign posts to a different/new site before deleting the old site.