Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 02-09-2006, 04:06 PM
Ohiosweetheart Ohiosweetheart is offline
 
Join Date: Dec 2005
Location: N.E. Ohio
Posts: 2,291
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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??
Reply With Quote
  #2  
Old 02-09-2006, 05:49 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It would really help if you posted the exact error you're getting.
Reply With Quote
  #3  
Old 02-09-2006, 07:00 PM
Ohiosweetheart Ohiosweetheart is offline
 
Join Date: Dec 2005
Location: N.E. Ohio
Posts: 2,291
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
  #4  
Old 02-09-2006, 07:02 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 02-09-2006, 07:03 PM
Ohiosweetheart Ohiosweetheart is offline
 
Join Date: Dec 2005
Location: N.E. Ohio
Posts: 2,291
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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>
Reply With Quote
  #6  
Old 02-09-2006, 07:09 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 02-09-2006, 07:14 PM
Ohiosweetheart Ohiosweetheart is offline
 
Join Date: Dec 2005
Location: N.E. Ohio
Posts: 2,291
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

THANK YOU! *hugs*
Reply With Quote
  #8  
Old 02-09-2006, 07:31 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your welcome, glad to be able to help.
Reply With Quote
  #9  
Old 02-09-2006, 08:01 PM
Reeve of shinra's Avatar
Reeve of shinra Reeve of shinra is offline
 
Join Date: Oct 2001
Location: NYC
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Thread Tools
Display Modes

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

Forum Jump


All times are GMT. The time now is 12:44 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05136 seconds
  • Memory Usage 2,236KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_html
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete