Column type mismatch - received type 0

[Ben Reece]

I'm updating to 5.1.30 from 5.1.22, and when I start up my slaves, I get this error:

090205 10:14:00 [ERROR] Slave SQL: Table definition on master and slave does not match: Column 26 type mismatch - received type 0, Product_Item has type 246, Error_code: 1535
090205 10:14:00 [Warning] Slave: Slave SQL thread ignored the query because of replicate-*-table rules Error_code: 1237
090205 10:14:00 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log [log] position [position]


I'm using 'mixed' binlog format. The table specified is included in 'Replicate_Do_Table' in 'SHOW SLAVE STATUS'. I've double & triple-checked the tables on both master and slave to make sure they're the same. My web research hasn't turned anything up, either. Do you have any insights as to why this would be happening?

Thanks,
Ben



Edited 1 time(s). Last edit at 02/17/2009 12:05PM by Ben Reece.