WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] SQL error from Most Popular Categories by Posts plugin? (3 posts)

  1. CSSgirl
    Member
    Posted 6 years ago #

    I've just installed the Most Popular Categories by Posts plugin (http://bloghelper.is-there.net/plugins/wordpress/most-popular-categories-by-posts/) and I'm getting this error where it should be displayed:

    WordPress database error: [Table 'cssgirl_demos.jfx_post2cat' doesn't exist]
    SELECT p.ID, p.post_title, p.post_date, c.cat_ID, c.cat_name, p2c.post_id, p2c.category_id FROM (jfx_posts p LEFT JOIN jfx_post2cat p2c on p.ID = p2c.post_id) LEFT JOIN jfx_categories c ON p2c.category_id = c.cat_ID WHERE post_status = 'publish' AND p.post_date > DATE_ADD(CURDATE(), INTERVAL -7 DAY) ORDER BY p.post_date DESC

    I'm not SQL expert, can someone translate that for me and tell me how to fix? Is it as easy as just adding the table or do I need to do something else?

  2. Kafkaesqui

    Posted 6 years ago #

    http://wordpress.org/support/topic/135564

    That explains the problem. But in short, the plugin will need to be updated to work with 2.3.

  3. CSSgirl
    Member
    Posted 6 years ago #

    Ah thanks, I didn't realize that it was a compatibility issue, though it was something to do with my server! Hmm. Now to find something that does the same that is compatible.

    Thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic