PDA

View Full Version : Database Error ONLY when changing group names


idhk
11-30-2011, 04:46 AM
Hey guys if this is posted and answered already i could not find it.

When ever i go to change a usergroup name (example) registered users to Members i get a database error, I havent done any major template edits yet, or havent added any major plug-ins im assuming something failed during install not sure what i should, if anything Re-upload

any help is welcomed, thanks in advance

http://screensnapr.com/v/QyBVAf.png
http://snpr.cm/Fnbojz.png
http://snpr.cm/l4jGhD.png

thats what i get everytime, and it happens if i change any usergroups name thanks

HMBeaty
11-30-2011, 04:50 AM
We need to see the whole error. Can you paste it here? However, from what I CAN see in the error, it looks like it's caused from a modification.

iDHKHCM
11-30-2011, 04:56 AM
we disabled all plugins and it still does it

Database error in vBulletin 4.1.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '180',
`passwordhistory` = '360',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_nbthreads_perday_show` = '',
`mgc_cb_evo_max_chats_perday` = '',
`forumpermissions` = '16777215',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '191',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=6;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Tuesday, November 29th 2011 @ 11:56:31 PM
Error Date : Tuesday, November 29th 2011 @ 11:56:31 PM
Script : http://highclassmods.com/ExpressMedia/admincp/usergroup.php?do=update
Referrer : http://highclassmods.com/ExpressMedia/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : 98.82.70.150
Username : DeadlyMoDz25
Classname : vB_Database
MySQL Version : 5.1.56-log

HMBeaty
11-30-2011, 05:01 AM
Well here you go....
MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
mgc_cb_evo_permissions is I'm guessing from the mgc chatbox modification, disable/uninstall that, including the files, and your error should go away

idhk
11-30-2011, 05:09 AM
Well here you go....

mgc_cb_evo_permissions is I'm guessing from the mgc chatbox modification, disable/uninstall that, including the files, and your error should go away

WOW you are fast! thanks for your help. Also Lynne to https://www.vbulletin.com/forum/showthread.php/299263-Usergroup-produces-a-database-error

I guess someone else had the issue. but yeah dang chatbox. it was in the includes-xml i almost we almost unistalled everything from admincp lol thanks again