Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2007, 12:46 PM
Symbian Galaxy Symbian Galaxy is offline
 
Join Date: Jun 2007
Location: India
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Hell! , DB error!

I get this while changing the Usergroup Settings


Code:
Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Team Leader',
    `description` = '',
    `usertitle` = 'Team Leader',
    `opentag` = '<b><font color=\"#33ccff\">',
    `closetag` = '</font></b>',
    `passwordexpires` = '0',
    `passwordhistory` = '0',
    `ispublicgroup` = '0',
    `canoverride` = '0',
    `advanced_bbcode_usergroup_on` = '1',
    `nbmsgshowchatbox` = '',
    `mgccustomusergroupperms` = '0',
    `forumpermissions` = '1048575',
    `genericpermissions` = '1073741823',
    `attachlimit` = '0',
    `pmquota` = '200',
    `pmpermissions` = '0',
    `pmsendmax` = '5',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '1',
    `genericoptions` = '63',
    `profilepicmaxwidth` = '150',
    `profilepicmaxheight` = '150',
    `profilepicmaxsize` = '25000',
    `avatarmaxwidth` = '50',
    `avatarmaxheight` = '50',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '0',
    `sigpicmaxheight` = '0',
    `sigpicmaxsize` = '0',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `displayorder` = '3',
    `advanced_bbcode_permissions` = 'core||allow_bbcode_basic||1|||core||allow_bbcode_color||1|||core||allow_bbcode_size||1|||core||allow_bbcode_font||1|||core||allow_bbcode_align||1|||core||allow_bbcode_list||1|||core||allow_bbcode_url||1|||core||allow_bbcode_code||1|||core||allow_bbcode_php||1|||core||allow_bbcode_html||1|||non_core||imgreflect||0|||non_core||marq||0|||non_core||hl||1|||non_core||button||1|||non_core||blink||1|||non_core||hide||1|||non_core||s||1'
WHERE usergroupid=12;

MySQL Error  : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date         : Wednesday, August 29th 2007 @ 04:09:01 AM
Script       : 
Referrer     : 
IP Address   : 
Username     :
Classname    : vb_database

Tried disabling Hooks too + Uploaded vBulletin once more!
Reply With Quote
  #2  
Old 08-31-2007, 12:49 PM
Mean Mean is offline
 
Join Date: Jun 2007
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nbmsgshowchatbox encourages the problem. Try to delete all codes and files about that.
And delete the Team Leader group.
Reply With Quote
  #3  
Old 08-31-2007, 03:19 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That is not the best advice to give. Why delete the usergroup? I see absolutly no reason to do so.

To solve your problem: When installing that modification (chatbox??) you have also uploaded a ./includes/xml/bitfield_XXXX.xml that belongs to this modification. You have later uninstalled the modification, but left this file on the server. Remove the file ad edit any usergroup and all should be back to normal.
Reply With Quote
  #4  
Old 08-31-2007, 03:49 PM
Symbian Galaxy Symbian Galaxy is offline
 
Join Date: Jun 2007
Location: India
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Marco you rock! Thanks Mate.. I tried on vb.com nobody was able to help me out..

Thanks a Ton!
Reply With Quote
Reply


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 01:43 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.03798 seconds
  • Memory Usage 2,191KB
  • 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)bbcode_code
  • (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