Data truncation: Incorrect date value: '1989-00-21' for column 'column_' at row 1

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web204

  • via GitHub by rhauch
  • via GitHub by tigerw
  • via GitHub by TheStriker0995
  • Stack trace

    • com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: '1989-00-21' for column 'column_' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket( at com.mysql.jdbc.MysqlIO.checkErrorPacket( at com.mysql.jdbc.MysqlIO.sendCommand( at com.mysql.jdbc.MysqlIO.sqlQueryDirect( at com.mysql.jdbc.ConnectionImpl.execSQL( at com.mysql.jdbc.ConnectionImpl.execSQL( at com.mysql.jdbc.StatementImpl.execute( at com.mysql.jdbc.StatementImpl.execute( at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest$6.execute( at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest$6.execute( at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest$MySQLConnection.execute( at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest.writeAndCaptureRow( at com.github.shyiko.mysql.binlog.BinaryLogClientIntegrationTest.testDeserializationOfDATE(

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    3 times, last one
    12 times, last one
    Unknown visitor
    Unknown visitor2 times, last one
    Unknown visitor
    Unknown visitorOnce,
    21 more bugmates