MyBB Community Forums

Full Version: Forum permissions issue- sql query to change all permissions?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi

The forum permissions on my forum www.discorner.com/forum are messed up

The guests cannot view anything except the section names

Is there a way to change the permissions on all forums and categories by running sql queries?

Please help

Thank you
You can run this query:
UPDATE mybb_forumpermissions SET canview = 1, canviewthreads = 1 WHERE gid = 1
Add more columns separated by a comma. You can find the names here: https://github.com/mybb/mybb/blob/featur...#L238-L257

After running the query go to ACP -> Tools & Maintenance -> Cache Manager and rebuild the forumpermissions cache (or every cache).