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.

Moderator: zoneminder

Posts: 1
Joined: Mon Jan 17, 2011 4:10 am

Convert database to TRADITIONAL sql

Postby tetsuo » Mon Jan 17, 2011 4:14 am

Those of us who have mysql configured for:


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).

Posts: 16
Joined: Mon Aug 02, 2010 10:48 pm

Re: Convert database to TRADITIONAL sql

Postby Classic » Sun Aug 18, 2013 6:01 pm

which mode is the correct for install zm, I have de the same issue with mysql 5.6..thanks.

Posts: 122
Joined: Fri Oct 29, 2010 1:43 am

Re: Convert database to TRADITIONAL sql

Postby iconnor » Fri Oct 18, 2013 12:22 am

We would be happy to receive a patch.

Return to “Feature Requests”

Who is online

Users browsing this forum: No registered users and 1 guest