[Bug]: Site stuck in permanent loading state after delete; blocks creating a new site

[phravins]

Summary

After deleting a published site, the admin Explorer panel (Media/Layers tabs) gets stuck rendering skeleton/loading placeholders indefinitely and never resolves to real content. Attempting to create a new site afterward does not work — the app appears to still be holding a reference to the deleted site's data.

This reproduces even in a fresh Incognito window with no cache/cookies/IndexedDB, which rules out client-side caching as the cause.

Steps to reproduce

1. Create a new site in the admin
2. Publish the site
3. Delete the site
4. Reload the admin (/admin/site)
5. Explorer panel (Media tab) shows perpetual skeleton loading placeholders, "0" for Images/Videos, and the state never resolves
6. Attempting to create a new site from this state does not succeed

Expected behavior

Deleting a site should fully clean up its associated records so the admin returns to a clean, empty state and a new site can be created immediately.

Actual behavior

The admin gets stuck referencing the deleted site indefinitely. New site creation is blocked.

Version or commit

latest

Deployment mode

Docker Compose with SQLite

Logs or screenshots

2026-Aug-12 10:17:01 [server] Listening on http://localhost:3001
2026-Aug-12 10:18:31 [collab] dropped malformed awareness frame from EdSV6zmv0m3JIKzSvlv6G
2026-Aug-12 10:53:59 [collab] stale generation for page:VeDhLJIXMhIL-QTguyx7n from EdSV6zmv0m3JIKzSvlv6G
2026-Aug-12 11:01:53 [collab] dropped malformed awareness frame from EdSV6zmv0m3JIKzSvlv6G
2026-Aug-13 05:32:24 [collab] dropped malformed awareness frame from EdSV6zmv0m3JIKzSvlv6G