Support » Plugin: Enhanced Media Library » Filter by category error – WordPress database error Column

  • Hi,

    Can you please tell me why I am getting this error every time I try to filter by category? I get no results and error in wp-admin folder.

    <strong>[21-Nov-2018 21:04:07 UTC]</strong> WordPress database error Column 'post_author' in where clause is ambiguous for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_posts AS p2 ON (wp_posts.post_parent = p2.ID)  WHERE 1=1  AND ( 
      wp_term_relationships.term_taxonomy_id IN (2946,2947,2948,4658)
    ) AND (wp_posts.post_mime_type LIKE 'image/%')  AND wp_posts.post_type = 'attachment' AND (((wp_posts.post_status = 'inherit' OR wp_posts.post_status = 'private') OR (wp_posts.post_status = 'inherit' AND (p2.post_status = 'inherit' OR p2.post_status = 'private')))) AND post_author <> 77777  GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 40 made by do_action('wp_ajax_query-attachments'), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_query_attachments, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

    It was working! what’s happened?
    BTW I am using PHP7.2

    The page I need help with: [log in to see the link]

  • You must be logged in to reply to this topic.