Convert database to TRADITIONAL sql
Posted: Mon Jan 17, 2011 4:14 am
Those of us who have mysql configured for:
sql_mode=TRADITIONAL
have a problem installing zoneminder, it says:
Setting up zoneminder (1.24.2-2build3) ...
ERROR 1366 (HY000) at line 506: Incorrect integer value: '' for column 'Id' at row 1
Changing the configuration of mysql allowed me to install it, but it would be nice if the zm database was compatible with TRADITIONAL mode (and it's a good practice to work in it).
sql_mode=TRADITIONAL
have a problem installing zoneminder, it says:
Setting up zoneminder (1.24.2-2build3) ...
ERROR 1366 (HY000) at line 506: Incorrect integer value: '' for column 'Id' at row 1
Changing the configuration of mysql allowed me to install it, but it would be nice if the zm database was compatible with TRADITIONAL mode (and it's a good practice to work in it).