Bug in main query

[brahimwpk]

Hello community,

After a days of debugging i found a bug in wordpress core related to query var 'm', in the case that allows to get posts of a month.

wp-includes/class-wp-query.php in this bloc

<?php
if ( $q['m'] ) {
    if(strlen( $q['m'] ) == 6){

i changed the where statement :

<?php
$where .= " AND {$wpdb->posts}.post_date <= '$end_date' AND {$wpdb->posts}.post_date >= '$start_date' ";

to :

<?php
$where .= " AND {$wpdb->posts}.post_date <= '$end_date 23:59:59' AND {$wpdb->posts}.post_date >= '$start_date' ";

[johnbillion]

Thanks for the report @brahimwpk . What's the actual bug you're seeing please?

[SergeyBiryukov]

Hi there, welcome to WordPress Trac!

Just linking to some tickets that might be related: #26653, #29908.

[mindctrl]

Hi @brahimwpk, are you still experiencing the issue? If so, could you provide more details? It's not exactly clear what bug you were seeing. Also, the screenshot of the code does not match the current logic in WP_Query, so I'm wondering if what you were seeing is fixed now.

[callumbw95]

Hey all,

I think it is safe now to close this ticket is being closed due to inactivity. We haven't received any updates or responses from the reporter in over 3 years, and attempts to reproduce the issue have been unsuccessful. If the problem still exists, please provide more information or reopen the ticket, and we can take another look into this. 😃