Database Error Popularity Contest (1 post)

  1. Boris
    Posted 8 years ago #


    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

Topic Closed

This topic has been closed to new replies.

About this Topic