Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 22 Jan 2011, 06:07
Naan-Kadavul's Avatar
Naan-Kadavul Naan-Kadavul is offline
 
Join Date: Sep 2009
Location: Singpore
Real name: Bharath
Unhappy Getting Database Error..!!

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.
__________________
Team MJY - MovieJockey Entertainment Network (Click Here)
Site Founded : 11 September 2009 / Re-Launched : 01 January 2010
Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.

Reply With Quote
  #2  
Old 22 Jan 2011, 06:11
KevinL KevinL is offline
 
Join Date: Apr 2005
Next time it happens view page source to get the actual full error.
Reply With Quote
  #3  
Old 22 Jan 2011, 06:15
Naan-Kadavul's Avatar
Naan-Kadavul Naan-Kadavul is offline
 
Join Date: Sep 2009
Location: Singpore
Real name: Bharath
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 :

<!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..
__________________
Team MJY - MovieJockey Entertainment Network (Click Here)
Site Founded : 11 September 2009 / Re-Launched : 01 January 2010
Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.


Last edited by Naan-Kadavul; 22 Jan 2011 at 06:26. Reason: Auto-Merged DoublePost
Reply With Quote
  #4  
Old 22 Jan 2011, 06:27
KevinL KevinL is offline
 
Join Date: Apr 2005
It is a server issue. Too many database connections.
Reply With Quote
  #5  
Old 22 Jan 2011, 06:30
Naan-Kadavul's Avatar
Naan-Kadavul Naan-Kadavul is offline
 
Join Date: Sep 2009
Location: Singpore
Real name: Bharath
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 !
__________________
Team MJY - MovieJockey Entertainment Network (Click Here)
Site Founded : 11 September 2009 / Re-Launched : 01 January 2010
Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.


Last edited by Naan-Kadavul; 22 Jan 2011 at 06:57. Reason: Auto-Merged DoublePost
Reply With Quote
  #6  
Old 22 Jan 2011, 07:13
WEBDosser's Avatar
WEBDosser WEBDosser is offline
 
Join Date: Oct 2001
If I make the max number of connections to a high number will the problem solve ?
should work yes
Reply With Quote
  #7  
Old 22 Jan 2011, 07:18
Naan-Kadavul's Avatar
Naan-Kadavul Naan-Kadavul is offline
 
Join Date: Sep 2009
Location: Singpore
Real name: Bharath
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
$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...!!
__________________
Team MJY - MovieJockey Entertainment Network (Click Here)
Site Founded : 11 September 2009 / Re-Launched : 01 January 2010
Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.


Last edited by Naan-Kadavul; 22 Jan 2011 at 13:15. Reason: Auto-Merged DoublePost
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 21:47.

Layout Options | Width: Wide Color: