vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=257576

Getting Database Error..!!
by Naan-Kadavul
22 Jan 2011 06:07

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 22 Jan 2011 06:11

Next time it happens view page source to get the actual full error.

Naan-Kadavul 22 Jan 2011 06:15

Okay buddy..Sure I will get it .. by Today..!!

--------------- Added 22 Jan 2011 at 06:21 ---------------

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

Quote:

<!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:[email protected]">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\includes\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/new...ly&amp;t=32947
Referrer : http://www.moviejockey.com/forum/sho...d.php?p=103932
IP Address : 218.186.XX.XXX
Username :
Classname : vB_Database
MySQL Version :
-->
</body>
</html>
--------------- Added 22 Jan 2011 at 06:23 ---------------

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 22 Jan 2011 06:27

It is a server issue. Too many database connections.

Naan-Kadavul 22 Jan 2011 06:30

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 22 Jan 2011 at 06:31 ---------------

Server OS : Windows 2003

--------------- Added 22 Jan 2011 at 06:57 ---------------

Please tell me in Brief !

WEBDosser 22 Jan 2011 07:13

Quote:

If I make the max number of connections to a high number will the problem solve ?
should work yes

Naan-Kadavul 22 Jan 2011 07:18

Thanks for the reply WEBDosser.. I will do and check. If it works I will be really happy :)
Thanks once again :)

--------------- Added 22 Jan 2011 at 12:14 ---------------

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

This is line 311
Quote:

$link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);
--------------- Added 22 Jan 2011 at 13:15 ---------------

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


All times are GMT. The time now is 06:41.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.