MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Error 1292: Incorrect date value: '0000-00-00' stops synchronizing
Posted by: Georg Menhard
Date: September 16, 2008 05:58AM

Hi,

I really have problems synchronizing my databases. Quite often the synchronization breaks with the error:

Error 1292: Incorrect date value: '0000-00-00' for column 'date' at row 123

The only solution I know is to change all "0000-00-00" dates in the db.

Is there a way to force MySQL Workbench into ignoring this error and continue the synchronization?

Thanks for you help!!!

Georg



Edited 1 time(s). Last edit at 09/16/2008 05:59AM by Georg Menhard.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Error 1292: Incorrect date value: '0000-00-00' stops synchronizing
13083
Georg Menhard
September 16, 2008 05:58AM
Re: Error 1292: Incorrect date value: '0000-00-00' stops synchronizing
8086
Bruno Lousa
September 21, 2008 04:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.