[Koha-bugs] [Bug 29204] New: Error 500 when execute Circulation report with date period

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29204

            Bug ID: 29204
           Summary: Error 500 when execute Circulation report with date
                    period
 Change sponsored?: ---
           Product: Koha
           Version: 21.05
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Reports
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: joseanjos at gmail.com
        QA Contact: testopia at bugs.koha-community.org

This error doesn't affect version 20.11.03
To reproduce:
Go to Reports -> Circulation
On Period select "Row" or "Column" and choose a date
Submit

You will have a Error 500.
Logs, intranet-error.log:
AH01215: main::calculate(): DBI Exception: DBD::mysql::st execute failed:
Incorrect DATETIME value: '' [for Statement "SELECT distinctrow
date_format(`datetime`,"%Y-%m-%d") FROM statistics LEFT JOIN borrowers ON
(statistics.borrowernumber = borrowers.borrowernumber)  WHERE datetime IS NOT
NULL AND datetime != ''  AND datetime BETWEEN ? AND ?  AND                type
='issue'  group by date_format(`datetime`,"%Y-%m-%d") order by
date_format(`datetime`,"%Y-%m-%d") " with ParamValues: 0='2021-10-01',
1='2021-10-11 23:59:59'] at
/usr/share/koha/intranet/cgi-bin/reports/issues_stats.pl line 104:
/usr/share/koha/intranet/cgi-bin/reports/issues_stats.pl,

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.