Popularity Contest 1.3b3 fix for WordPress 2.5

Currently i have updated my WordPress installation to 2.5. I was using the Popularity Contest version 1.3b3 plugin by AlexKing and i didn’t want to accept the idea that it isn’t WP 2.5 ready. So i did a little research and found out that i’m not the only one who has this problem. If you don’t want to wait until the author decides to post the new version because this plugin is crucial for your blog you can check out this quick fix.

• Deactivate the plugin.
• Navigate to the plugin’s directory and open popularity-contest.php
• Scroll down to line 59 and replace the line require(’../../wp-blog-header.php’); with require(’../wp-blog-header.php’);
• Reactivate the plugin.

Thank you Thomas for this wonderful solution.

The above fix works if you had the plugin up and running before you upgraded to WP 2.5, however if you want to install the plugin directly on WP 2.5 you have to execute this SQL query before. Basically you do a manual installation.

CREATE TABLE `wp_ak_popularity_options`
			(
				`option_name` VARCHAR( 50 ) NOT NULL
				, `option_value` VARCHAR( 50 ) NOT NULL
			)

After that execute this query:

CREATE TABLE `wp_ak_popularity`
			(
				`post_id` INT( 11 ) NOT NULL 
				, `total` INT( 11 ) NOT NULL 
				, `feed_views` INT( 11 ) NOT NULL 
				, `home_views` INT( 11 ) NOT NULL 
				, `archive_views` INT( 11 ) NOT NULL 
				, `category_views` INT( 11 ) NOT NULL 
				, `single_views` INT( 11 ) NOT NULL 
				, `comments` INT( 11 ) NOT NULL 
				, `pingbacks` INT( 11 ) NOT NULL 
				, `trackbacks` INT( 11 ) NOT NULL 
				, `last_modified` DATETIME NOT NULL
				, KEY `post_id` ( `post_id` )
			)

And in the end this one:

INSERT 
				INTO wp_ak_popularity_options
				VALUES
				(
					'$option'
					, '$temp'
				)

Now you can run Popularity contest 1.3b3 on WordPress 2.5 !