Convert database to TRADITIONAL sql

Anything you want added or changed in future versions of ZoneMinder? Post here and there's a chance it will get in! Search to make sure it hasn't already been requested.
Post Reply
tetsuo
Posts: 1
Joined: Mon Jan 17, 2011 4:10 am

Convert database to TRADITIONAL sql

Post by tetsuo »

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).
Classic
Posts: 16
Joined: Mon Aug 02, 2010 10:48 pm

Re: Convert database to TRADITIONAL sql

Post by Classic »

which mode is the correct for install zm, I have de the same issue with mysql 5.6..thanks.
User avatar
iconnor
Posts: 2896
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Convert database to TRADITIONAL sql

Post by iconnor »

We would be happy to receive a patch.
Post Reply