[ https://issues.apache.org/jira/browse/ROL-2037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15030864#comment-15030864 ]
Kohei Nozaki commented on ROL-2037: ----------------------------------- I think this can happen with a {{TIMESTAMP}} type column because it can't store any timestamp before 1970-01-01 00:00:01 UTC by spec. But Roller uses {{DATETIME}}, Which can store more wider range, In schema creation script so it shouldn't occur. References: http://dev.mysql.com/doc/refman/5.5/en/datetime.html https://github.com/apache/roller/blob/a016635d334f2901b2fe9e1c0b6324dc81cf6bc6/app/src/main/java/org/apache/roller/weblogger/planet/tasks/SyncWebsitesTask.java#L178 A similar problem reported with {{TIMESTAMP}}: http://forum.spring.io/forum/spring-projects/batch/111113-spring-batch-job-params-trying-to-insert-1969-12-31-16-00-00-for-column-date-val > Possible breakage in Planet feature > ----------------------------------- > > Key: ROL-2037 > URL: https://issues.apache.org/jira/browse/ROL-2037 > Project: Apache Roller > Issue Type: Bug > Components: Planet Aggregator > Affects Versions: 5.1 > Reporter: David Johnson > Assignee: David Johnson > > I'm still investigating this and hope to fix for 5.1. > [EL Warning]: 2014-07-08 17:38:00.199--UnitOfWork(1194666925)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): > org.eclipse.persistence.exceptions.DatabaseException > Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: > Incorrect datetime value: '1969-12-31 19:00:00' for column 'last_updated' at > row 1 > Error Code: 1292 > Call: INSERT INTO rag_subscription (id, author, feed_url, inbound_blogs, > inbound_links, last_updated, site_url, title) VALUES (?, ?, ?, ?, ?, ?, ?, ?) > bind => [8 parameters bound] > Query: InsertObjectQuery({weblogger:project, > http://rollerweblogger.org/project/, Roller: free and open source Java blog > software, Roller: free and open source Java blog software, Wed Dec 31 > 19:00:00 EST 1969}) > [EL Warning]: 2014-07-08 17:43:00.081--UnitOfWork(1313604468)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): > org.eclipse.persistence.exceptions.DatabaseException > Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: > Incorrect datetime value: '1969-12-31 19:00:00' for column 'last_updated' at > row 1 > Error Code: 1292 -- This message was sent by Atlassian JIRA (v6.3.4#6332)