Board Optimization - FUZZY SEO Booster - increase long tail search traffic AUTOMATICALLY!

New Version: 13th October 2010 - fixes the following:
1) searches that contain backslashes no longer give a database error
2) statistics pages cleanued up, improved pagination for big boards
3) random "ghost" keywords like "0h" now solved.

What does this plugin do?

It automatically increases your search engine traffic for long tail queries, by embedding the actual search terms that people use to find your site in an auto-updating tag cloud on every page.

This is one of the plugins used by SEOforums.org - the #1 SEO forum in google!

Full description, screenshots and more about this plugin is available here

I have also released a brand-free (gold) version here


Installation:


1. Download plugin archive and unzip it. You will find in the zip file, a product XML and

an "upload" folder.


2. Login to yor vBulletin admin control panel.


3. Open "Plugins & Products", and go to "Manage Products".

Click on "[Add/Import Product]".


4. Import the XML file that came with this download. Make sure you choose "allow

overwrite" = yes.

5. Upload all content from folder "upload" to you forum root direcory.


USAGE LICENSE AGREEMENT:
You are welcome to use this plugin free of charge on condition that the link in the footer remains. You can remove that by purchasing the brand free version over at my site (the link is at the top of this description).

~VB Staff Comment:

Please note that this modification adds a link to one of three of the developers sites to the footer of each page.

[MOGmartin]

Originally Posted by AliMadkour

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT * FROM seoqueries_terms WHERE term_value='اكواد الكول تون لمصطفى كامل فودافون\';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''اكواد الكول تون لمصطفى كامل فودافون\'' at line 1
Error Number : 1064
Request Date : Thursday, March 4th 2010 @ 10:20:20 AM
Error Date : Thursday, March 4th 2010 @ 10:20:20 AM
Classname : vB_Database
MySQL Version : 5.1.30




!!!!
Got DB Error !!! when visitor from google !

FYI: Ive located the bug with this, the user is searching for a query that ends in a trailing slash (weird, and very unusual)

this is a circumstance I never considered, but a release tomorrow will cover that bug.

[MOGmartin]

Originally Posted by Gnoll

new updates looks cool i installed , if possible can ( or making ? )

* add as tag ( to topic )
* add as keyword ( to topic )
* do both

as the keywords are specific to a single thread in a lot of cases this wouldnt really work to be honest.

you would have to build a lot of logic to determine what tag it was meant to link to, then that tag page would get the SEO benefit.

I dont know about you, but Ive never seen tag pages pop up in the SERPs much.

[fogjuice]

I have the same problem and I just installed the update.

Database error in vBulletin 4.0.1:

Invalid SQL:
SELECT * FROM vB_seoqueries_terms WHERE term_value='innumerable stars science said 1 100\';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''innumerable stars science said 1 100\'' at line 1
Error Number : 1064
Request Date : Friday, March 5th 2010 @ 12:29:11 PM
Error Date : Friday, March 5th 2010 @ 12:29:11 PM
Script : http://atheistdiscussion.com/showthread.php?t=381
Referrer : http://www.google.ca/search?hl=en&sa...100%5C&spell=1
IP Address : ***
Username : ***
Classname : vB_Database
MySQL Version : 5.0.89-community

[MOGmartin]

Originally Posted by fogjuice

I have the same problem and I just installed the update.

does the search term you are clicking through from contain a slash?

[fogjuice]

Originally Posted by MOGmartin

does the search term you are clicking through from contain a slash?

yes. It seems you have not escaped the slashes properly.


Here is the search, http://www.google.ca/search?hl=en&sa...1,100\&spell=1

[MOGmartin]

yep, its a bug I was made aware of for the first time yesterday, I will release a patch upgrade by Monday mate.

thanks for flagging it though, I genuinely hadn't ever used a search term with a slash in it

[fogjuice]

Originally Posted by MOGmartin

yep, its a bug I was made aware of for the first time yesterday, I will release a patch upgrade by Monday mate.

thanks for flagging it though, I genuinely hadn't ever used a search term with a slash in it

Ok thanks, the sooner the better because its effecting any pages ppl search with a slash and I don't want to lose page position and have google replace them with db error pages. :\

[MOGmartin]

Originally Posted by fogjuice

Ok thanks, the sooner the better because its effecting any pages ppl search with a slash and I don't want to lose page position and have google replace them with db error pages. :\

there is no need to worry about that, because the page still exists fine, its just when it has a slash in the refferer url...

ie, googlebot will still load the page correctly, but I am re-releasing a fix on this ASAP!

thanks

MOGMartin

[Yellow Slider]

can you please give an example of this? is it the tag cloud over SEOFORUMS.ORG or what?
I don't see any "long tail phrases" in that tag cloud..

[MOGmartin]

Originally Posted by Yellow Slider

can you please give an example of this? is it the tag cloud over SEOFORUMS.ORG or what?
I don't see any "long tail phrases" in that tag cloud..

sure, check out the first link in the description to my blog post about it, there are examples, and snapshots of my organic traffic as well.