MyBB Community Forums

Full Version: SQL Error: 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.
How the error came about: I was going into the Super Moderator group on my ACP to make sure that they were able to have a signature (the entire site's been having trouble with not being able to display signatures). The box next to display signature wasn't checked, so I checked it and clicked save. It happens anytime I try to save a change to a group in the ACP. This appeared:

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='Super Moderators', description='These users can moderate any forum.', namestyle='{username}', usertitle='Super Moderator', stars='0', starimage='images/star.gif', image='images/ranking/supermod.jpg', 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', cansendemailoverride='0', maxemails='10', canviewmemberlist='1', canviewcalendar='1', canaddevents='1', canbypasseventmod='1', canmoderateevents='1', canviewonline='1', canviewwolinvis='1', canviewonlineips='1', cancp='0', issupermod='1', cansearch='1', canusercp='1', canuploadavatars='1', canchangename='1', showforumteam='1', usereputationsystem='0', cangivereputations='0', reputationpower='1', maxreputationsday='10', maxreputationsperuser='0', maxreputationsperthread='0', attachquota='0', cancustomtitle='1', canwarnusers='0', canreceivewarnings='0', maxwarningsday='3', canmodcp='1', showinbirthdaylist='0', canoverridepm='1', canusesig='1', canusesigxposts='0', signofollow='1' WHERE gid='3'

What I've done so far: I've re-run the latest upgrade. Nothing changed.
Any help would be greatly appreciated!
Current issues, I did update after handling 1.6.13 to 1.6.14...
Waiting for help, thank you in advance for your interest.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'showinbirthdaylist' in 'field list''
Sorgu:
UPDATE mybb_usergroups SET type='1', title='Guests', description='The default group that all visitors are assigned to unless they\'re logged in.', namestyle='{username}', usertitle='Unregistered', stars='0', starimage='', image='', isbannedgroup='0', canview='1', canviewthreads='1', canviewprofiles='0', candlattachments='0', canpostthreads='0', canpostreplys='0', canpostattachments='0', canratethreads='0', caneditposts='1', candeleteposts='1', candeletethreads='1', caneditattachments='1', canpostpolls='0', canvotepolls='0', canundovotes='0', canusepms='0', cansendpms='0', cantrackpms='0', candenypmreceipts='0', pmquota='0', maxpmrecipients='5', cansendemail='0', cansendemailoverride='0', maxemails='5', canviewmemberlist='0', canviewcalendar='1', canaddevents='0', canbypasseventmod='0', canmoderateevents='0', canviewonline='0', canviewwolinvis='0', canviewonlineips='0', cancp='0', issupermod='0', cansearch='1', canusercp='0', canuploadavatars='0', canchangename='0', showforumteam='0', usereputationsystem='0', cangivereputations='0', reputationpower='0', maxreputationsday='0', maxreputationsperuser='0', maxreputationsperthread='0', attachquota='0', cancustomtitle='0', canwarnusers='0', canreceivewarnings='0', maxwarningsday='0', canmodcp='0', showinbirthdaylist='0', canoverridepm='0', canusesig='0', canusesigxposts='0', signofollow='0', canmanagecomments='', cansendcomments='', caneditselfcomments='', candeleteselfcomments='' WHERE gid='1'
^ have you actually followed the upgrading process - see upgrading guidance
showinbirthdaylist has been added with MyBB 1.6.5(!).