MyBB Community Forums

I get this when clicking Edit & Save user profile:

MyBB has experienced an internal SQL error and cannot continue.
SQL Error: 1054 - Unknown column 'skype' in 'field list' Query: UPDATE bb_users SET email='[email protected]', postnum=0, threadnum=0, usergroup=4, additionalgroups='', displaygroup=4, usertitle='', signature='', website='', icq=0, skype='', google='', birthday='', style=6, timezone='0', dateformat='0', timeformat='0', language='', away=0, awaydate='0', returndate='0', awayreason='', usernotes='', allownotices=1, hideemail=0, subscriptionmethod=0, invisible=0, dstcorrection=0, threadmode='linear', classicpostbit=0, showimages=0, showvideos=0, showsigs=1, showavatars=1, showquickreply=1, receivepms=1, receivefrombuddy=0, pmnotice=1, daysprune=0, showcodebuttons=1, sourceeditor=0, pmnotify=1, buddyrequestspm=0, buddyrequestsauto=0, showredirect=1, tpp=0, ppp=0, dst=0 WHERE uid='124966'
Please contact the MyBB Group for technical support.




In Admin/home/Preferences I see this:



MyBB has experienced an internal SQL error and cannot continue.

SQL Error: 1054 - Unknown column 'cplanguage' in 'field list' Query: SELECT notes, cpstyle, cplanguage, codepress, authsecret FROM bb_adminoptions WHERE uid='1' LIMIT 1

Please contact the MyBB Group for technical support.





Only plugin that is installed is MyAdvertisements.



I was looking for Cookie settings but the Inc/settings seems ok and I have no cache installed. And settings in Site detail seems to be ok.

Hi, it is possible your files don't match your installed version. Both the skype and cplanguage field is a core columns:
https://github.com/mybb/mybb/blob/cdfe37....php#L1074
https://github.com/mybb/mybb/blob/cdfe37...es.php#L25

Try to update your forum to the latest version, if you think your forum is already in the latest version then try to replace all files from the package again (without running the upgrade script).

Thanks.

I upgraded from 1.8.22 to 1.8.24 but I still get the same error.

I got 77 columns in bb_users. In another working forum I got 95 columns. Some earlier update must have gone wrong...

And maybe there are more tables with missing columns...

Can this be repaired?

Compare what columns you have with those in this file: https://github.com/mybb/mybb/blob/featur...tables.php

You can add, edit, and delete columns using PHPMyAdmin from your web hosting panel.

Found a ton of columns that are missing. Might be easier just to reinstall from scratch...