MyBB Community Forums

Full Version: 1054 - Unknown column 'showinbirthdaylist' in 'field list'
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I got this error when trying to update a user in the Admin CP
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'showinbirthdaylist' in 'field list'
Query:
UPDATE mybb_usergroups SET type='1', title='Moderators', description='These users moderate specific forums.', namestyle='{username}', usertitle='Moderator', stars='5', starimage='images/star.gif', image='', isbannedgroup='0', canview='1', canviewthreads='1', canviewprofiles='1', candlattachments='1', canpostthreads='1', canpostreplys='1', canpostattachments='1', canratethreads='1', caneditposts='1', candeleteposts='1', candeletethreads='1', caneditattachments='1', canpostpolls='1', canvotepolls='1', canundovotes='0', canusepms='1', cansendpms='1', cantrackpms='1', candenypmreceipts='1', pmquota='250', maxpmrecipients='5', cansendemail='1', maxemails='5', canviewmemberlist='1', canviewcalendar='1', canaddevents='0', canbypasseventmod='0', canmoderateevents='0', canviewonline='1', canviewwolinvis='0', canviewonlineips='0', cancp='0', issupermod='0', cansearch='1', canusercp='1', canuploadavatars='1', canchangename='0', showforumteam='1', usereputationsystem='1', cangivereputations='1', reputationpower='1', maxreputationsday='10', maxreputationsperuser='0', maxreputationsperthread='0', attachquota='0', cancustomtitle='1', canwarnusers='1', canreceivewarnings='1', maxwarningsday='3', canmodcp='1', showinbirthdaylist='0', canoverridepm='0', canusesig='1', canusesigxposts='0', signofollow='0' WHERE gid='6'

Would it be enough to just create the field showinbirthdaylist

This is MyBB 1.6.5 and was upgraded from 1.6.4
the url is http://forums.cutabovehost.com/
Did you follow these steps?

http://wiki.mybb.com/index.php/Upgrading

Yes I did.
I stepped through the upgrade process again and it corrected the SQL problem. I was able to update the user group after the second upgrade attempt.