SQL Brain Teaser - Why "an Incorrect datetime value"?

Kostyantyn ran into this issue today. I was totally clueless till he got it sorted out.

Suppose you have a table like so:
  CREATE TABLEE foo(timevalue timestamp);

You successful run the following INSERT:
  INSERT INTO foo(timevalue) values ('2007-03-11 01:53:44');

You attempt to run the following INSERT:
  INSERT INTO foo(timevalue) values ('2007-03-11 02:53:44');

You get the error:
  error# 1292: Incorrect datetime value: '2007-03-11 02:53:44' for column timevalue

What's the problem? How do you fix it?

The value 3/11/2007 corresponds to a daylight savings time switchover date. On that particular day, there was no 2:00 - 2:59am.

This is issue was caused by the fact that the database contained raw timestamp data from another timezone. When this data was loaded, the timezone wasn't adjusted to the locale specific timezone. The result was this one particular record which can't really exist.