Hi, Jan! --- Jan Pfeifer wrote: ---
> hi all, > > I've just upgraded one of the replicate servers from 4.0.22 to 4.1.7, > just as a test before upgrading all the others. > Apparently I had just this problem: datetime data inserted in ISO format > is not accepted -- strings like '20041210T104201' when inserted get > silently translated to "0000-00-00 00:00". One of my tables uses this as > a primary key, so I only got the error when it complained about > duplicate keys. ... > Any ideas how to overcome this problem ? Is this a bug ? (I'd be happy > to report if that's the case). This is definitely a bug, which I have reported to MySQL bug-system as: http://bugs.mysql.com/bug.php?id=7308 Meanwhile you can try to use STR_TO_DATE() function as temporary work-around. Thanks for noticing this! -- Dmitri Lenev, Software Developer MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]