Jim Boy
Well-known member
Over time, our board has accumulated alot of individual based permissions. Subsequently the permissions cache has grown to around 500 MB in size. This has lead to issues of add-ons taking a long time to load, any time I update the software, I have to allow php to run scripts of 500MB in size otherwise the updates fail. Often have problems with permissions on usergroups etc. So I've decided to try a bulk cleanout by deleting all individual based permissions (user_id>0) from permission_entry, permission_entry_content and permission_combination via a sql script. I'll also be excluding any mods or staff from this clean up. A typical script would be "delete from xf_permission_entry where user_id>0 and user_id not in (select user_id from xf_user where is_moderator=1 or is_admin=1 or is_staff=1)".
I've tested this on my test box, and it seems ok, but I'd like the opinion people who actually know the the permissions system at a high technical level before I proceed.
And yes, I have run the permissions clean up task.
I've tested this on my test box, and it seems ok, but I'd like the opinion people who actually know the the permissions system at a high technical level before I proceed.
And yes, I have run the permissions clean up task.