vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
vBSEO Total Support Team Launches DeskPro New vBSEO Discount Level for Network Builders vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

Database Errors since we installed vbSEO - what have we done wrong?

This is a discussion on Database Errors since we installed vbSEO - what have we done wrong? within the Troubleshooting forums, part of the vBSEO SEO Plugin category; It happens frequently and at various times, but only since installing vbseo . Does anyone have any idea what we've ...

Go Back   vBulletin SEO Forums > vBSEO SEO Plugin > Troubleshooting

Database Errors since we installed vbSEO - what have we done wrong? Database Errors since we installed vbSEO - what have we done wrong?

Enhancing 80 million pages.

 Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Reply
Page 1 of 2 1 2

 

LinkBack Thread Tools
  #1  
Old 09-09-2008, 06:28 AM
Junior Member
  
Real Name: Sean Spurr
Join Date: Jul 2008
Posts: 9
Database Errors since we installed vbSEO - what have we done wrong?
It happens frequently and at various times, but only since installing vbseo.

Does anyone have any idea what we've done wrong?

This is thread where users are complaining about it:

Database error here - Literature Forums at Literature Junction
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #2  
Old 09-09-2008, 08:47 AM
Mert Gökçeimam's Avatar
vBSEO.com Webmaster
vBSEO Total Customer SupportvBulletin HackerBig Board Administrator
  
Real Name: Lizard King
Join Date: Oct 2005
Location: Istanbul
Posts: 8,372
Blog Entries: 1
Send a message via MSN to Mert Gökçeimam
Hello Sean ,

What is the content of the database error ?

You can check page source for the details of database error.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #3  
Old 09-09-2008, 10:29 AM
Junior Member
  
Real Name: Sean Spurr
Join Date: Jul 2008
Posts: 9
I've asked my forum members to save a copy of the error message next time they see it, when I have a copy I'll post it.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #4  
Old 09-09-2008, 10:33 AM
Junior Member
  
Real Name: Sean Spurr
Join Date: Jul 2008
Posts: 9
Got one myself just now!

Quote:
Database error The database has encountered a problem. Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.literaturejunction.com home page, then try to open another page.
  • Click the Back button to try another link.
The Database Error forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #5  
Old 09-09-2008, 10:35 AM
Junior Member
  
Real Name: Sean Spurr
Join Date: Jul 2008
Posts: 9
To give some context WHM says load on this account (for MySQL) is currently 39.4. I've no idea what that means but it's way way higher than any other account.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #6  
Old 09-09-2008, 10:54 AM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
  
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,277
Please "View Source" on that error page to get the detailed mySQL Error.
__________________
Keith Cohen / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #7  
Old 09-09-2008, 01:27 PM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
  
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 5,780
if its ayhoo slurp giveing you hell, add a crawl-delay to your robots file.

they were sending 500+ bots to me at one point. i had to tame them down
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #8  
Old 09-09-2008, 06:16 PM
Junior Member
  
Real Name: Sean Spurr
Join Date: Jul 2008
Posts: 9
Code:
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	********* Database Error</title>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
	<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="#" *******="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">www.literaturejunction.com</a> home page, then try to open another page.</li>
			<li>Click the <a href="**********:history.back(1)">Back</a> button to try another link.</li>

		</ul>
	</td>
</tr>
<tr>
	<td class="bodytext" colspan="2">The www.literaturejunction.com forum technical staff have been notified of the error, though you may <a href="mailto:literatureforums@incka.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 :

mysqli_real_connect() [&lt;a href='function.mysqli-real-connect'&gt;function.mysqli-real-connect&lt;/a&gt;]: (08004/1040): Too many connections
/home/litjun/public_html/includes/class_core.php on line 1040

MySQL Error  : 
Error Number : 
Date         : Tuesday, September 9th 2008 @ 04:04:37 PM
Script       : http://www.literaturejunction.com/sh...251&amp;page=2
Referrer     : http://www.literaturejunction.com/introduce-yourself/
IP Address   : 128.6.30.198
Username     : 
Classname    : vB_Database_MySQLi
-->


</body>
</html>
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #9  
Old 09-09-2008, 06:18 PM
Junior Member
  
Real Name: Sean Spurr
Join Date: Jul 2008
Posts: 9
How can you tell if its yahoo slurp? I expected it could be cuil but have searched for cool's IPs in todays raw access logs and they aren't present.

I only use google analytics for stats, does that contain a robots section, I couldn't find one.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #10  
Old 09-09-2008, 06:18 PM
Ace Shattock's Avatar
vBSEO Staff
vBSEO Total Customer SupportCommunity Builder
  
Real Name: Ace Shattock
Join Date: Jul 2005
Location: New Zealand
Posts: 2,960
That would be a 'too many connections' error.

You'll need to ask your host/server admin to increase this value.
__________________
Ace Shattock / Crawlability Inc.
Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service

vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: New Zealand Forum | vBulletin Modifications and Styles | vBulletin Hosting
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #11  
Old 09-09-2008, 06:55 PM
Junior Member
  
Real Name: Sean Spurr
Join Date: Jul 2008
Posts: 9
As it's a dedicated server I am the server admin.

How do I do this. It's a WHM/Apache server.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #12  
Old 09-09-2008, 07:13 PM
Junior Member
  
Real Name: Sean Spurr
Join Date: Jul 2008
Posts: 9
For anyone else reading: The way I did this was by SSH (search for Putty.exe and download). Then CD ../etc. Then pico my.cnf. Then change from 500 to 1500. Then CTRL+X then Y and Return. Close putty.exe

This may have found (I'm not sure yet) a fix to the problem, but it isn't in itself a solution as it hasn't dealt with what caused the large bursts of MySQL connections which I think were robots.

How can I find out if my site is coming under a lot of robot activity?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #13  
Old 09-09-2008, 07:28 PM
briansol's Avatar
Senior Member
vBSEO Pre-Release TeamDesign for SEOBig Board Administrator
  
Real Name: Brian
Join Date: Apr 2006
Location: Central CT, USA
Posts: 5,780
install a robots mod with the updated spiders list.

Spiders on ForumHome - vBulletin.org Forum

spiders_vbulletin.xml system 1.2



1500 may be too high for your box. keep that in mind. it depends on ram more than anything.

http://dev.mysql.com/doc/refman/5.0/...nnections.html

mysql ships default with 100.
most people don't go above 500.


I just glanced at your site, and you aren't 'THAT' active. Something is running/looping on your server, or your getting ddos'ed or something.

check your apache error and access logs to see if there's anything weird going on.


you may have another issue with threads (not vb threads, but sql threads) failing to close properly.

besides stock vb and vbseo, what else does your server run? (other sites, vb addons, etc). It could be a poorly written script on a another site causing issues.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #14  
Old 09-10-2008, 03:59 AM
Junior Member
  
Real Name: Sean Spurr
Join Date: Jul 2008
Posts: 9
My server runs literally hundreds of sites.

The main traffic one being an online games one but that only uses MySQL once per day to make the static pages of the site.

The next biggest load on MySQL comes from a lyrics site with no traffic I run. I thought this might be a robots issue too.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
  #15  
Old 09-10-2008, 07:46 AM
Junior Member
  
Real Name: Mondi
Join Date: Apr 2008
Posts: 5
I am encountering similar problem I am guessing...

Looking at the following code:

Quote:
Database error in vBulletin :
mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Access denied for user 'root'@'localhost' (using password: NO)
/home/gblcg.com/public_html/knowledge_share/upload/includes/class_core.php on line 311
Can anyone help pls?

Thanks.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on Facebook!
Reply With Quote
Reply
Page 1 of 2 1 2

« Problem with Links - Disappearing? | User sp!at and sp1at share the same profile »
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
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
just got vbseo and now database errors.. Likenota Troubleshooting 4 03-02-2008 07:40 PM
Database Error When trying to view threads with vbseo installed/enabled. Dave-M Troubleshooting 3 10-31-2007 03:11 PM
Database Errors majordude Off-Topic & Chit Chat 4 09-21-2006 10:28 PM
lotsa database errors on vbseo acers General Discussion 1 08-11-2005 11:40 PM


All times are GMT -4. The time now is 02:24 AM.

Contact Us - vBSEO Home - Site Map - Top

Powered by vBulletin Version 3.8.0 Release Candidate 2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.