View Single Post
  #1  
Old 10-15-2007, 06:57 PM
tinkerbell's Avatar
tinkerbell tinkerbell is offline
 
Join Date: Jun 2006
Location: London, England
Posts: 100
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default database error - please help

Normally I am careful with trying to install add ons etc however I tried to install a chatbox which didnt work out exactly so i removed it again. The main problem with this is it was a couple of weeks ago and I hadnt realised it had left any thing behind.

Today after getting a couple of new members (very important as my membership is only at 30 lol) I tried to alter the PM settings for the registered users usergroup and to my horror I get this error displayed

Code:
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Registered Users',
	`description` = '',
	`usertitle` = '',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`forumpermissions` = '782847',
	`genericpermissions` = '237508295',
	`attachlimit` = '0',
	`pmquota` = '50',
	`pmpermissions` = '7',
	`pmsendmax` = '2',
	`calendarpermissions` = '63',
	`wolpermissions` = '1',
	`adminpermissions` = '0',
	`genericoptions` = '62',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '100',
	`avatarmaxheight` = '100',
	`avatarmaxsize` = '30000',
	`signaturepermissions` = '135199',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '100',
	`sigpicmaxsize` = '10000',
	`sigmaxrawchars` = '1000',
	`sigmaxchars` = '500',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '4',
	`nbmsgshowchatbox` = '',
	`mgccustomusergroupperms` = '0'
WHERE usergroupid=2;

MySQL Error  : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date         : Monday, October 15th 2007 @ 02:42:58 PM
Script       : http://www.xxxxxxxx.com/xxxxxxx/xxxxxxxxx/usergroup.php?do=update
Referrer     : http://www.xxxxxxx.com/xxxxxxx/xxxxxx/usergroup.php?do=edit&usergroupid=2
IP Address   : xx.xxx.xxx.x
Username     : xxxxxxxx
Classname    : vb_database
Can anyone tell me what this means or how to correct it?

If not can I import an sql query over the top of my database with an older database or would it rewrite all data not just the matching data?

Any help at all that doesnt involve me losing todays new members and posts lol.

If everything fails I can restore to an earlier time but really dont want to have to do that if possible.

Thank you for any help at all.
Tinks
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01358 seconds
  • Memory Usage 1,769KB
  • 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