Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 07-31-2007, 07:14 AM
katie hunter's Avatar
katie hunter katie hunter is offline
 
Join Date: May 2007
Posts: 533
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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 =/
Reply With Quote
  #2  
Old 07-31-2007, 08:22 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 07-31-2007, 12:24 PM
katie hunter's Avatar
katie hunter katie hunter is offline
 
Join Date: May 2007
Posts: 533
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't see it the xxx.xml but my friend added the table manual and it is fixed.
Thanks for the advice though.
Reply With Quote
  #4  
Old 08-01-2007, 07:40 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You're using a workaround, which is not recommended.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:41 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03946 seconds
  • Memory Usage 2,184KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete