MyBB Community Forums

Full Version: SQL Error: 1054 - Unknown column 'canoverridepm' in 'field list'
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,

I've been struggling with this issue for a few months now so I reeeeeally need your help. Every time I try to add a new user group (in ACP) I get this error:

Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'canoverridepm' in 'field list'

Here is a picture of the entire error message: http://www.diigo.com/item/image/24nwx/umyj?size=o

Any suggestion would be extremely appreciated. Thanks.

Edit: I use MyBB 1.6.8
Try To Deactivate All your Plugins

Then See If You Get An Error
Wow, that was embarrassing! Smile) I needed to add the "canoverridepm" column inside "mybb_usergroups" table. After that I received another error saying that another column was missing, so I added that column as well. Finally, after adding 3-4 new columns (inside phpMyAdmin) I was able to create a new group successfully.
Thanks, Marks-Mans for your reply, I appreciate it. Smile