Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 3 Years, 7 Months, 1 Week ago [Error Message] SQL Error 1054 - Usergroup
#1
Solved: 3 Years, 7 Months, 1 Week ago
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.
Reply
#2
Solved: 3 Years, 7 Months, 1 Week ago
Anyone able to help with this?
Reply
#3
Solved: 3 Years, 7 Months, 1 Week ago
I still need help with this.
Reply
#4
Solved: 3 Years, 7 Months, 1 Week ago
Are you using a plugin that allows some sort of commenting? Try uninstalling it.
RedHat Certified Systems Administrator
Reply
#5
Solved: 3 Years, 7 Months, 1 Week ago
I use MyProfile and Mod User Notes, both are quite important plugins for my board. Is there another way?
Reply
#6
Solved: 3 Years, 7 Months, 1 Week ago
can you uninstall & reinstall MyProfile plugin (ensure that all its files exist in the plugins folder)
Reply
#7
Solved: 3 Years, 7 Months, 1 Week ago
Seems to have fixed it, thanks Smile
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)