Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 11 Years, 4 Months ago When Editing Usergroup Image
#1
Solved: 11 Years, 4 Months ago
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/
#2
Solved: 11 Years, 4 Months ago
see replies here for SQL query to add that column
#3
Solved: 11 Years, 4 Months ago
Run this:
alter table mybb_users add column (cansendemailoverride tinyint default 0);
RedHat Certified Systems Administrator
#4
Solved: 11 Years, 4 Months ago
PHP Code:
ALTER TABLE `mybb_usergroups` ADD COLUMN `cansendemailoverride` int(1) NOT NULL DEFAULT '0' 

This one worked.
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)