https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29319 Bug ID: 29319 Summary: Errors when doing a cataloging search which starts with a number + letter Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs@lists.koha-community.org Reporter: lucas@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl To recreate: Go to addbooks.pl and try a catalog search that starts with a number like 3rd degree, 7th heaven, or 6th target. The searches will result in an ugly error page and the following in the error logs: C4::Breeding::BreedingSearch(): DBI Exception: 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 at /kohadevbox/koha/cataloguing/addbooks.pl line 123 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 DBIx::Class::Exception::throw('DBIx::Class::Exception', 'DBI Exception: 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', 0) called at /usr/share/perl5/DBIx/Class/Schema.pm line 1118 DBIx::Class::Schema::throw_exception('Koha::Schema=HASH(0x560206b40608)', 'DBI Exception: 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') called at /usr/share/perl5/DBIx/Class/Storage.pm line 113 DBIx::Class::Storage::throw_exception('DBIx::Class::Storage::DBI::mysql=HASH(0x560206d0e768)', 'DBI Exception: 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') called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501 DBIx::Class::Storage::DBI::__ANON__('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', 'DBI::st=HASH(0x56020b84bbe8)', undef) called at /kohadevbox/koha/C4/Breeding.pm line 99 C4::Breeding::BreedingSearch(undef, '7th heaven') called at /kohadevbox/koha/cataloguing/addbooks.pl line 123 eval {...} at /kohadevbox/koha/cataloguing/addbooks.pl line 2 Note: If I search for something like '33rd Heaven', 77th target, I get no error -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.