Re: Out of range value for column 'datestamp' at row 1

Gving the full error message would be helpful. Check that the sql mode settings for ALLOW_INVALID_DATE, NO_ZERO_DATE and NO_ZERO_IN_DATE are the same on both master and slave. / Carsten Prabhat Kumar skrev: Hi, I have setup replication between 2 servers, on both there is different versions o

Out of range value for column 'datestamp' at row 1

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` smal