PDA

View Full Version : Cant Edit UserGroups :(


Egor123
07-20-2008, 03:09 PM
Whenver I try to edit my usergroups i get this,
any ideas on what to do ? please
Database error in vBulletin 3.7.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `mgc_cb_evo_permissions`, `mgc_cb_evo_nbmsg_show`, `mgc_cb_evo_nbmsg_perday_show`, `creditpermissions`, `credit_induction`, `credit_referral`, `credit_refbonus`, `credit_paycheck`, `credit_active`, `credit_birthday`, `credit_repgive`, `credit_reputation`, `credit_infraction`, `credit_thread`, `credit_threadrate`, `credit_post`, `credit_ownthreadpost`, `credit_postsize`, `credit_ownthreadview`, `credit_ownthreadrate`, `credit_ownthreadreply`, `credit_ownprofileview`, `credit_pollmake`, `credit_pollvote`, `credit_attachment`, `credit_sendpm`, `credit_addevent`, `credit_addprofpic`, `credit_profile`, `credit_donmaxuser`, `credit_pastotpost`, `credit_pastotuser`, `credit_pasawuser`, `credit_pasawthread`, `credit_saveint`, `credit_maxsave`, `credit_loanint`, `credit_maxloan`, `credit_totloan`, `credit_goodgroup`, `credit_midgroup`, `credit_badgroup`, `credit_maxtickets`, `credit_lotdiscount`, `awardpermissions`)
VALUES
('Registered', '', '', '', '', '0', '0', '0', '0', '3928575', '1546130631', '0', '50', '3', '5', '63', '1', '0', '1', '62', '100', '100', '65535', '80', '80', '20000', '137215', '500', '100', '10000', '1000', '500', '0', '7', '4', '255', '600', '600', '100000', '100', '0', '31', '63', '375', '0', '', '', '0', '100', '100', '0.05', '0', '20', '100', '0.1', '2', '-10', '10', '1', '5', '3', '0.05', '0.05', '1', '2', '0.05', '5', '1', '3', '-2', '3', '3', '0', '-1', '0', '0', '0', '0', '0.035', '10000', '0.195', '1000', '5', '0', '0', '0', '10', '0', '1');

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, July 20th 2008 @ 09:07:25 AM
Error Date : Sunday, July 20th 2008 @ 09:07:25 AM
Script : http://www.chathabbo.com/forum/admincp/usergroup.php?do=update
Referrer : http://www.chathabbo.com/forum/admincp/usergroup.php?do=add
IP Address : 69.113.44.152
Username : Admin
Classname : vB_Database
MySQL Version : 4.1.22-max-log

snakes1100
07-20-2008, 03:14 PM
remove the xml file from your includes/xml directory for mgc's chatbox, it appears u uninstalled it.

Egor123
07-20-2008, 03:29 PM
thanks snakes1100 YOU ROCK!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! it worked!!!!! omgggggggg yay!!!

Dismounted
07-21-2008, 06:18 AM
Also, try using the search feature - I can recall having answered this question many, many times.