http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10732 Bug ID: 10732 Summary: use a stricter SQL_MODE Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt@gmail.com Reporter: gmcharlt@gmail.com QA Contact: testopia@bugs.koha-community.org It would be nice to have Koha use a stricter MySQL/MariaDB SQL_MODE. Currently, Koha essentially expects that SQL_MODE is NULL. In particular, STRICT_TRANS_TABLES would add better type checking -- for example, no more inserting strings into an int field and expecting things to magically work. Another mode to consider is NO_ZERO_DATE [2]. It appears that MySQL on OS X ships with SQL_MODE set to a value that includes STRICT_TRANS_TABLES; a user report indicates that at least one seed data script cannot be loaded as a consequence. [3] [1] http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html#sqlmode_strict_t... [2] http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html#sqlmode_no_zero_... [3] http://lists.katipo.co.nz/pipermail/koha/2013-August/037031.html -- You are receiving this mail because: You are watching all bug changes.