Support » Plugin: Featured Products First for WooCommerce » No products displayed when enabled

  • Resolved lopri

    (@lopri)


    Hello. The plugin does not work, it does not display any products when enabled. With DEBUG enabled, I get the following database error:

    [Unknown column ‘wp_posts.ID’ in ‘order clause’]
    SELECT SQL_CALC_FOUND_ROWS wpsporthaus_posts.ID FROM wpsporthaus_posts LEFT JOIN wpsporthaus_term_relationships ON (wpsporthaus_posts.ID = wpsporthaus_term_relationships.object_id) WHERE 1=1 AND ( wpsporthaus_posts.ID NOT IN ( SELECT object_id FROM wpsporthaus_term_relationships WHERE term_taxonomy_id IN (11) ) AND wpsporthaus_term_relationships.term_taxonomy_id IN (960) ) AND wpsporthaus_posts.post_type = ‘product’ AND (wpsporthaus_posts.post_status = ‘publish’ OR wpsporthaus_posts.post_status = ‘private’) GROUP BY wpsporthaus_posts.ID ORDER BY FIELD(wp_posts.ID,’13326′,’13339′,’13307′,’13300′,’13281′,’13287′,’13294′,’13079′) DESC, wpsporthaus_posts.menu_order ASC, wpsporthaus_posts.post_title ASC LIMIT 0, 12

    There is no wp_posts.ID in my database, only wpsporthaus_posts.ID.

    • This topic was modified 2 years, 1 month ago by lopri.
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘No products displayed when enabled’ is closed to new replies.