Support » Plugins and Hacks » Database Error Popularity Contest

  • Boris

    (@travel-junkie)


    Hello,

    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!
    Cheers, Boris

  • The topic ‘Database Error Popularity Contest’ is closed to new replies.