Unable to delete site about goatcounter HOT 4 OPEN

There isn't really a way to fix this without manually altering the IDs; the first site you create is the main "account", and the other sites are linked to that by setting the parent column to that site ID.

This should really be split out in to an "account" and "site" table, or something, but it's a fairly large refactor. It doesn't use the "parent → child" terminology in the UI any more, but it's still in the code.

At any rate, you can set a new "account site" with something like:

update sites set parent=2 where parent=1;

You'll need to restart goatcounter, as sites are cached in memory.

from goatcounter.

Oh, you'll also need to update the users table:

update users set site_id=2 where site_id=1;

from goatcounter.

Thanks for above info! Changes worked fine.

A bit more verbose/structured procedure for future reference.

1. Stop Goatcounter
2. Start container with SQLite (if you don't have SQLite available)

sudo docker run --rm -v ${PATH_TO_GOATCOUNTER_DB:?}:/db.sqlite3 -it alpine
apk add sqlite
sqlite3 /db.sqlite

3. Update DB

-- Nicer output
.mode table

-- Find new parent id
select site_id, parent, cname from sites;

-- Replace "parent=3" with new parent id and "parent=1" with old parent id
update sites set parent=3 where parent=1;

-- Validate new parent id
select site_id, parent, cname from sites;

-- Check users before change of parent site id
select user_id, site_id, email from users;

-- Replace "site_id=3" with new parent id and "site_id=1" with old parent id
update users set site_id=3 where site_id=1;

-- Validate changes to users
select user_id, site_id, email from users;

4. Start Goatcounter again

from goatcounter.

It can just be changed to do the above automatically on deletion; that's actually much easier than splitting out the tables.

from goatcounter.