View Single Post
  #17  
Old 11-08-2010, 04:54 PM
Gamelobby's Avatar
Gamelobby Gamelobby is offline
 
Join Date: Jul 2007
Location: Long Beach, CA
Posts: 997
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have similar issues randomly once or twice a month.
I will keep an eye out for the source code next time it happens.



Quote:
Originally Posted by ehabfouad22 View Post
Thank you Paul,
I got this reply from my host:
"Dear Ehab,

I am sorry you are having issues with your website. The reason you are experiencing this error is because the limit of mysql connections is 10. There is no way to increase this limit, but the error is most likely caused by your connections not being closed. Ensure that your websites code is closing the database connections immediately after use. This will decrease the chance of this error occurring"

Now do you see that the value (10) is so low that it may cause this frequent error? If so, I would change my host to another one which provides a higher limit.
If you see that the value is sufficient, I would be grateful if you give me information on how to make sure that the forum codes is closing the database connections immediately after use.Thanks in advance!
Ehab
That would be GREAT information.!!




Quote:
Originally Posted by Lynne View Post
10?!?! Wow. I have heard of some hosts keeping it as low as 25, but never 10. Yes, that is low.

Try disabling your mods for a few days and see if you still have the same problem.
Which host only gives you 10.?




Thanks

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

I got the error again.. here is what it said.
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<title> Database Error</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
	<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
	<style type="text/css">
	<!--	
	body { background-color: white; color: black; }
	#container { width: 400px; }
	#message   { width: 400px; color: black; background-color: #FFFFCC; }
	#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
	.bodytext  { font: 8pt/11pt verdana, arial, sans-serif; }
	a:link     { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
	a:visited  { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
	-->
	</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
	<td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
	<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
	<td class="bodytext" colspan="2">The  database has encountered a problem.</td>
</tr>
<tr>
	<td colspan="2"><hr /></td>
</tr>
<tr>
	<td class="bodytext" colspan="2">
		Please try the following:
		<ul>
			<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
			<li>Open the <a href="/">www.gamelobby.com</a> home page, then try to open another page.</li>
			<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
		</ul>
	</td>
</tr>
<tr>
	<td class="bodytext" colspan="2">The www.gamelobby.com forum technical staff have been notified of the error, though you may <a href="mailto:Info@Gamelobby.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
	<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>
 
 
<!--
Database error in vBulletin :
 
mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Too many connections
/home/content/m/i/l/milo327/html/Forum/includes/class_core.php on line 311
 
MySQL Error   : 
Error Number  : 
Request Date  : Monday, November 8th 2010 @ 01:05:46 PM
Error Date    : Monday, November 8th 2010 @ 01:05:46 PM
Script        : http://www.gamelobby.com/Forum/cmps_index
Referrer      : http://www.gamelobby.com/
IP Address    : 108.13.48.18
Username      : 
Classname     : vB_Database
MySQL Version : 
-->
 
 
</body>
</html>
--------------- Added [DATE]1289254025[/DATE] at [TIME]1289254025[/TIME] ---------------

latest error code..

Code:
mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Too many connections
/home/content/m/i/l/milo327/html/Forum/includes/class_core.php on line 311
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01148 seconds
  • Memory Usage 1,793KB
  • 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
  • (2)bbcode_code
  • (2)bbcode_quote
  • (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