Can not create Task with allocPSA 1.8.5

[Daniel]

If I try to create a new task into the newly installed instance

I receive the followed error:

Query failed: Slave running with --log-slave-updates must use row-based binary
logging to be able to replicate row-based binary log events

INSERT INTO task (taskName,priority,dateCreated,dateTargetStart,taskStatus,pro
jectID,taskTypeID,personID,managerID,estimatorID) VALUES
('Training/Development','3','2012-07-11
23:23:57','2012-07-11','open_notstarted','1','Parent','1','1','1')

any Idea ?

[Con Zymaris]

Hello rutzd,

Was this something that was recently upgraded, or a new, fresh installation of
version 1.8.5?

Was this kind of action working correctly on previous occasions?

-- Con

[Nobody/Anonymous]

Hello Con

I installed a new fresh installation.

The installation is done on a Qnap TS412 Server with mysql already
preinstalled.

I can change the values into the my.cnf file but I don't known what I have to
chose...

Thanks for help

Daniel

[Con Zymaris]

Hi Daniel,

what version of MySQL are you running? You might also want to check the
following to see if it gives any pointers about bypassing this issue:

http://dev.mysql.com/doc/refman/5.1/en/binary-log-
setting.html

-- Con

[Daniel]

Hello Con,

I added the value

binlog_format=MIXED

in my.cnf file

Know it works well

Thanks for your help

Daniel

[Con Zymaris]

Daniel,

glad to help and great to hear that it's all working.

-- Con