[Bug 27008] New: Broken SQL statement formed in Breeding.pm
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27008 Bug ID: 27008 Summary: Broken SQL statement formed in Breeding.pm Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs@lists.koha-community.org Reporter: joonas.kylmala@helsinki.fi QA Contact: testopia@bugs.koha-community.org The C4/Breeding.pm code doesn't properly form SQL statements and gives error instead:
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the > manual that corresponds to your MariaDB server version for the right syntax to > use near '' at line 5 [for Statement "SELECT import_record_id, file_name, isbn, > title, author FROM import_biblios JOIN import_records USING (import_record_id) JOIN import_batches USING (import_batch_id) WHERE "] at /usr/share/koha/lib/C4/Breeding.pm line 100.
-- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27008 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- I don't recreate, please provide steps to recreate the problem. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27008 --- Comment #2 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- I get an explosion if I search " " or "-", but not on the SQL query. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27008 --- Comment #3 from Joonas Kylmälä <joonas.kylmala@helsinki.fi> --- You can reproduce with this command in koha-shell: perl -e 'use C4::Context; use C4::Breeding; C4::Breeding::BreedingSearch();' -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27008 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |minor --- Comment #4 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Well ok, but it's never called as it. It could be fixed however. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27008 --- Comment #5 from Joonas Kylmälä <joonas.kylmala@helsinki.fi> --- (In reply to Jonathan Druart from comment #4)
Well ok, but it's never called as it. It could be fixed however.
In some real life situation it happens as well but I don't know which one yet, I just got the error waiting in production logs and thought to report it to not forget to fix this :) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27008 Andrew Nugged <nugged@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nugged@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27008 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #6 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Recreated with GET /intranet/cataloguing/addbooks.pl?q=400638133393x *** This bug has been marked as a duplicate of bug 17979 *** -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org