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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-13-2009, 12:15 PM
meissenation meissenation is offline
 
Join Date: Apr 2005
Posts: 476
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL server has gone away

Hey guys,

I'm getting repeated MySQL errors all of the sudden and I don't know what changed that's causing it.


This one is the most popular and will occur about 5-6 times a day:
Quote:
Database error in vBulletin :

mysql_connect(): MySQL server has gone away
...\vbulletin\includes\class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Tuesday, October 13th 2009 @ 11:15:34 AM
Error Date : Tuesday, October 13th 2009 @ 11:15:44 AM
Script : http://www.mifbody.com/vbulletin/pic...id=245&thumb=1
Referrer : http://www.mifbody.com/vbulletin/
IP Address : 12.152.193.133
Username :
Classname : vB_Database
MySQL Version :

This one happens every now and then:
Quote:
Database error in vBulletin :

mysql_connect(): [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306)
...\vbulletin\includes\class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Tuesday, October 13th 2009 @ 01:10:17 AM
Error Date : Tuesday, October 13th 2009 @ 01:11:17 AM
Script : http://www.mifbody.com/vbulletin/cro...and=1255396215
Referrer : http://www.mifbody.com/vbulletin/index.php
IP Address : 99.18.26.229
Username :
Classname : vB_Database
MySQL Version :
This one happens occasionally too:
Quote:
Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT user.userid, user.options, user.username,
user.usergroupid, user.displaygroupid, whoread.dateline, whoread.ipaddress
FROM whoread as whoread
LEFT JOIN user as user USING (userid)
WHERE whoread.threadid = 29169
AND whoread.dateline > 0 ORDER BY username;

MySQL Error : Out of memory (Needed 1372840 bytes)
Error Number : 5
Request Date : Monday, October 12th 2009 @ 06:06:47 AM
Error Date : Monday, October 12th 2009 @ 06:06:48 AM
Script : http://www.mifbody.com/vbulletin/showthread.php?t=29169
Referrer :
IP Address : 65.55.4.171
Username : Unregistered
Classname : vB_Database
MySQL Version :
The first one - MySQL has gone away - is the more prevalent of the errors. Every time I get an error, though, it's always for class_core.php on line 311. Is a timeout that I have set too short or is there a firewall issue or what?

vBulletin 3.8.4
Windows Server 2003 SP2


It always occurs for people who are not logged in.
Reply With Quote
 


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 11:27 PM.


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.03709 seconds
  • Memory Usage 2,321KB
  • Queries Executed 12 (?)
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
  • (3)bbcode_quote
  • (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)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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