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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
