vb.org Archive - very big database problem....

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - very big database problem.... (https://vborg.vbsupport.ru/showthread.php?t=107543)

very big database problem....

A week or so ago, my database started going down, giving us an error concerning the ibPro arcade. So I uninstalled it and reinstalled it, and the database crashed before I even enabled the arcade. So, I uninstalled it again. We ran maintenance, optimized tables, ran a database repair from my servers control panel.

Now we don't have an arcade, but my site keeps going down 2, 3 sometimes 4 times a day. Always a database error. I've contacted my host about it, he says it's not the server, but rather a problem within vBulletin database. I asked if I should uninstall vB and do a fresh install. He said that won't help because I'll be reinstalling the same problem.

At the moment he's reinstalling the mySQL server, but says he doesn't think it'll do any good, that the problem is within vBulletin.

Can anyone give me any advice on this? please??

It would really help if you posted the exact error you're getting.

On the error page is just says "There seems to be a problem with the database. Please click on refresh and try again. An email has been sent to XXXXX"

When it happens again, and it won't be long now, I'll copy and paste it to here
thank you!

When it happens again, either post the content of the error email, or (still on the error page) right click on hte page, and select View Source, copy&paste the page source here.

Here ya go:

HTML Code:

<!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" />

        <style type="text/css">

        <!--

        blockquote { margin-top: 75px; }

        p { font: 11px tahoma, verdana, arial, sans-serif; }

        -->

        </style>

</head>

<body>

        <blockquote>

                <blockquote>

                        <p><strong>There seems to have been a problem with the database.</strong><br />

                                Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>

                        <p>An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, whom you can also contact if the problem persists.</p>

                        <p>We apologise for any inconvenience.</p>

 

 

<!--

Database error in vBulletin :

 

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Too many connections

/home/exquisi/public_html/forums/includes/class_core.php on line 279

 

MySQL Error : 

Error Number : 

Date : Thursday, February 9th 2006 @ 03:59:05 PM

Script : http://exquisitelyerotic.net/forums/index.php

Referrer : http://exquisitelyerotic.net/forums/portal.php

IP Address : 72.23.106.22

Username : 

Classname : vB_Database

-->

 

 

                </blockquote>

        </blockquote>

</body>

</html>

Code:

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Too many connections

/home/exquisi/public_html/forums/includes/class_core.php on line 279

That is your problem. This is a server problem (no matter what your host say) and means that there is a maximum number of connection in the MySQL configuration. Ask your host to raise the max connection limit.

WONDERFUL!! I just sent your reply and the error to him and he understands now and said he'll fix it.

THANK YOU! *hugs*

Your welcome, glad to be able to help.

Interesting trick with the view source, I never knew that.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_html_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01149 seconds Memory Usage 1,733KB 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 (1)bbcode_code_printable (1)bbcode_html_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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
Messages: