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.

[KissOfDeath]

Originally Posted by bongwater

I viewed a cached version of your site on google and it shows you are running 4.0 not 4.0.1 so perhaps that may be the cause of the problem

No i'm defiantly running the latest version, check the cached version of www.devils-shadow.com/forums/content/

[bongwater]

Try FTP'ing the contents of the includes folder that came with the latest version of vb. In particular, copy and overwrite the /includes/init.php file and restore to the original and see if that works

[KissOfDeath]

Originally Posted by bongwater

Try FTP'ing the contents of the includes folder that came with the latest version of vb. In particular, copy and overwrite the /includes/init.php file and restore to the original and see if that works

thats the first thing i tried, the only way i can think of fixing it now is to create a new forum on a different database, the switch the template database with my existing one

[bongwater]

Originally Posted by KissOfDeath

thats the first thing i tried, the only way i can think of fixing it now is to create a new forum on a different database, the switch the template database with my existing one

Try globally disabling all your plugins in your includes/config.php file by adding the line

define('DISABLE_HOOKS', true)

and see if that gives you admincp access

[KissOfDeath]

Originally Posted by bongwater

Try globally disabling all your plugins in your includes/config.php file by adding the line

define('DISABLE_HOOKS', true)

and see if that gives you admincp access

That gives me:

Parse error: syntax error, unexpected $end in /home/wwwdevi/public_html/forums/includes/config.php on line 193

I'm getting sql error emails aswell:

Database error in vBulletin 4.0.1:

Invalid SQL:

                                               SELECT
                                                       st.*, sd.founded
                                               FROM
                                                       seoqueries_data sd
                                               LEFT JOIN
                                                       seoqueries_terms st
                                                       ON
                                                       sd.stid = st.stid
                                               WHERE
                                                       sd.page_type = 'index'
                                                       AND
                                                       sd.page_id = 0
                                               ORDER BY
                                                       sd.founded DESC LIMIT 25;

MySQL Error   : Table 'wwwdevi_*********.seoqueries_data' doesn't exist
Error Number  : 1146

[kall]

Originally Posted by KissOfDeath

That gives me:

Parse error: syntax error, unexpected $end in /home/wwwdevi/public_html/forums/includes/config.php on line 193

What are you using to edit the php files?

Did you install the Product xml?

[bongwater]

I am not a coder or the author of this plugin, and I doubt that your database files were corrupted. Problem appears to be changes to your config files that are causing this. If you can isolate those config files and try restoring them (to the version before you added this plugin), you'll be in the right direction without having to do a full restore from backup

[KissOfDeath]

Originally Posted by kall

What are you using to edit the php files?

Did you install the Product xml?

i'm using notepad, have always used notepad and never had any problems.....

my site when down the second i installed the product xml, it said it was done for all styles, then when the page refreshed i got the error

[KissOfDeath]

Originally Posted by bongwater

I am not a coder or the author of this plugin, and I doubt that your database files were corrupted. Problem appears to be changes to your config files that are causing this. If you can isolate those config files and try restoring them (to the version before you added this plugin), you'll be in the right direction without having to do a full restore from backup

I don't think it's modified any of the files stored on my server, it's modified a global template, and without access to the admin cp i don't think i can revert the styles or uninstall the plugin

[kall]

Originally Posted by KissOfDeath

i'm using notepad, have always used notepad and never had any problems.....

my site when down the second i installed the product xml, it said it was done for all styles, then when the page refreshed i got the error

Notepad for the win. If you had said wordpad or word, that would have explained the errors.

Sorry I can't be of any help.