Log in

View Full Version : Getting Database Error..!!


Naan-Kadavul
01-22-2011, 05:07 AM
I'm getting database error in my site. Recently it started. I don't know why. But its just happening.. No error code is coming. Its just coming as database error. Then I have to re-start my server once again and then start my site.

I have even uninstalled modifications, and only kept the following modifications :

1. Cyb Chatbox
2. XBT Mod
3. Auto-Resize Images
4. Auto-Tagger

But still I'm getting database errors, please kindly help me in this issue.

Thanks.

KevinL
01-22-2011, 05:11 AM
Next time it happens view page source to get the actual full error.

Naan-Kadavul
01-22-2011, 05:15 AM
Okay buddy..Sure I will get it .. by Today..!!

--------------- Added 1295680908 at 1295680908 ---------------

Ya I checked what you said... I am getting this in Source :


<!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.moviejockey.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.moviejockey.com forum technical staff have been notified of the error, though you may <a href="mailto:admin@moviejockey.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;]: User MJ_MovieJockEY already has more than 'max_user_connections' active connections
C:\Inetpub\vhosts\MovieJockey.com\httpdocs\forum\i ncludes\class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Saturday, January 22nd 2011 @ 12:20:32 AM
Error Date : Saturday, January 22nd 2011 @ 12:20:32 AM
Script : http://www.moviejockey.com/forum/newreply.php?do=postreply&amp;t=32947
Referrer : http://www.moviejockey.com/forum/showthread.php?p=103932
IP Address : 218.186.XX.XXX
Username :
Classname : vB_Database
MySQL Version :
-->
</body>
</html>


--------------- Added 1295681003 at 1295681003 ---------------

Is this Hosting (Server) Problem or Database Problem ? If database problem means, It could be fixed in the vBulletin Forum (adminCp) but if its a server problem then it should be solved in the server. So please let me know what should I do to prevent this coming up..

KevinL
01-22-2011, 05:27 AM
It is a server issue. Too many database connections.

Naan-Kadavul
01-22-2011, 05:30 AM
okay thanks a lot. That means no problem with vBulletin forum. Its a server issue.. meaning something to do with SQL.

Because I am using 8GB Ram, 64bit, 3TB Server. If I make the max number of connections to a high number will the problem solve ?

please let me know.. what u mean by too many database connections ?

--------------- Added 1295681502 at 1295681502 ---------------

Server OS : Windows 2003

--------------- Added 1295683028 at 1295683028 ---------------

Please tell me in Brief !

WEBDosser
01-22-2011, 06:13 AM
If I make the max number of connections to a high number will the problem solve ?

should work yes

Naan-Kadavul
01-22-2011, 06:18 AM
Thanks for the reply WEBDosser.. I will do and check. If it works I will be really happy :)
Thanks once again :)

--------------- Added 1295702056 at 1295702056 ---------------

C:\Inetpub\vhosts\MovieJockey.com\httpdocs\forum\i ncludes\class_core.php on line 311

This is line 311

$link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);


--------------- Added 1295705708 at 1295705708 ---------------

Please help me guys.. Still I'm getting Database ERRORS...!!