MyBB verson: 1.4.5
I get a error saying:
Quote:The forums has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'canmanageannounce' in 'field list'
Query:
UPDATE mybb_users SET canmanageannounce='0', canuseproeditor='0', canbanusers='0', canviewwarnlogs='0', canuseipsearch='0' WHERE uid='2'
Please contact the Administrator for support.
i get that error when i try to edit a user in side of the edit user panel.
but the user still updates, but i get that error. no idea what is worng.
Did you run the upgrade script OK?? Choose the right version?? Upload the right files??
yes i did, this was happing BEFORE i upgraded to mybb 1.4.5 i hoped the upgrade would fix it, but it didnt, i think it was a plugin named "extra moderator controls" or somthing, i removed the plugin, but it didnt fix anything
Could you post all your plugins?
Admins can log into Users' accounts (1.0)
Ads after first post (2.2)
Akismet (1.2.1)
Banned Fun (1.0)
Buddies In UserProfile (1.0)
Default Profile (2.1.0)
Fast Menu (0.2b)
Last Threads, Posts and Popular Threads on UserCP Home (1.0)
Locked Thread Quick Reply Warning (1.0)
Mail on activation (1.4)
Meta - Tag Plugin (1.0)
Miss You Email (1.0.0)
Extra Moderator Permissons (1.2)
MyMood (1.0 Beta)
Multi Video Mycode For MyBB (1.8)
Site News Plugin (1.0.3)
Online Today (1.1)
Permission Box For MyBB 1.4 (1.00)
Posts Required To View Forums (1.0)
ProfileTube (1.0)
Profile View Counter (1.0)
Show Users Who Have Been Registered Today (1.0)
Reputation Manager (1.2)
Restricted private messages (2.0)
SEO Links! (1.1 Beta 1)
Social Sharing Button (1.0)
User Agent (1.4)
Specific forum banning (1.0.1)
User Guestbooks (1.0)
What version were you running right before this error started appearing?
i have once used it yes, i had it installed, then i removed it.
Seems like it did not uninstall properly. I would suggest loading all the files for the modification again and then double check to see it shows as uninstalled in the admin cp. If it still shows as installed then click uninstall. You also could try installing it again and uninstalling it to see if it fixes the problem. I would make sure to make a copy of the database first.