[wp-trac] [WordPress Trac] #40634: Media handling: No fil shows when press filter in list view moduls

[WordPress Trac]

#40634: Media handling: No fil shows when press filter in list view moduls
--------------------------+-----------------------------
 Reporter:  plingplong    |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Media         |    Version:  4.7.4
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 Found what i beleeve is a bug with the media function.

 howto reproduse:
 in list mode, (all mediafile), (All dates), press filter button.

 All file dissapairing, the reset button is grayed out. and Apache2 log
 show
 following errors.

 [Tue May 02 13:50:34.876816 2017] [:error] [pid 17377] [client
 84.53.58.5:28975] WordPress database error You have an error in your SQL
 syntax; check the manual that corresponds to your MySQL server version for
 the right syntax to use near ')))  AND wp_posts.post_type = 'attachment'
 AND ((wp_posts.post_status = 'inherit' at line 1 for query SELECT
 SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_postmeta AS
 sq1 ON ( wp_posts.ID = sq1.post_id AND sq1.meta_key = '_wp_attached_file'
 ) WHERE 1=1  AND ((()))  AND wp_posts.post_type = 'attachment' AND
 ((wp_posts.post_status = 'inherit' OR wp_posts.post_status = 'private'))
 GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 20 made by
 WP_Media_List_Table->prepare_items, wp_edit_attachments_query, wp,
 WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, referer:
 https://alfton.no/ankenes/wp-admin/upload.php

 I think this is not expectet, spessially when you not have selectet any
 filtering options. What i meen is correct behavior is that nothing should
 happend, file should stil be showing.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/40634>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform