Orphaned Groups - just delete Database rows?

Kaldek13 days ago

Somehow, and I am not sure how I did this, I have orphaned a bunch of groups. I've checked the database (PostGreSQL) and I can see the groups, and there is no matching userID for any of these groups in the tc_user_group table.

Safe to just delete the groups from the tc_groups table, or should I create rows in the tc_user_group table to assign them to a user, and then delete from the web interface?

Track-trace13 days ago

Its safe to make a backup first and make a dump of the database which you could restore right?

Kaldek13 days ago

Sure, of course. I'll be making a backup regardless but figured it does not hurt to ask.

Kaldek13 days ago

Took a look at my backup; sure enough the Admin user owned these groups - and that acount still exists - but now the records are orphaned.

I guess there's an edge case somewhere where this can happen.

Anton Tananaev13 days ago

An admin can always un-link something from a user account.