vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Getting Database Error..!! (https://vborg.vbsupport.ru/showthread.php?t=257576)

Naan-Kadavul 01-22-2011 05:07 AM
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.

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 [DATE]1295680908[/DATE] at [TIME]1295680908[/TIME] ---------------

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: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/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 [DATE]1295681003[/DATE] at [TIME]1295681003[/TIME] ---------------

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 [DATE]1295681502[/DATE] at [TIME]1295681502[/TIME] ---------------

Server OS : Windows 2003

--------------- Added [DATE]1295683028[/DATE] at [TIME]1295683028[/TIME] ---------------

Please tell me in Brief !

WEBDosser 01-22-2011 06:13 AM
Quote:
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 [DATE]1295702056[/DATE] at [TIME]1295702056[/TIME] ---------------

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

This is line 311
Quote:
$link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);
--------------- Added [DATE]1295705708[/DATE] at [TIME]1295705708[/TIME] ---------------

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


All times are GMT. The time now is 07:10 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01136 seconds
  • Memory Usage 1,736KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete