[Koha-bugs] [Bug 20592] New: updateitem.pl causes database errors when empty non-public item notes updated

[bugzilla-daemon at bugs.koha-community.org]

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: koha-bugs at lists.koha-community.org
          Reporter: dcook at prosentient.com.au
        QA Contact: testopia at bugs.koha-community.org
                CC: m.de.rooy at rijksmuseum.nl

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.