[Koha-bugs] [Bug 16583] New: Strangeness in the staff client on ubuntu 16.04 and MySQL 5.7

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

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 at lists.koha-community.org
          Reporter: liz at catalyst.net.nz
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at 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.