While Popularity Contest version 1.3b1 was perfectly compatible with WordPress 2.3, it wasn’t compatible with the Google Sitemaps plugin. This version should be compatible with both. Thanks to Arne for his help identifying the compatibility issue between the two plugins.
I need to do a bit more to fix this more properly before it is ready for final release, but this version should be a suitable stop-gap until then.
The download and more information are available on my WordPress Plugins page.
If you have any trouble with this, please leave a comment.
Popularity: 30% [?]
Jerry adds this Comment:
Thanks Alex. Had to deactivate Google Sitemaps because I thought it was making my site really slow. I will try and see what happens with this new version and google sitemaps.
October 2nd, 2007 at 7:20 pm
Mike Champion adds this Comment:
This appears to fix the problem — I’m able to activate both the Sitemaps plugin and PopContest at the same time and have comments work correctly (which wasn’t working in 1.3b1). Thanks!!
October 2nd, 2007 at 10:09 pm
Mark Penix adds this Comment:
I appreciate the dedication you have to your “babies” aka plugins. Thanks for the update, this stop-gap appears to be working great!
October 2nd, 2007 at 10:13 pm
Brian adds this Comment:
Alex - I was one of the ones reporting the problems related to issues with the google sitemaps plugin - in this new beta those problems appear to have been resolved - thanks!
October 2nd, 2007 at 10:18 pm
Popularity Contest 1.3b2 - 漫步 adds this Pingback:
[…] 在向作者反映了 Popularity Contest 与 Google XML Sitemaps 3.0 不兼容的问题后，alexking 昨天放出了 Popularity Contest 1.3b2，经漫步测试，已经解决了兼容性问题，喜欢这个插件的朋友可以使用了，当然我相信正式版也很快会出来的，大家也可以选择稍等一段时间 Popularity Contest 1.3b2 下载 […]
October 2nd, 2007 at 11:14 pm
mooiness adds this Comment:
Hi Alex.
First of all thanks for this great plugin!
Wrt to WP2.3, I’m seeing this problem when I try to do a akpc_most_popular_in_cat() (strange one, the DB table does exist):
WordPress database error: [Unknown table ‘wp_posts’ in group statement]
SELECT ID, post_title FROM wp_posts p LEFT JOIN wp_term_relationships tr ON p.ID = tr.object_id LEFT JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN wp_ak_popularity pop ON p.ID = pop.post_id WHERE tt.term_id = ‘4′ AND tt.taxonomy = ‘category’ AND post_status = ‘publish’ AND post_type = ‘post’ AND post_date
October 2nd, 2007 at 11:27 pm
Alex King publica Popularity Contest 1.3b1 | La brujula verde adds this Pingback:
[…] Alex King acaba de publicar la segunda beta del plugin, que ya es compatible con Google […]
October 3rd, 2007 at 2:25 am
roam adds this Comment:
akpc_most_popular_in_cat() this function hava some problem
error info:
WordPress database error: [Unknown column ‘wp_posts.ID’ in ‘group statement’]
SELECT ID, post_title FROM wp_posts p LEFT JOIN wp_term_relationships tr ON p.ID = tr.object_id LEFT JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN wp_ak_popularity pop ON p.ID = pop.post_id WHERE tt.term_id = ‘3′ AND tt.taxonomy = ‘category’ AND post_status = ‘publish’ AND post_type = ‘post’ AND post_date
October 3rd, 2007 at 3:14 am
R. Apichart adds this Comment:
First I would like to tell you that I’m very new to wordpress. I’ve found your blog on my own blog after installed scripts. And after looked around your blog I’m so wonder that their are many thing I never known before especially wordpress plugins. Thanks a lot Alex, I think I have to learn more from your blog.
Thanks and appreciate.
October 3rd, 2007 at 7:24 am
Mark Barnes adds this Comment:
Yes, this works for me now. I love the plugin, but there is one thing missing, which I wonder if you could add - CRON support. As you know, that’s been available in WP since 2.2, and this plug-in desperately needs it to clear out the spam comment counts from the database. If this could happen every 24 hours or so, I’d be a very happy man.
October 3rd, 2007 at 1:03 pm
Dale al teclado » Subsanado el problema de incompatibilidad de los plugins “Google Sitemaps Generator” y “Popularity Contest” adds this Pingback:
[…] ha salido la versión beta 1.3b2 del Polularity Contest que resuelve perfectamente este problema. Ahora, salvo que no me saca bien los artículos más […]
October 3rd, 2007 at 2:12 pm
p m adds this Comment:
another grateful user here with the same problem — only with akpc_most_popular_in_cat(), the rest of it’s fine.
October 4th, 2007 at 2:36 am
Δημοφιλή θέματα με το Popularity Contest Plugin | Webz adds this Pingback:
[…] plugin το οποίο χρησιμοποιούσα και εγώ στο webz είναι το Popularity Contest του Alex King. Το συγκεκριμένο plugin αντιμετώπισε πρόβλημα […]
October 6th, 2007 at 8:27 am
A Division by Zer0 » Blog Archive » Pluginess Updateness Goodness adds this Pingback:
[…] Popularity Contest actually now works with WP2.3 and it also seems to cooperate nicely with wp-cache as well, something that in the previous version required a modified version. Unfortunately for some reason my most popular posts per category still do not seem to work so I’ll need to investigate this eventually. […]
October 10th, 2007 at 10:02 am
Dane Morgan adds this Comment:
For the akpc_most_popular_in_cat() problem I have found a solution. I’m guessing it’s a MySQL version issue.
Throughout the plugin code there are queries similar to:
$posts = mysql_query(”
SELECT p.ID
FROM $wpdb->posts p
LEFT JOIN $wpdb->ak_popularity pop
ON p.ID = pop.post_id
By deleting the ‘p’ from each occurance of ‘$wpdb->posts p’
and changing each occurance of ‘p.COLUMN_ID’ to ‘$wpdb->posts.COLUMN_ID’
I was able to get the most popular by category function to work. Everything else seems to continue working as well.
I have this working now on my blog.
October 21st, 2007 at 9:59 pm
mooiness adds this Comment:
@Dane : great job there. Thanks!
October 27th, 2007 at 6:50 am
Popularity Contest: Temp Fix Download For Popular In Category Feature adds this Pingback:
[…] KB Powered by Drain Hole Alex King’s Popularity Contest Plugin has a feature that lets you display the most popular posts in a given category. Unfortunately this […]
October 30th, 2007 at 4:40 am
Lina Swanson adds this Comment:
Cool. Thanks for the plugin. I’ll be installing it on my blog.
November 11th, 2007 at 9:28 pm
King Rat adds this Comment:
Not sure if this is intended or not, but on the popularity rankings page under 2.3, tags are showing up as categories where the average popularity per category is shown. Some folks may like that, but if you have a lot of tags that could get unwieldy.
November 15th, 2007 at 10:12 am
WP Plugin: Turning ‘Popularity Contest’ into a Widget adds this Pingback:
[…] popular WP plugin is Popularity Contest by Alex King. The plugin allows the admin to show the most popular pages over a certain period of […]
December 10th, 2007 at 5:54 am
5 Things to Consider Before Promoting Your Blog adds this Pingback:
[…] is include a Top Recommended Articles on your sidebar. Another alternative is to install the plugin Popularity Contest which will rank your most popular […]
December 17th, 2007 at 9:51 pm
mats adds this Comment:
Hi Guys. Here’s a patched version that I’ve found when searching:
http://www.kenmc.com[...]ntest-notes/
It probably work if you just upload and activate it.
If not, there are MySQL info there that you add thru php myadmin. If you need a free MySQL client here’s SQL Front http://www.sql-front[...]ownload.html
Good luck,
Mats.
April 10th, 2008 at 2:21 pm
How to Install and Set Up WP-Magazine Theme 1.0 : Premium WordPress Magazine Theme adds this Pingback:
[…] For the popular posts and most comments posts to function, you’ll need 2 plugins; Alex Kings Popularity Contest (Popularity Contest plugin has not been updated for WP 2.5 and above yet. There is a fix for it […]
May 5th, 2008 at 10:37 am