PDA

View Full Version : very big database problem....

Ohiosweetheart
02-09-2006, 04:06 PM
A week or so ago, my database started going down, giving us an error concerning the ibPro arcade. So I uninstalled it and reinstalled it, and the database crashed before I even enabled the arcade. So, I uninstalled it again. We ran maintenance, optimized tables, ran a database repair from my servers control panel.

Now we don't have an arcade, but my site keeps going down 2, 3 sometimes 4 times a day. Always a database error. I've contacted my host about it, he says it's not the server, but rather a problem within vBulletin database. I asked if I should uninstall vB and do a fresh install. He said that won't help because I'll be reinstalling the same problem.

At the moment he's reinstalling the mySQL server, but says he doesn't think it'll do any good, that the problem is within vBulletin.

Can anyone give me any advice on this? please??
Marco van Herwaarden
02-09-2006, 05:49 PM
It would really help if you posted the exact error you're getting.
Ohiosweetheart
02-09-2006, 07:00 PM
On the error page is just says "There seems to be a problem with the database. Please click on refresh and try again. An email has been sent to XXXXX"

When it happens again, and it won't be long now, I'll copy and paste it to here
thank you!
Marco van Herwaarden
02-09-2006, 07:02 PM
When it happens again, either post the content of the error email, or (still on the error page) right click on hte page, and select View Source, copy&paste the page source here.
Ohiosweetheart
02-09-2006, 07:03 PM
Here ya go:

<!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" />
<style type="text/css">
<!--
blockquote { margin-top: 75px; }
p { font: 11px tahoma, verdana, arial, sans-serif; }
-->
</style>
</head>
<body>
<blockquote>
<blockquote>
<p><strong>There seems to have been a problem with the database.</strong><br />
Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
<p>An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, whom you can also contact if the problem persists.</p>
<p>We apologise for any inconvenience.</p>


<!--
Database error in vBulletin :

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Too many connections
/home/exquisi/public_html/forums/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Thursday, February 9th 2006 @ 03:59:05 PM
Script : http://exquisitelyerotic.net/forums/index.php
Referrer : http://exquisitelyerotic.net/forums/portal.php
IP Address : 72.23.106.22
Username :
Classname : vB_Database
-->


</blockquote>
</blockquote>
</body>
</html>
Marco van Herwaarden
02-09-2006, 07:09 PM
mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Too many connections
/home/exquisi/public_html/forums/includes/class_core.php on line 279

That is your problem. This is a server problem (no matter what your host say) and means that there is a maximum number of connection in the MySQL configuration. Ask your host to raise the max connection limit.
Ohiosweetheart
02-09-2006, 07:14 PM
WONDERFUL!! I just sent your reply and the error to him and he understands now and said he'll fix it.

THANK YOU! *hugs*
Marco van Herwaarden
02-09-2006, 07:31 PM
Your welcome, glad to be able to help.
Reeve of shinra
02-09-2006, 08:01 PM
Interesting trick with the view source, I never knew that.