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.