PDA

View Full Version : Board Optimization - Send 503 error "Service Temporarily Unavailable" header on MySQL error! 3.6.x & prior


Milad
04-27-2008, 10:00 PM
Brought to you by Syrian Medical Society (http://www.syrianmeds.net/) & Milado (http://www.milado.net/)

Introduction & Description:
Sometimes, for a reason or another, MySQL server halts and vBulletin prints the MySQL error!

But Google will still index your pages even if they contain that error rather than the actual content!

What if that error lasts for many hours? many pages will get indexed during this breakdown, and will be replaced (if already indexed) with a no-content-but-a-MySQL-error page!

Here is a solution which will work for all vBulletin versions through the three generations (3.0 3.5 and 3.6)!

We will send a 503 error "Service Temporarily Unavailable" header, and Google will understand the message, and refrain from indexing your pages.

Installation for 3.7.x:
No need! this is already implemented (http://www.vbulletin.com/forum/showthread.php?t=230053) in 3.7.x generation!

Installation for 3.5.x and 3.6.x:
In includes/class_core.php find:

die($message);

Add before it the following:

header('HTTP/1.1 503 Service Temporarily Unavailable');
header('Status: 503 Service Temporarily Unavailable');
header('Retry-After: 3600');


Installation for (3.0.x):
In includes/db_mysql.php find:

echo "<html><head><title>$vboptions[bbtitle] Database Error</title>";

Add before it the following:

header('HTTP/1.1 503 Service Temporarily Unavailable');
header('Status: 503 Service Temporarily Unavailable');
header('Retry-After: 3600');


A comment:
It won't be simpler! no way to do this via plug-ins, as the MySQL error probably will prevent vBulletin from getting the plug-ins from the database!
To check how many database errors had been indexed by Google, use the following query:
site:syrianmeds.net "Database error"
replace syrianmeds.net with your site domain name!



Change log:
1.0.0 first public release, on April, 28 2008
Click install to receive support & updates.

You like it? nominate it.

KURTZ
04-28-2008, 10:31 AM
looks simple! :D

Milad
04-28-2008, 10:36 AM
looks simple! :D
But clever again! :D

Rickeo
04-28-2008, 11:11 AM
This is really genius actually simple but really handy installed and nominated :)

Rick

Hornstar
04-28-2008, 12:00 PM
Sounds like a Great SEO mod. Thanks.

testebr
04-28-2008, 12:22 PM
Milad,

Please read this http://www.vbulletin.com/forum/showthread.php?t=268710

Cya

Milad
04-28-2008, 01:32 PM
I already suggested this a while ago http://www.vbulletin.com/forum/showthread.php?t=230053

It had been implemented in 3.7

I'm happy!

Jasem
04-29-2008, 08:45 AM
Thank you very much

killerkraft
04-29-2008, 09:42 AM
Brilliant.

Thank you. :)

myown
05-09-2008, 02:20 PM
thanks for this sure will be installing soon.