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@lists.koha-community.org Reporter: joseanjos@gmail.com QA Contact: testopia@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.