View Single Post
  #16  
Old 03-19-2013, 05:44 PM
Floyd R Turbo Floyd R Turbo is offline
 
Join Date: Sep 2012
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, I do occasionally get the 'server has gone away' error, and yesterday the site was down for a period of time.

Help me out here. What is a 'large join query' or 'order by'?

Also I still don't understand why this error keeps happening and flags a username that does not exist.

--------------- Added [DATE]1363715363[/DATE] at [TIME]1363715363[/TIME] ---------------

From yesterday, while the forum was down (like a server was unplugged!!)
Code:
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'turboforum.db.XXXXXXXXX.hostedresource.com' (0)
/home/content/XX/XXXXXXXXX/html/vb4/includes/class_core.php on line 317
another one from a few days ago

Code:
Database error in vBulletin 4.2.0:

Invalid SQL:
SHOW COLUMNS FROM user LIKE 'username';

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Friday, March 15th 2013 @ 10:54:49 PM
Error Date    : Friday, March 15th 2013 @ 10:54:49 PM
Script        : http://www.turbosaquatics.com/vb4//register.php?do=addmember
Referrer      : http://www.turbosaquatics.com/vb4//register.php?
IP Address    : 27.153.231.63
Username      : frierobia
Classname     : vB_Database
MySQL Version :
Again, a user that does not exist

Another that I have seen once or twice

Code:
Database error in vBulletin 4.2.0:

Invalid SQL:

			SELECT title, template
			FROM template
			WHERE templateid IN (14,78,79,67,51,60,0,20,80,81,109,4,3,576,605,566,567,569,575,574,402,403,404,405,158,159,406,411,407,408,409,412,413,414,415,416,467,469,471,473,475,522,521,524,525,528,529,771,941,947,580,578,581,583,582,584,585,586,587,588,589,590,595,592,594,591,593,604,606,607,616,598,609,610,611,612,614,577,603,608,617,613,619,618,615,695,1030,1040,981,1051,0,0,429,423,422,427,428,426,425,430,431,432,737,1033,683,687,684,685,686,1049,0,0,1012,1014,707,708,710,711,934,976,975,1025,977,534,533,537,85,361);

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Wednesday, March 13th 2013 @ 09:26:00 AM
Error Date    : Wednesday, March 13th 2013 @ 09:27:30 AM
Script        : http://www.turbosaquatics.com/vb4/member.php?7-halfmoon&tab=activitystream&type=friends&page=105
Referrer      : 
IP Address    : 66.249.74.210
Username      : Unregistered
Classname     : vB_Database
MySQL Version :
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01446 seconds
  • Memory Usage 1,770KB
  • 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
  • (3)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