Hi Till, How are you? I am facing one error after install Cluster Service on opensuse 13.1 My both sever monitor show this error--- Replication failed. Error: (mail_user) in MySQL server: (localhost) Incorrect date value: '' for column 'last_quota_notification' at row 1 # SQL: REPLACE INTO mail_user (`mailuser_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`email`,`login`,`password`,`name`,`uid`,`gid`,`maildir`,`quota`,`cc`,`homedir`,`autoresponder`,`autoresponder_start_date`,`autoresponder_end_date`,`autoresponder_subject`,`autoresponder_text`,`move_junk`,`custom_mailfilter`,`postfix`,`access`,`disableimap`,`disablepop3`,`disabledeliver`,`disablesmtp`,`disablesieve`,`disablesieve-filter`,`disablelda`,`disablelmtp`,`disabledoveadm`,`last_quota_notification`,`backup_interval`,`backup_copies`) VALUES ('1','1','2','riud','riud','','2','[email protected]','[email protected]','$1$9mYNSyCr$EqBpASOWbSu.NHTuBNXBP/','Md. Mohib Billah','5000','5000','/var/vmail/exmaple.com/admin','0','','/var/vmail','n','0000-00-00 00:00:00','0000-00-00 00:00:00','Out of office reply','','n','','y','y','n','n','n','n','n','n','n','n','n','','none','1') please help me for solve this error. Thanks
Till Thanks for your replay but my both server vi /etc/my.cnf sql_mode=NO_ENGINE_SUBSTITUTION Please help. Thanks again
Then check if the mysql server on your system loads some config from somewhere else, e.g. from a conf.d directory where a different value is set for sql_mode