http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=3017 Summary: guided reports: save_report() corrupts sql query Product: Koha Version: rel_3_0 Platform: PC OS/Version: All Status: NEW Severity: normal Priority: P3 Component: Reports AssignedTo: galen.charlton@liblime.com ReportedBy: mason.loves.sushi@gmail.com QAContact: koha-bugs@lists.koha.org an enthusiastic regex removes trailing characters from the saved sql query sub save_report { my ( $sql, $name, $type, $notes ) = @_; my $dbh = C4::Context->dbh(); $sql =~ s/(\W*)$//; <<<<<<<<<<<<<<<<<< eg: saving this sql... select count(dateaccessioned) from items where dateaccessioned "2008-01-01" and dateaccessioned < "2010-01-01" becomes... (no trailing /"/) select count(dateaccessioned) from items where dateaccessioned "2008-01-01" and dateaccessioned < "2010-01-01 patch for 3.0.x attached.. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.