vb.org Archive - Database error persistant since 3 years! Please help

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Database error persistant since 3 years! Please help (https://vborg.vbsupport.ru/showthread.php?t=253098)

Database error persistant since 3 years! Please help

Hi,
I have a frequent database error on my board.
I changed my host about a year ago to upgrade the php version which I thought it was the reason of this error, I contacted the current host so many times for this, I'm trying myself to optimize and repair my tables, and the server goes away every time I try this, I've failed to learn how to deal with mysql and ssh tools, and failed also to get benefit of the related posts here in vBulletin.org!
I'm ready to do whatever I have to for having a professional maintenance for my database, cause I'm totally desperate of doing this myself by using the available tools and references here in vBulletin :(
Any kind of help?

What is the db error?

If your error is a MySQL has gone away error, do you have your own server? Because if you don't have access to change server variables, then the only thing you can do is complain to the host.

Quote:

Originally Posted by Boofo (Post 2117591)

What is the db error?

hi,
The error experienced on loading forum pages is: The database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
Etc..

While fixing the issue via phpMyAdmin, the most common error I get is (The server cannot be found), i.e the page that appears when you have no internet connection.

Sometimes on optimizing or repairing (post) table in particular, an error appears (the server has gone away, no pma_comment is found on this database) and the error number is #2006.
Thanks, Boofo! :)

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

Quote:

Originally Posted by Lynne (Post 2117659)

If your error is a MySQL has gone away error, do you have your own server? Because if you don't have access to change server variables, then the only thing you can do is complain to the host.

Hi,
I have a web host. Not a server of my own. I did contact the host so many times for that, and the most recent reply I got was the following:
"Dear Ehab,
I am sorry to hear that you were experiencing issues with issues on your site. Although I unable to directly replicate any errors, I have scanned your site through the malware scanner and verified that the site is clean of any malware. I have also updated the custom php.ini file to your hosting package and configured your site to create its sessions on your hosting package?s my_root/tmp folder to allow it process your database queries more efficiently. "

The forum was working properly for few days after I received this message, and then I started to get the same database error once again.
Sorry for the long reply, and thanks in advance, Lynne :)

When you get the database error, view the page source for that page and you will see the actual database error near the bottom of that page. It will have some information like this:

Code:

The actual mysql query/code/problem....



MySQL Error : some sort of something here

Error Number : another something here

Date : Sunday, April 13th 2008 @ 11:16:43 AM

Script : http://address.path.path/page.php

Referrer :

IP Address : **.***.**.***

Username : username

Classname : database

That is the database error we need to see.

Quote:

Originally Posted by Lynne (Post 2117731)

When you get the database error, view the page source for that page and you will see the actual database error near the bottom of that page. It will have some information like this:

Code:

The actual mysql query/code/problem....



MySQL Error : some sort of something here

Error Number : another something here

Date : Sunday, April 13th 2008 @ 11:16:43 AM

Script : http://address.path.path/page.php

Referrer :

IP Address : **.***.**.***

Username : username

Classname : database

That is the database error we need to see.

Hi,
This is not the type of errors I meant. The error page you describe, with an internal window in it, was happening a long time ago on my board, and disappeared right after transfering host, and upgrading the php version from 4 to 5.

The error I'm currently experiencing reads as I described:
"The database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* contact the administrator of www.mysite.com
* Try to refresh the page.......etc."
without any additional infromation near the bottom of the error page, such as the table name, the I.P, etc.
I hope I made myself more clear.
Thanks Lynne!

You will have to view the source of the page to see the error then.

The error appears when I try to load the forum home page, and in other instances the homepage loads correctly, but the threads and subforums is showing the same error.
The text of the only error I get is exactly as follows:

"Database error
The database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.mysite.org home page, then try to open another page.
Click the Back button to try another link.

The www.mysite.org forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience."

And I apologize also for any inconvenience :) But I'm really fed up with that frequent error that may last for hours.
Thanks for your time, guys, and as I said I hope I can find an actual professional reliable solution to make my database tables work more effeciently.

When you get the page that says:
"Database error
The database has encountered a problem.

etc..."

Then view the page source and you will see what the actual error is. Follow my instructions in post 5.

Quote:

Originally Posted by Lynne (Post 2117968)

Hi Lynne,
I apologise for not understanding.
Here's the code I got:
<!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">

</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="/">mysite.org</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 mysite.org forum technical staff have been notified of the error, though you may <a href="mailto:webmaster@mysite.org">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2"> <br />We apologise for any inconvenience.</td>

</tr>



Thanks for your time, Lynne!
Regards

This error:

Code:

User [my_database_name] already has more than 'max_user_connections' active connections

is a server error and if you don't tell your host exactly what error you are getting, then they aren't going to know how to fix this one. It can show up intermittently and so they may never see it. If you've never given the host the exact error, then it's really no wonder that they have never fixed it for you.

The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by adding this to your config.php:

PHP Code:


		
			
$config['MasterServer']['usepconnect'] = 0;

But, if you still have the problem you will have to talk to your host about raising that limit. Also, see this Common MySQL Error Messages

Quote:

Originally Posted by Lynne (Post 2118082)

This error:

Code:

User [my_database_name] already has more than 'max_user_connections' active connections

PHP Code:


		
			
$config['MasterServer']['usepconnect'] = 0;

But, if you still have the problem you will have to talk to your host about raising that limit. Also, see this Common MySQL Error Messages

Thank you very much, Lynne! I appreciate it.
The code you provided ($config['MasterServer']['usepconnect'] = 0 ) is already there in my config.php
Can I raise the limit myself? or should I contact the host for raising it. Is there any recommended value of that limit?
Many thanks, guys! That was really helpful :)

No, you cannot raise it yourself. Contact your host.

Quote:

Originally Posted by Paul M (Post 2118709)

No, you cannot raise it yourself. Contact your host.

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

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.

Quote:

Originally Posted by Lynne (Post 2119099)

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.

Thank you, Lynne..
I've disabled the Chatbox mod for now, and I'm upgrading to a VPS hosting soon. I've been suffering for so long from the shared packages, and I think it's time to seek a little peace of mind. I hope this would be a solution.
Thanks a lot for your time, guys.
Sincerely, Ehab

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 (Post 2119074)

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 (Post 2119099)

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

Quote:

Originally Posted by Gamelobby (Post 2119547)

Which host only gives you 10.?

Network Solutions.

Heres one I get:

Code:

Database error in vBulletin 4.1.0:



Invalid SQL:

SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbenterprisetranslator_cache_medium help, vbenterprisetranslator_cache_medium cache WHERE help.originaltext='by+Aristotle+%0Ahttp%3A%2F%2Fwww.carpediem.im%2Fattachment.php%3Fattachmentid%3D49+%0ATranslation+by+W.+D.+Ross+%0A+%0ABook+I+%0ABook+II+%0ABook+III+%0ABook+IV+%0ABook+V+%0ABook+VI' AND help.tl='pt' AND cache.serie=help.serie;



MySQL Error   : MySQL server has gone away

Error Number  : 2006

Request Date  : Thursday, December 2nd 2010 @ 04:09:16 PM

Error Date    : Thursday, December 2nd 2010 @ 04:11:59 PM

Script        : http://www.carpediem.im/pt/showthread.php/1237-Nicomachean-Ethics-by-Aristotle?p=1664&viewfull=1

Referrer      :

IP Address    : 119.63.198.95

Username      : Unregistered

Classname     : vB_Database

MySQL Version :

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01376 seconds Memory Usage 1,832KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (2)bbcode_php_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (20)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: