MyBB Community Forums

Hi to all,

This evening I noticed that when I update group settings, I get this error:

Quote: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='Registered', description='After registration, all users are placed in this group by default.', namestyle='{username}', usertitle='', stars='0', 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='200', maxpmrecipients='5', cansendemail='1', cansendemailoverride='0', maxemails='5', canviewmemberlist='1', canviewcalendar='1', canaddevents='1', canbypasseventmod='0', canmoderateevents='0', canviewonline='1', canviewwolinvis='0', canviewonlineips='0', cancp='0', issupermod='0', cansearch='1', canusercp='1', canuploadavatars='1', canchangename='0', showforumteam='0', usereputationsystem='1', cangivereputations='1', reputationpower='1', maxreputationsday='5', maxreputationsperuser='0', maxreputationsperthread='0', attachquota='0', cancustomtitle='1', canwarnusers='0', canreceivewarnings='1', maxwarningsday='0', canmodcp='0', showinbirthdaylist='0', canoverridepm='0', canusesig='0', canusesigxposts='0', signofollow='0', cansharethreads='1', canmanagecomments='', cansendcomments='1', caneditselfcomments='1', candeleteselfcomments='', canuserpage='1', canuserpageedit='1', canuserpagemod='1' WHERE gid='2'

I deactived all plugins but the error remains.

These are the installed plugins:
Ajax Poll Voting (1.0)
Akismet (1.2.2) (Not installed)
Auto Media (2.1)
Guest warn (3)
Spider Bots (1.1)
Buy Credit (1.0)
Extra Mycode (1.1)
Facebook Like Button (1.0)
Favorite Threads (2.1.1)
FB-Bonus (1.0.0)
FBConnect (1.6.1)
FBCore (0.0.2)
Google SEO (1.6.3)
Hello World! (1.0) (Not installed)
Hello EditCore! (hello_pl.php)
PluginLibrary
Picasa Image Uploader (1.0)
IM Icons on Postbit (1.0.1)
iShare (1.2.1)
Keyword Generator (0.1)
Moderator and Author Only (1.0)
Mood Manager (1.1)
Move Posts (1.1.1)
Multiple Registrations Detector (1.1)
My Advertisements (2.0.3)
MyCode Installer (1.0) (Not installed)
MyShoutbox (1.7)
MySubscriptions (1.00) (Not installed)
Naoar Donation (2.0)
NewPoints (1.9.4)
Page Manager (1.5.2)
PHP and Template Conditionals (2.0)
PluginLibrary (8) (Not installed)
Plugin Uploader (1.1.2)
Pro Attachments (1.0)
Profile Comments (0.9.2)
Quick Theme (1.0)
Report PMs (1.2)
Reputation Power (1.0)
RSS Feed Poster (1.5) (Not installed)
Stop forum spam (1.2)
Tagging Plugin! (1.3.3)
Thread Tooltip Preview (1.32)
User Quickmenu In Postbit (1.0)
URL Titles (2.1)
User Tagging (1.0)
Userpages for MyBB (1.3)
Wiki (1.1.2)
Advanced WYSIWYG Editor (1.2.1)

I also ran upgrade from 1.6.7 to 1.6.8 but nothing....

No one?

Did you upgrade using Softaculous?

No, I didn't. However I got that error also before I ran upgrade.

Try To Repair

 REPAIR TABLE `mybb_usergroups` 

I Think it Will Work

I ran that query using MySquirrel in ACP. Problem not solved

(2012-08-23, 02:30 PM)Marks-Mans Wrote: [ -> ]Try To Repair

 REPAIR TABLE `mybb_usergroups` 

I Think it Will Work

It can't repair what's not there.

OP, re-run the upgrade script. Clearly the column wasn't added during the upgrade process.

I re-did it. Same problem...nothing changed.

This field was added with 1.6.4. Have you ran the upgrade properly when you upgraded from that?

I didn't remember what version I had. However I tried to re-upgrade from 1.6.5/6/7 (because I installed it some months ago) but I still got error.


PS: The version was 1.6.4. Thank you so much!