https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39866 Bug ID: 39866 Summary: Acquisitions statistics fails when filling only the To date Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: adolfo.rodriguez@xercode.es QA Contact: testopia@bugs.koha-community.org The Acquisitions statistics returns an Internal Server Error if you fill only the To date. The error happens with both "Placed on" and "Received on". When executing the query, the script checks that the To date is filled but it doesn't check if the From date is also filled. if ( (@linefilter) and ( $linefilter[1] ) ) { $sth->execute( $linefilter[0], $linefilter[1] ); However, it checks both when building the SQL if (@linefilter) { if ( $linefilter[1] ) { if ( $linefilter[0] ) { $strsth .= " AND $line BETWEEN ? AND ? "; } else { $strsth .= " AND $line <= ? "; } } elsif ( ( $linefilter[0] ) and ( ( $line =~ /closedate/ ) or ( $line =~ /received/ ) ) ) { $strsth .= " AND $line >= ? "; } elsif ( $linefilter[0] ) { $linefilter[0] =~ s/\*/%/g; $strsth .= " AND $line LIKE ? "; } } This discrepancy is what creates the error, as it passes the SQL more variables than it expects. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.