Log in

View Full Version : SQL error, can't change any usergroup


katie hunter
07-31-2007, 07:14 AM
Hi , I tried to edit any of my user group permission and i always get this mysql error
can someone help plz if they know

I can't change any of the settings, for any user group cause i always get this error

I see i have this extra field which i have no idea where it came from, i see it in every usergroup. And it has no name.
MySQL Error : Unknown column 'hhroptions' in 'field list'

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`genericpermissions` = '1072693215',
`attachlimit` = '0',
`pmquota` = '300',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericoptions` = '55',
`profilepicmaxwidth` = '300',
`profilepicmaxheight` = '300',
`profilepicmaxsize` = '305535',
`avatarmaxwidth` = '300',
`avatarmaxheight` = '300',
`avatarmaxsize` = '105535',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '4000',
`sigmaxchars` = '4000',
`sigmaxlines` = '1000',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`mp3playergrouppermissions` = '3',
`awardpermissions` = '1',
`hhroptions` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'hhroptions' in 'field list'
Error Number : 1054
Date : Tuesday, July 31st 2007 @ 03:08:05 AM
Script : http://forum.nihonomaru.com/admincp/....php?do=update
Referrer : http://forum.nihonomaru.com/admincp/...&usergroupid=6


************************************************** ******************

This is the hack it is causing the error:

hhr = hide hade resurrection
when i disbale it, i get this error

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /includes/class_postbit.php(300) : eval()'d code on line 63

but i can edit my usergroups, and when i enable it this error goes away but i can't edit any of the usergroup cause of that error/ this extra field this hack is adding

MySQL Error : Unknown column 'hhroptions' in 'field list'

can someone help =/

Marco van Herwaarden
07-31-2007, 08:22 AM
When you uninstalled this modification (hhr??) you did not remove the ./includes/xml/bitfield_XXXX.xml file that belongs to this modification. Please remove that file.

katie hunter
07-31-2007, 12:24 PM
I don't see it the xxx.xml but my friend added the table manual and it is fixed.
Thanks for the advice though.

Dismounted
08-01-2007, 07:40 AM
You're using a workaround, which is not recommended.