View unanswered posts | View active topics It is currently Mon Nov 24, 2014 2:43 pm



Reply to topic  [ 3 posts ] 
Convert database to TRADITIONAL sql 
Author Message

Joined: Mon Jan 17, 2011 5:10 am
Posts: 1
Post Convert database to TRADITIONAL sql
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).


Mon Jan 17, 2011 5:14 am
Profile

Joined: Mon Aug 02, 2010 11:48 pm
Posts: 16
Post Re: Convert database to TRADITIONAL sql
which mode is the correct for install zm, I have de the same issue with mysql 5.6..thanks.


Sun Aug 18, 2013 7:01 pm
Profile

Joined: Fri Oct 29, 2010 2:43 am
Posts: 40
Post Re: Convert database to TRADITIONAL sql
We would be happy to receive a patch.


Fri Oct 18, 2013 1:22 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group