Crawl Rate Tracker and Wordpress 2.5 Manual Fix

Home
Contact

Submitted by Kieran on Tuesday, 22 April 20086 Comments

A quick update on people that need the Crawl Rate Tracker to work with Wordpress 2.5 – just create the table manually.

I used phpMyAdmin to manually create the table in the required blog databases.
If you are planning on doing this, make sure you add you table_prefix if required. Double check what $table_prefix is set to in wp-config.php. Chances are it is “wp_” and you don’t need to change the code below.

CREATE TABLE `wp_sbtracking` (
`id` INT NOT NULL AUTO_INCREMENT ,
`robot_name` VARCHAR( 100 ) NOT NULL ,
`page_url` VARCHAR( 250 ) NOT NULL ,
`visit_time` INT NOT NULL ,
PRIMARY KEY ( `id` )
);

Simple fix.

Perhaps I might bodge together a working version of sbtracking-setup.php some time soon.

6 Comments »

Wordpress 2.5 & Crawl Rate Tracker Plugin Screws Site SERPS - Hobo SEO UK said:

[...] Update – There is now a fix, apparently at Bloke. [...]

- 24 April 2008 at 15:39

почти 2250 блогов пострадали при переходе на wordpress 2.5 | wpbox.ru said:

[...] вручную создать таблицу в БД, как показано тут [...]

- 30 April 2008 at 02:33

Blogissimo - Blogger bloggen in Blogs » wp_sbtracking’ doesn’t exist - WP 2.5 vs. Crawl Rate Tracker Plugin said:

[...] Über folgenden Link gibt es eine Lösung um das Problem zu fixen bloke.org [...]

- 30 April 2008 at 09:48

http://remont-komplekt.ru/ said:

- 5 July 2008 at 19:51

Extra Cover Cricket | kieran barnes | kieranbarnes said:

[...] Crawl Rate Tracker (My 2.5 fix) [...]

- 1 October 2008 at 16:57

Виктор said:

Если не секрет, автор откуда родом?

- 30 May 2009 at 13:25

Leave your response!

Apache »

Block Countries in Apache

Assuming you have mod_geoip installed in apache we can block certain countries in 6 lines of code.
I had a client who was experiencing an inhumane amount of spam on their phpBB forums, which are notorious …

More articles »

CubeCart »

Using Wordpress header and footers externally

I needed to integrate a Wordpress header (header.php) and footer (footer.php) into an external application.
There are quite a few ways round this, but none are really ideal. For example, if you want to include an …

More articles »

HTML, CSS, AJAX »

Ajaxrain.com hits 1,000 entries mile stone

Back in August last year I posted about a new resource called Ajax Rain that lists Ajax/Javascript/Dhtml examples and demos. Well, now they’ve hit over 1,000 entries.
Sites like this come and go all the time, …

More articles »

PHP »

Convert phpBB IP Addresses

phpBB stores its IP addresses in a funky format. They’re useless to the human eye!
Convert them to normal IPs with the following code

SELECT CONCAT( CONV( substring( poster_ip, 1, 2 ) , 16, 10 ) , …

More articles »

Wordpress »

Facebook Chat for Pidgin

My favourite instant messenger application just got better! There is now a plugin for Facebook.
pidgin-facebookchat is a Facebook chat plugin for Pidgin and other libpurple based messengers. It connects to the new Facebook Chat IM …

More articles »