Cant create or edit usergroup.. !! :- Database error

[sebil]

When i try to edit or create usergroup i m getting database error


Please helppp

Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'System Management',
`description` = '',
`usertitle` = 'TECHNICIAN',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`passivevideo_sig` = '1',
`hhroptions` = '0',
`forumpermissions` = '16777215',
`genericpermissions` = '2147483647',
`attachlimit` = '10000000',
`pmquota` = '5000',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '2500000',
`avatarmaxwidth` = '175',
`avatarmaxheight` = '175',
`avatarmaxsize` = '2000000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '3',
`albumpermissions` = '255',
`albumpicmaxwidth` = '0',
`albumpicmaxheight` = '0',
`albumpicmaxsize` = '1000000000',
`albummaxpics` = '200',
`albummaxsize` = '1000000',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '10',
`groupiconmaxsize` = '200',
`mp3playergrouppermissions` = '3',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_max_chats_perday` = '',
`ms_imageshack_upload_permissions` = '16383',
`arcadepermissions` = '255',
`minpoststoplay` = '0',
`minreptoplay` = '0',
`minreglengthtoplay` = '0',
`creditpermissions` = '0',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_paycheck` = '0',
`credit_active` = '20',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reputation` = '2',
`credit_infraction` = '-10',
`credit_thread` = '10',
`credit_threadrate` = '1',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.05',
`credit_ownthreadview` = '0.05',
`credit_ownthreadrate` = '1',
`credit_ownthreadreply` = '2',
`credit_ownprofileview` = '0.05',
`credit_pollmake` = '5',
`credit_pollvote` = '1',
`credit_attachment` = '3',
`credit_sendpm` = '-2',
`credit_addevent` = '3',
`credit_addprofpic` = '3',
`credit_profile` = '0',
`credit_donmaxuser` = '-1',
`credit_pastotpost` = '0',
`credit_pastotuser` = '0',
`credit_pasawuser` = '0',
`credit_pasawthread` = '0',
`credit_saveint` = '0.035',
`credit_maxsave` = '10000',
`credit_loanint` = '0.195',
`credit_maxloan` = '1000',
`credit_totloan` = '5',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '10',
`credit_lotdiscount` = '0',
`videodirectorypermissions` = '0',
`passivevideo_stack0` = '7',
`passivevideo_stack1` = '0'
WHERE usergroupid=31;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 5th 2009 @ 03:02:04 PM
Error Date : Wednesday, August 5th 2009 @ 03:02:04 PM
Script : http://www.malludreams.com/admincp/u....php?do=update
Referrer : http://www.malludreams.com/admincp/u...usergroupid=31
IP Address : 78.151.174.120
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.51a-community

Please helppppppppppppp

[Marco van Herwaarden]

You have removed a modifiction but have not removed all the files belonging to the modification. Please remove all the files, especially the ./includes/xml/bitfield_XXX.xml belonging to the product.

PS Please update the URL your license is used on in the Members' Area. Currently your site is unlicensed.

[sebil]

emmm .... it is licensedddddd

and is there any way to find which modification's file is still remain in the server..

--------------- Added [DATE]1249479354[/DATE] at [TIME]1249479354[/TIME] ---------------

updated the URL.. sorry i was using my previous domain name

[mcrider]

It looks like it is a file associated with the MGC Chatbox Evo modification...

[Marco van Herwaarden]

'mgc_cb_evo'

That is most likely the productid.

[sebil]

I removed one bitfield file from xml folder...
which was a blog installation file...


Now the error changed to

Database error in vBulletin 3.8.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `passivevideo_sig`, `videodirectorypermissions`, `hhroptions`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `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`, `maximumsocialgroups`, `groupiconmaxsize`, `mp3playergrouppermissions`, `mgc_cb_evo_permissions`, `mgc_cb_evo_refreshrate`, `mgc_cb_evo_nbmsg_show`, `mgc_cb_evo_nbmsg_perday_show`, `mgc_cb_evo_max_chats_perday`, `ms_imageshack_upload_permissions`, `arcadepermissions`, `minpoststoplay`, `minreptoplay`, `minreglengthtoplay`, `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`, `passivevideo_stack0`, `passivevideo_stack1`)
VALUES
('System Management', 'Official MD Technical Support Member', 'System Management', '<strong><font color=\"#CC0033\">', '</font></strong></b>', '180', '360', '0', '0', '1', '511', '0', '16777215', '2147483647', '0', '65535', '7', '10', '0', '63', '31', '3', '1', '55', '140', '190', '65535', '250', '261', '20000000', '245759', '500', '100', '10000', '0', '0', '0', '7', '0', '255', '600', '600', '100000', '100', '0', '63', '63', '65535', '5', '65535', '3', '0', '', '', '', '', '16383', '255', '0', '-1000', '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', '7', '0');

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 5th 2009 @ 03:44:44 PM
Error Date : Wednesday, August 5th 2009 @ 03:44:44 PM
Script : http://www.malludreams.com/admincp/u....php?do=update
Referrer : http://www.malludreams.com/admincp/usergroup.php?do=add
IP Address : 78.151.174.120
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.51a-community

--------------- Added [DATE]1249480260[/DATE] at [TIME]1249480260[/TIME] ---------------

Originally Posted by Marco van Herwaarden

'mgc_cb_evo'

That is most likely the productid.

i removed it and tried...


But now the error is...

Database error in vBulletin 3.8.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `passivevideo_sig`, `videodirectorypermissions`, `hhroptions`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `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`, `maximumsocialgroups`, `groupiconmaxsize`, `mp3playergrouppermissions`, `mgc_cb_evo_permissions`, `mgc_cb_evo_refreshrate`, `mgc_cb_evo_nbmsg_show`, `mgc_cb_evo_nbmsg_perday_show`, `mgc_cb_evo_max_chats_perday`, `ms_imageshack_upload_permissions`, `arcadepermissions`, `minpoststoplay`, `minreptoplay`, `minreglengthtoplay`, `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`, `passivevideo_stack0`, `passivevideo_stack1`)
VALUES
('System Management', 'Official MD Technical Support Member', 'System Management', '<strong><font color=\"#CC0033\">', '</font></strong></b>', '180', '360', '0', '0', '1', '511', '0', '16777215', '2147483647', '0', '65535', '7', '10', '0', '63', '31', '3', '1', '55', '140', '190', '65535', '250', '261', '20000000', '245759', '500', '100', '10000', '0', '0', '0', '7', '0', '255', '600', '600', '100000', '100', '0', '63', '63', '65535', '5', '65535', '3', '0', '', '', '', '', '16383', '255', '0', '-1000', '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', '7', '0');

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 5th 2009 @ 03:46:45 PM
Error Date : Wednesday, August 5th 2009 @ 03:46:46 PM
Script : http://www.malludreams.com/admincp/u....php?do=update
Referrer : http://www.malludreams.com/admincp/usergroup.php?do=add
IP Address : 78.151.174.120
Username : MalluDreams
Classname : vB_Database
MySQL Version : 5.0.51a-community

--------------- Added [DATE]1249480432[/DATE] at [TIME]1249480432[/TIME] ---------------

yeyeye... problem solved... ;


Thank youuuuuuuuu

Marco van Herwaarden and mcrider

[PvOwnage]

This was posted in 2009 but I just had this error and this is how i fixed it

Run this query in phpmyadmin:

ALTER TABLE `usergroup` ADD `albumpicmaxsize` int (10) unsigned NOT NULL default '0 '