am running Alex Kings Popularity Contest(latest version 1.3b2) on my site and it works really good. Just noticed, though, that the function to display the most popular posts in a certain category throws a Database Error. Here it is:
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 = '1' AND tt.taxonomy = 'category' AND post_status = 'publish' AND post_type = 'post' AND post_date < NOW() GROUP BY wp_posts.ID ORDER BY pop.total DESC LIMIT 10
Any ideas on how to solve that error? All the other stuff the plugin is supposed to do works just fine!
- The topic ‘Database Error Popularity Contest’ is closed to new replies.