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.
This post is part of the thread: Content Presentation – an ongoing story on this site. View the thread timeline for more context on this post.
This post is part of the project: Popularity Contest. View the project timeline for more context on this post.
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.
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!!
I appreciate the dedication you have to your “babies” aka plugins. Thanks for the update, this stop-gap appears to be working great!
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!
[…] 在å‘作者åæ˜ äº† Popularity Contest 与 Google XML Sitemaps 3.0 ä¸å…¼å®¹çš„问题åŽï¼Œalexking 昨天放出了 Popularity Contest 1.3b2，ç»æ¼«æ¥æµ‹è¯•ï¼Œå·²ç»è§£å†³äº†å…¼å®¹æ€§é—®é¢˜ï¼Œå–œæ¬¢è¿™ä¸ªæ’件的朋å‹å¯ä»¥ä½¿ç”¨äº†ï¼Œå½“然我相信æ£å¼ç‰ˆä¹Ÿå¾ˆå¿«ä¼šå‡ºæ¥çš„，大家也å¯ä»¥é€‰æ‹©ç¨ç‰ä¸€æ®µæ—¶é—´ Popularity Contest 1.3b2 下载 […]
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
[…] Alex King acaba de publicar la segunda beta del plugin, que ya es compatible con Google […]
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
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.
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.
[…] 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 […]
another grateful user here with the same problem — only with akpc_most_popular_in_cat(), the rest of it’s fine.
[…] plugin το οποίο χÏησιμοποιοÏσα και εγώ στο webz είναι το Popularity Contest του Alex King. Το συγκεκÏιμÎνο plugin αντιμετώπισε Ï€Ïόβλημα […]
[…] 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. […]
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.
@Dane : great job there. Thanks!
[…] 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 […]
Cool. Thanks for the plugin. I’ll be installing it on my blog.
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.
[…] 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 […]
[…] is include a Top Recommended Articles on your sidebar. Another alternative is to install the plugin Popularity Contest which will rank your most popular […]
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.
[…] 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 […]
again the question is who is getting popular!!!!
[…] Popularity Contest – Note: Apparently, Popularity Contest plugin has not been updated for WP 2.5 and above yet. However, I have used it on a WP 2.6 site without any problems. If you have trouble activating it, there is a fix for it posted here. Your Most Popular Posts will appear at the top of the right sidebar in the tabbed navigation box as seen on this site. […]
[…] 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. […]
thanks for this great plugin
cool plugin, thanks for sharing
[…] Popularity Contest – Note: Apparently, Popularity Contest plugin has not been updated for WP 2.5 and above yet. However, I have used it on a WP 2.6 site without any problems. If you have trouble activating it, there is a fix for it posted here. Your Most Popular Posts will appear at the top of the right sidebar in the tabbed navigation box as seen on this site. […]
[…] Popularity Contest – Note: Apparently, Popularity Contest plugin has not been updated for WP 2.5 and above yet. However, I have used it on a WP 2.6 site without any problems. If you have trouble activating it, there is a fix for it posted here. Your Most Popular Posts will appear at the top of the right sidebar in the tabbed navigation box as seen on this site. […]
[…] Popularity Contest – Note: Apparently, Popularity Contest plugin has not been updated for WP 2.5 and above yet. However, I have used it on a WP 2.6 site without any problems. If you have trouble activating it, there is a fix for it posted here. Your Most Popular Posts will appear at the top of the right sidebar in the tabbed navigation box as seen on this site. […]
I run several WP-blogs. Most of them are in german. The german blogging communitz is a kind of strange so I try to avoid them.
I am glad to find sites like this and have in general the feeling that the WP-Community in english is much more helpful than the german one and of course offers a bigger veriety in themes and plugins.
Therefore I am happy to spend some hours to adjust the themes to german.
to all out there who are sharing their knowlegde and Ideas.. Thank you a lot