Make WordPress Core

Opened 14 months ago

Last modified 14 months ago

#40634 new defect (bug)

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

Reported by: plingplong Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version: 4.7.4
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: 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.

Attachments (1)

filterbutton pressed.png (55.4 KB) - added by plingplong 14 months ago.

Download all attachments as: .zip

Change History (2)

#1 @plingplong
14 months ago

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

Note: See TracTickets for help on using tickets.