Hi, I have setup replication between 2 servers, on both there is different versions of mysql.
Master :5.0.67-log Slave : 5.1.43sp1-enterprise-gpl-advanced-log There is table: CREATE TABLE `myTable_info` ( `id` int(11) NOT NULL auto_increment, `range` varchar(255) NOT NULL, `total_qt` smallint NOT NULL default '0', `qt_correct` smallint NOT NULL default '0', `finish_time` smallint NOT NULL default '0', `username` varchar(100) NOT NULL, * `datestamp` datetime NOT NULL default '0000-00-00 00:00:00',* PRIMARY KEY (`id`) ) ENGINE=InnoDB ; During replication insert on slave error caused . INSERT INTO myTable_info (id,range, total_qt, qt_correct, finish_time, username, datestamp) VALUES (NULL,'Kumar', '20', '17', '111', 'Prabhat','* NOW()');* Last_SQL_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax I think problem with* `datestamp` datetime NOT NULL default '0000-00-00 00:00:00',* Can any one please suggest me, how to deal with this error. -- Best Regards, Prabhat Kumar MySQL DBA Datavail-India Mumbai Mobile : 91-9987681929 www.datavail.com My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
