https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16583 Bug ID: 16583 Summary: Strangeness in the staff client on ubuntu 16.04 and MySQL 5.7 Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: Linux Status: NEW Severity: major Priority: P2 Component: Staff Client Assignee: koha-bugs@lists.koha-community.org Reporter: liz@catalyst.net.nz QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Have noticed some strangeness with a clean install of Koha on MySQL 5.7: When adding a rule at /cgi-bin/koha/admin/smart-rules.pl, if any box is left empty the first empty field pops an error similar to this: DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: '' for column 'chargeperiod' at row 1 at /usr/share/koha/intranet/cgi-bin/admin/smart-rules.pl line 170 When attempting to add a borrower category, it thinks a duplicate has been added with the resultant error message "An error occurred when inserting this patron category. The patron category might already exist." The code for the category did not already exist. I am reporting this bug on behalf of Son Nguyen - he may choose to add any other information he has to this report. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.