https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20592
Bug ID: 20592
Summary: updateitem.pl causes database errors when empty
non-public item notes updated
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: P5 - low
Component: Cataloging
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
If you go to
/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=1&itemnumber=1#item1, and
click "Update" next to an empty
"Non-public note" field, it will generate a database error.
Typically, this is hidden in your Apache logs, but if you have DEBUG turned on,
the database error will be fatal.
Example logs:
[Tue Apr 17 12:43:48.607368 2018] [cgi:error] [pid 1992] [client ...:22158]
AH01215: [Tue Apr 17 12:43:48 2018] updateitem.pl: 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 'WHERE
itemnumber='1'' at line 1 [for Statement "UPDATE items SET WHERE itemnumber=?"
with ParamValues: 0="1"] at ../git/C4/Items.pm line 2038.:
../git/catalogue/updateitem.pl, referer:
http://koha/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=1&itemnumber=1
[Tue Apr 17 12:43:48.607852 2018] [cgi:error] [pid 1992] [client ...:22158]
AH01215: [Tue Apr 17 12:43:48 2018] updateitem.pl: 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 'WHERE
itemnumber='1'' at line 1 [for Statement "UPDATE items SET WHERE itemnumber=?"
with ParamValues: 0="1"] at ../git/C4/Items.pm line 2038.:
../git/catalogue/updateitem.pl, referer:
http://koha/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=1&itemnumber=1
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
