Crawl Rate Tracker Fix for WordPress 2.5

It looks like WordPress 2.5 and Patrick Altoft's Crawl Rate Tracker aren't 100% compatible. Patrick knows about the problem, but doesn't really provide detailed instructions on how to fix the problem. For those installing the plugin after upgrading to WordPress 2.5, I believe this database query will fix the problem.

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 )
);

Note: To get the correct table name for your blog, use the site: command in Google and look for an error along the lines of: Table 'yourblogname.wp_sbtracking' doesn't exist. That'll tell you the correct table name although I suspect wp_sbtracking is correct for most blogs.

Many thanks to Shaun who seems to have been the first to report the issue and Tim Nash who included the bug as part of his look at WordPress security issues.

• Tagging Partial RSS Feeds in WordPress
• Google Toolkit
• Converting to CSS Positioning
• Google Sandbox Check
• PageRank 0 to 7