The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
SQL error, can't change any usergroup
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 =/ |
#2
|
|||
|
|||
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.
|
#3
|
||||
|
||||
I don't see it the xxx.xml but my friend added the table manual and it is fixed.
Thanks for the advice though. |
#4
|
||||
|
||||
You're using a workaround, which is not recommended.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|