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"> <br />We apologise for any inconvenience.</td>
</tr>
</table>
<!--
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: 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&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...!!
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.