No it is not trivial - in fact just restoring those two tables will have you in a worse state than you. Many tables in phpBB are interlinked and if you do not maintain that linking you will break your board.
No it is not trivial - in fact just restoring those two tables will have you in a worse state than you. Many tables in phpBB are interlinked and if you do not maintain that linking you will break your board.
yeah i supposed that was poorly worded. i am comfortable doing the work, with some guidance from someone more experienced with databases than i. so let me rephrase - is there a way to extract the content of a board and restore it to a fresh install without risk of corruption or other weirdness that would be worse than i am experiencing now? i'm happy to do that, if so. but to your point, don't want to shoot myself in the foot. appreciate the feedback.
right. but assuming i manually make the changes to permissions and roles - and that works as expected - i don't know that this alone solves anything. again, maybe over-thinking this, but i'm assuming there may be other issues in the db i haven't encountered yet. guess i'll find out.
i do have a backup from prior to running stk.
The tables
Code: Select all
phpbb_acl_groups - Permission roles and/or individual permissions assigned to groups
phpbb_acl_options - List of possible permissions
phpbb_acl_roles - Permission roles (Standard Moderator, Simple Moderator etc.)
phpbb_acl_roles_data - Permissions each role contains
phpbb_acl_users - Permission roles and/or individual permissions assigned to users
sure, but what am i looking for?3Di wrote: ↑Thu Sep 23, 2021 3:48 pmThe tables
are involved, can you bump those tables (from the backup) to a file to investigate.Code: Select all
phpbb_acl_groups - Permission roles and/or individual permissions assigned to groups phpbb_acl_options - List of possible permissions phpbb_acl_roles - Permission roles (Standard Moderator, Simple Moderator etc.) phpbb_acl_roles_data - Permissions each role contains phpbb_acl_users - Permission roles and/or individual permissions assigned to users
You probably nothing, I would like to investigate them if you don't mind.
much appreciated. again, i'm fine with going through and re-building the permissions on all the groups if necessary, wouldn't take more than an hour. i'm just hoping the quirks uncovered in this thread aren't indicative of a larger problem, but i suppose time will tell. thank you again for having a look!