mySQL rules different between dev & live sites

[eluser]theshiftexchange[/eluser]
[quote author="WanWizard" date="1274812618"]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'");

[/quote]

Interesting; its actually on my dev box, which a Ubuntu 'lamp' server, with no config changes made by me - so the default is to have it turned off!

I'll have to look into how to change it on my mysql settings...

edit: thanks very much for your help