View Single Post
  #1  
Old 08-08-2006, 09:05 PM
terry123's Avatar
terry123 terry123 is offline
 
Join Date: Aug 2002
Location: United Kingdom
Posts: 32
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Vbulletin Problem

Hi Everyone,

Been using VB for many years and installing modifications for some time, but for some reason am unable to change any settings for the usergroups - every time I try to change an option from NO to Yes I get a database error which is below.

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'UFA Super Moderators',
	`description` = '',
	`usertitle` = 'UFA Super Moderator',
	`opentag` = '<span style=\"color: blue;\">',
	`closetag` = '</span>',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`forumpermissions` = '1048575',
	`attachlimit` = '0',
	`hhroptions` = '0',
	`pmquota` = '50',
	`pmpermissions` = '3',
	`pmsendmax` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '15',
	`adminpermissions` = '1',
	`genericpermissions` = '204429039',
	`genericoptions` = '31',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '80',
	`avatarmaxheight` = '80',
	`avatarmaxsize` = '20000',
	`vbghsepermissions` = '0'
WHERE usergroupid=5;

MySQL Error  : Unknown column 'hhroptions' in 'field list'
Error Number : 1054
Date         : Tuesday, August 8th 2006 @ 10:00:56 PM
Script       : http://mysite.co.uk/forum/admincp/usergroup.php
Referrer     : http://mysite.co.uk/forum/admincp/usergroup.php?do=edit&usergroupid=5
IP Address   : *********
Username     : ******
Classname    : vb_database
Any help or suggestions would be gratefully appreciated as I have just installed the VBookie modification and no users can use it as I cannot set the option to YES in the usergroup manager.

Thanks

Terry
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01369 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete