Bug: Cannot delete newly created sites (HTTP 409 Conflict)

[macktic]

Bug: Cannot delete newly created sites (HTTP 409 Conflict)

Version: Wiki.js 3.0.0-beta.705
Database: PostgreSQL 17
Deployment: Docker Compose

Steps to reproduce

1. Create a new site in the Wiki.js administration interface.
2. Do not create any pages or upload any assets.
3. Attempt to delete the site.
4. The deletion fails with HTTP 409 Conflict.

Actual behaviour

The API returns:

{
  "error": "conflictError",
  "statusCode": 409,
  "message": "Cannot delete a site that still holds content. Delete its pages and assets first."
}

The site contains no pages or assets.

Expected behaviour

Deleting a newly created, empty site should succeed.

The confirmation dialogue also states that deleting a site permanently removes its content and configuration.

Investigation

Querying PostgreSQL confirmed the following records for two independently created test sites:

Table	Site 1	Site 2
Pages	0	0
Site assets	0	0
Navigation	1	1
Tree	0	0
Storage	0	0
Blocks	0	0
Assets	0	0

Wiki.js automatically creates an empty navigation record when a new site is created.

The navigation table has the following foreign-key constraint:

FOREIGN KEY ("siteId") REFERENCES sites(id)

There is no ON DELETE CASCADE.

Confirmed workaround

Manually removing the navigation record associated with one test site:

DELETE FROM wiki.navigation
WHERE "siteId" = '<site-uuid>';

PostgreSQL returned:

DELETE 1

After removing this record, the site could be deleted successfully through the Wiki.js administration interface.

The second test site, which still has its automatically generated navigation record, remains undeletable.

Conclusion

The site deletion routine appears not to remove automatically generated navigation records before attempting to delete the site.

This prevents deletion of newly created sites, even when they contain no pages or assets.

The issue is reproducible with multiple newly created sites, and removing the navigation record resolves it.

[NGPixel]

Fixed in 3.0.0-beta.718

[macktic]

Thanks, confirmed fixed