MyBB Community Forums

My Board: http://clanhot.org/
Ver: 1.6.8

The issue I'm having is every time I try to edit a user group in admin CP I keep getting this error, can someone please help?

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='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='1', 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='1', canviewcalendar='1', canaddevents='0', canbypasseventmod='0', canmoderateevents='0', canviewonline='1', 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', mystatus_can_use='0', mystatus_can_moderate='0', mystatus_can_delete_own='0' WHERE gid='1'

Hello there,

The forum you have posted does not have the minimum "Powered by MyBB" notice we require for technical support here. In order for us to give you further support, please add the following code to the footer template of your forum:

Admin CP --> Templates & Style --> *expand your template set* --> Footer Templates --> footer

Powered by <a href="http://www.mybb.com">MyBB</a>

I will close this thread until you have reinstated the Powered By line. Please post in the Private Inquiries forum to ask to have this thread reopened, where you can also raise any questions you have about this policy.

With regards,
MyBB Support Team

He must have added it, I see it now...

This column was added between MyBB 1.6.7 and MyBB 1.6.8, but the upgrade script did not include the column. I think it's a bug in their upgrade script (it says "Nothing to do for 1.6.7"). You can add it manually by running the statement below, and your error will be resolved.

alter table mybb_usergroups add column (cansendemailoverride int(1) NOT NULL default 0);

You needed to add "cansendemailoverride" column inside "mybb_usergroups" table.

Run this Query :

ALTER TABLE mybb_usergroups ADD cansendemailoverride VARCHAR(50);

(2012-10-12, 02:12 PM)Marks-Mans Wrote: [ -> ]You needed to add "cansendemailoverride" column inside "mybb_usergroups" table.

Run this Query :

ALTER TABLE mybb_usergroups ADD cansendemailoverride VARCHAR(50);

Isn't that what I just said above? And it's only storing one integer (0 or 1), varchar(50) is unnecessary and poor database design.