MyBB Community Forums

When I edit my usergroups in my Admin CP I get the following error which I never used to get. I think I understand what the error is saying however I don't know the correct way of fixing it.

Any help fixing this would be greatly appreciated.

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1054 - Unknown column 'commentsperday' 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.png', image='', isbannedgroup=0, canview=1, canviewthreads=1, canviewprofiles=1, candlattachments=1, canviewboardclosed=0, canpostthreads=1, canpostreplys=1, canpostattachments=1, canratethreads=1, modposts=0, modthreads=0, mod_edit_posts=0, modattachments=0, caneditposts=1, candeleteposts=1, candeletethreads=1, caneditattachments=1, canpostpolls=1, canvotepolls=1, canundovotes=0, canusepms=1, cansendpms=1, cantrackpms=0, candenypmreceipts=0, pmquota=30, maxpmrecipients=10, cansendemail=1, cansendemailoverride=0, maxemails=10, emailfloodtime=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=1, canbereported=1, canchangewebsite=1, showforumteam=0, usereputationsystem=1, cangivereputations=1, candeletereputations=0, reputationpower=1, maxreputationsday=5, maxreputationsperuser=0, maxreputationsperthread=0, attachquota=30000, cancustomtitle=0, canwarnusers=0, canreceivewarnings=1, maxwarningsday=0, canmodcp=0, showinbirthdaylist=1, canoverridepm=0, canusesig=1, canusesigxposts=0, signofollow=0, edittimelimit=0, maxposts=0, showmemberlist=1, canmanageannounce=0, canmanagemodqueue=0, canmanagereportedcontent=0, canviewmodlogs=0, caneditprofiles=0, canbanusers=0, canviewwarnlogs=0, canuseipsearch=0, canactivateusers=1, usernameapproval=1, maxusernamesperiod=1, maxusernamesdaylimit=40, canmanagecomments='', cansendcomments=1, caneditowncomments=1, candeleteowncomments='', commentsperday=0 WHERE gid='2'

Please contact the MyBB Group for technical support.

Anyone able to help with this?

I still need help with this.

Are you using a plugin that allows some sort of commenting? Try uninstalling it.

I use MyProfile and Mod User Notes, both are quite important plugins for my board. Is there another way?

can you uninstall & reinstall MyProfile plugin (ensure that all its files exist in the plugins folder)

Seems to have fixed it, thanks