PDA

View Full Version : error in usergroup member


geevest.com
03-06-2007, 11:20 AM
found error in admincp..i want edit my usergroup member,,and found this :
Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Member',
`description` = 'user register',
`usertitle` = '',
`opentag` = '<span style=\"color:#21209C;\"><u>',
`closetag` = '</span></span></u>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`advanced_bbcode_usergroup_on` = '1',
`advpmoptions_options` = '0',
`profileviewpermissions` = '0',
`vbppermissions` = '4225',
`vbp_discountrate` = '0.00000',
`vbp_paycheckamount` = '0.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`uploaderperm` = '3',
`uploadermaxfilesize` = '200971',
`uploadermaxfoldesize` = '2104857',
`uploaderfilestypes` = 'jpg, jpe, jpeg, png, gif, txt, swf, rar, zip, doc, pdf',
`anymediapermissions` = '1',
`userratingperm` = '3',
`userratingday` = '0',
`forumpermissions` = '774655',
`attachlimit` = '0',
`pmquota` = '30',
`pmpermissions` = '2',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions` = '2666587',
`genericoptions` = '54',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '85535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '1024',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '60',
`awardpermissions` = '1',
`advanced_bbcode_permissions` = 'core||allow_bbcode_basic||1|||core||allow_bbcode_ color||1|||core||allow_bbcode_size||1|||core||allo w_bbcode_font||1|||core||allow_bbcode_align||1|||c ore||allow_bbcode_list||1|||core||allow_bbcode_url ||1|||core||allow_bbcode_code||1|||core||allow_bbc ode_php||1|||core||allow_bbcode_html||1|||non_core ||mod||0|||non_core||admin||0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 1054
Date : Tuesday, March 6th 2007 @ 08:03:32 PM
Script : http://www.abc.com/forum/admincp/usergroup.php?do=update
Referrer : http://www.abc.com/forum/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : 102.124.137.54
Username : admin
Classname : vb_database

anyone can help?

Marco van Herwaarden
03-06-2007, 11:28 AM
You have probably removed a modification, but not remove the bitfield_XXX.xml file from the includes/xml directory.

geevest.com
03-06-2007, 11:37 AM
modification of what?
module name?

harmor19
03-07-2007, 05:45 PM
What are the files that you have in includes/xml that start with "bitfield_"?