http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637 Bug ID: 14637 Summary: Add patron category fails with MySQL 5.6.26 Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: boutrosboutrosboutros@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Cannot add patron category in web interface (/cgi-bin/koha/admin/categorie.pl?op=add_form). It fails with "An error occurred when inserting this patron category. The patron category might already exist." The logs wil show: categorie.pl: DBD::mysql::st execute failed: Incorrect date value: '' for column 'enrolmentperioddate' at row 1 at /usr/share/koha/intranet/cgi-bin/admin/categorie.pl line 231., referer: http://192.168.50.12:8081/cgi-bin/koha/admin/categorie.pl?op=add_form Disabling STRICT_TRANS_TABLES in MySQL will fix the problem, but as the setting is default now, we should have a permanent fix. This is a similar problem as bug #13523. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.