MyBB Community Forums
[General] ACP User group Problem - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: [General] ACP User group Problem (/thread-151857.html)



ACP User group Problem - papclems - 2014-03-12

Hi,

i made a new install of mybb, version 1.6.12, but from the start i've noticed this problem when i try to change or manage the user group in the ACP.

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

SQL Error:
1054 - Unknown column 'cansendemailoverride' in 'field list'
Query:
UPDATE mybb_usergroups SET type='1', title='Administrators', description='The group all administrators belong to.', namestyle='{username}', usertitle='Administrator', stars='7', 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='1', canusepms='1', cansendpms='1', cantrackpms='1', candenypmreceipts='1', pmquota='0', maxpmrecipients='0', cansendemail='1', cansendemailoverride='0', maxemails='0', canviewmemberlist='1', canviewcalendar='1', canaddevents='1', canbypasseventmod='1', canmoderateevents='1', canviewonline='1', canviewwolinvis='1', canviewonlineips='1', cancp='1', issupermod='1', cansearch='1', canusercp='1', canuploadavatars='1', canchangename='0', showforumteam='1', usereputationsystem='1', cangivereputations='1', reputationpower='2', maxreputationsday='0', maxreputationsperuser='0', maxreputationsperthread='0', attachquota='0', cancustomtitle='1', canwarnusers='1', canreceivewarnings='1', maxwarningsday='0', canmodcp='1', showinbirthdaylist='0', canoverridepm='0', canusesig='1', canusesigxposts='0', signofollow='0' WHERE gid='4'

I do the verification, but it results no files damaged.

What i can do?

Thank you.


RE: ACP User group Problem - Nathan Malcolm - 2014-03-12

It looks like you're using a database which hasn't been upgraded yet, or hasn't been upgraded correctly.


RE: ACP User group Problem - papclems - 2014-03-13

You talk about the upgrade by mybb?

I've made two times, to solve the problems discovered by the validation task.

What solution can you suggest ?

thank you.

no more suggestions?

what i found is that if i try to solve the problem using a query, like [coe]ALTER TABLE mybb_usergroups ADD COLUMN cansendemailoverride int(1) NOT NULL DEFAULT '0'[/code]

the problem change and became

Quote: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='6', 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='1', 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='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='3'

so i suppose it is a problem with the users group.

When i go to the "user and permissions" some flags have no words beside, and if i flag and try to save, it drops me to the error page.

what do you think about?
thank you.