Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2009, 04:50 AM
tafreeh tafreeh is offline
 
Join Date: May 2008
Location: Canada
Posts: 536
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vbulletin database error

i got few email today regarding vbulletin database error.

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

            UPDATE vb_datastore SET
                data = data - 218,
                data = IF(data < 0, 0, data)
            WHERE title = 'mailqueue';

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, September 7th 2009 @ 09:01:22 PM
Error Date    : Monday, September 7th 2009 @ 09:03:21 PM
Script        : http://www.tafreehmela.com/time-pass...-kar-ke-8.html
Referrer      : http://www.tafreehmela.com/time-pass/
IP Address    : *********
Username      : KAMRAN444
Classname     : vB_Database
MySQL Version
Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

            UPDATE vb_datastore SET
                data = data - 237,
                data = IF(data < 0, 0, data)
            WHERE title = 'mailqueue';

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, September 7th 2009 @ 09:01:19 PM
Error Date    : Monday, September 7th 2009 @ 09:03:17 PM
Script        : http://www.tafreehmela.com/time-pass...bove-u-17.html
Referrer      : http://www.tafreehmela.com/time-pass/
IP Address    : *********
Username      : KAMRAN444
Classname     : vB_Database
MySQL Version :
Reply With Quote
  #2  
Old 09-08-2009, 04:55 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is a server issue. See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway and this: http://www.vbulletin.com/forum/showt...265#post310265
Reply With Quote
  #3  
Old 09-09-2009, 11:24 PM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You didn't specify, but if you're on a shared server this is one of those errors you'll see from time to time. If it happens often, or if it doesn't clear up quickly, open a trouble ticket with your host - there's nothing else you can do.

But usually when I get them they've already cleared up by the time I can do anything.
Reply With Quote
  #4  
Old 09-12-2009, 08:23 PM
tafreeh tafreeh is offline
 
Join Date: May 2008
Location: Canada
Posts: 536
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i have my own dedi, and i fixed it... thanks for your help
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:10 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04152 seconds
  • Memory Usage 2,187KB
  • Queries Executed 11 (?)
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
  • (2)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_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