[Koha-bugs] [Bug 13523] New: AddBiblio fails on mysql with STRICT_TRANS_TABLES

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523

            Bug ID: 13523
           Summary: AddBiblio fails on mysql with STRICT_TRANS_TABLES
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Cataloging
          Assignee: gmcharlt at gmail.com
          Reporter: benjamin.rokseth at kul.oslo.kommune.no
        QA Contact: testopia at bugs.koha-community.org
                CC: m.de.rooy at rijksmuseum.nl

Adding a biblio either via /svc endpoint or via Cataloguing interface fails on
mysql versions > 5.3.21 because of a change in the default settings in
GLOBAL.sql_mode to add STRICT_TRANS_TABLES.

when adding a biblio in Cataloguing or via /svc API: 
---
Software error:

Can't call method "fields" on an undefined value at
/usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl line 683.
---

Doing this manually in SQL results in:
---
ERROR 1364 (HY000): Field 'marcxml' doesn't have a default value
---

This is probably a change that will live (Mysql becomes stricter in v5.7) and
is purposefully added to better handle syntax checks in the SQL.

bugs #10732, #5366 and #10215 all relate to the same but do not propose a fix.

This particular bug proposes to fix the particular issue with adding biblios,
either by

1) changing the database schema to NOT set field `marcxml` to NOT NULL
   (field `marc` in the same table is NULLABLE)
2) changing the AddBiblio code in Biblio.pm so it doesn't require multiple 
   INSERT statements

-- 
You are receiving this mail because:
You are watching all bug changes.