MyBB Community Forums

Full Version: When Editing Usergroup Image
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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`='0', `starimage`='images/star.gif', `image`='http://i.imgur.com/LPb4E.png', `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`='1', `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`='1', `canoverridepm`='0', `canusesig`='1', `canusesigxposts`='0', `signofollow`='0' WHERE gid='4'

Link: http://gtavkorner.net/
see replies here for SQL query to add that column
Run this:
alter table mybb_users add column (cansendemailoverride tinyint default 0);
PHP Code:
ALTER TABLE `mybb_usergroups` ADD COLUMN `cansendemailoverride` int(1) NOT NULL DEFAULT '0' 

This one worked.