http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2846 Summary: Double quotes (") in SQL query prevents downloading of guided reports Product: Koha Version: rel_3_0 Platform: All OS/Version: All Status: NEW Severity: normal Priority: P3 Component: Reports AssignedTo: galen.charlton@liblime.com ReportedBy: beverly.church@liblime.com QAContact: koha-bugs@lists.koha.org It is not possible to download a guided report if the SQL query used to create the report contains double quotes (") around the search criteria. For example if you use the following query containing search criteria between double quotes you will get results: select borrowers.categorycode, categories.description, count(borrowers.borrowernumber) from borrowers left join categories on (borrowers.categorycode=categories.categorycode) where dateenrolled between "2008-10-01" and "2008-10-31" group by categorycode However if you attempt to download the results, the error message "Can't use an undefined value as an ARRAY reference ..." appears. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.