[Koha-bugs] [Bug 29319] New: Errors when doing a cataloging search which starts with a number + letter
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Oct 25 23:48:32 CEST 2021
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 at lists.koha-community.org
Reporter: lucas at bywatersolutions.com
QA Contact: testopia at bugs.koha-community.org
CC: m.de.rooy at 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.
More information about the Koha-bugs
mailing list