Make WordPress Core

Opened 6 years ago

Closed 4 years ago

#40634 closed defect (bug) (worksforme)

Media handling: No fil shows when press filter in list view moduls

Reported by: plingplong's profile plingplong Owned by:
Milestone: Priority: normal
Severity: normal Version:
Component: Media Keywords:
Focuses: Cc:


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] 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:

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.

Attachments (1)

filterbutton pressed.png (55.4 KB) - added by plingplong 6 years ago.

Download all attachments as: .zip

Change History (4)

#1 @plingplong
6 years ago

hmm, is it only me that experience this? if so, could maybe someone point me in right direktions to fix it my self..

This ticket was mentioned in Slack in #core-media by joemcgill. View the logs.

4 years ago

#3 @desrosj
4 years ago

  • Milestone Awaiting Review deleted
  • Resolution set to worksforme
  • Status changed from new to closed
  • Version 4.7.4 deleted

Hi @plingplong! Welcome to Trac. Thanks for opening this. Sorry that it took so long to get a response.

I have been trying to reproduce the issue you have described, but have been unable to following your steps.

I am going to close this out as worksforme. But, if you are still able to reproduce this issue, feel free to reopen it with more detailed steps to take and it can be revisited.

Note: See TracTickets for help on using tickets.