MySQL Error – Field ‘name’ doesn’t have a default value – OS X

This error crops up when you’re trying to run INSERT or UPDATE command with empty fields for which default value isn’t set.

Cause:

MySQL has a couple of modes,  of which STRICT_TRANS_TABLES is the one screwing you over. This mode is enabled by default in an install-script generated my-default.cnf or my.cnf file. (the exact name depends on your MySQL version)