Support

February 3, 2014 at 3:45 am

There’s a bug in Lines 191 and 192 in event_espresso/includes/event_management/queries.php

Lines 191-192:

$SQL .= $month_range && $attendees && ! $event_id ? ' AND a.date BETWEEN "' . $year_r . '-' . $month_r . '-01" AND "' . $year_r . '-' . $month_r . '-' . $days_this_month . '"' : '';
$SQL .= $month_range && ! $attendees && ! $event_id ? ' AND e.start_date BETWEEN "' . $year_r . '-' . $month_r . '-01" AND "' . $year_r . '-' . $month_r . '-' . $days_this_month . '"' : '';

$days_this_month holds the current month’s total number of days, not the total number for the month being searched.

Thus, if the current month is February, it fails to return any attendees for an event on the 30th of January because that event is outside the date range (01-28).

A possible fix follows, but it assumes a MySQL database (EXTRACT isn’t standard SQL).

Lines 191-192:

$SQL .= $month_range && $attendees && ! $event_id ? ' AND EXTRACT(year_month FROM a.date) = "' . $year_r . $month_r . '"' : '';
$SQL .= $month_range && ! $attendees && ! $event_id ? ' AND EXTRACT(year_month FROM e.start_date) = "' . $year_r . $month_r . '"' : '';

• This topic was modified 10 years, 10 months ago by Luke Morton.
• This topic was modified 10 years, 10 months ago by Luke Morton. Reason: Tags getting mangled