mySQL rules different between dev & live sites

[eluser]WanWizard[/eluser]
Since MySQL 5.0.2 this is configurable at engine or session level.

It's very nice (not!) that someone has disabled this in the config, usually done to support a poorly written legacy application. Unfortunately, this affects other applications using the same engine, as you have noticed.

If you don't need DB portability, you can enforce it from your application at runtime, by executing

Code:

$this->db->query("SET SESSION sql_mode='STRICT_ALL_TABLES'");