robboZ wrote: Mon Jul 24, 2023 8:44 pm
I don't think I ever touched this table. But this database is 15 years old (originated from punbb), so hard to say when they disappeared. I must check old backups.
As far as I can see you've got missing entries
and extra entries (extensions).
I suspect your _acl_options_ acl_roles,_acl_roles_data are also messed up.
Take a full database backup. You can truncate or leave out the search_tables (are these can be repopulated once the problem is solved). That's just to make sure that you can restore the current situation.
Then disable all extensions and delete data. (although you may want to try the actions below first and if that doesn't work the try again with disabled extensions (and data deleted).
Then try using an STK (for 3.3) and let it analyse the board to see what it comes up with.
If the STK can't fix it, you may have to revert to replacing those tables by original tables and then resetting the permissions for all users/groups (to be honest I can't remember ever having done that, so I'm not confident it won't break your board beyond repair : which is why you absolutely need a database backup before attempting this.)