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_trans_tables [2] http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html#sqlmode_no_zero_date [3] http://lists.katipo.co.nz/pipermail/koha/2013-August/037031.html
*** This bug has been marked as a duplicate of bug 17258 ***