[
https://issues.apache.org/jira/browse/ROL-2095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15053939#comment-15053939
]
Kohei Nozaki commented on ROL-2095:
-----------------------------------
BTW, You said that in SVN commit 1680531 we changed the type {{timestamp}} to
{{datetime(3)}}, Had Roller used {{timestamp}} not {{datetime}} in former
versions?
I think it's important point because there's some difference between
{{timestamp}} and {{datetime}}, I don't have much experience with MySQL though.
> Roller 510 -> 520 migration is incomplete for TIMESTAMPS
> --------------------------------------------------------
>
> Key: ROL-2095
> URL: https://issues.apache.org/jira/browse/ROL-2095
> Project: Apache Roller
> Issue Type: Bug
> Reporter: David Johnson
> Assignee: Roller Unassigned
>
> In SVN commit 1680531 we added to mysql.properties these two lines:
> TIMESTAMP_SQL_TYPE_NULL=datetime(3) NULL
> TIMESTAMP_SQL_TYPE=datetime(3)
> Those lines effectively changed the type of all timestamp columns in Roller
> from timestamp to datetime(3), but we offer no migration to convert timestamp
> data to datatime(3) format.
> This will cause Roller to fail to work with errors like this:
> [EL Warning]: 2015-12-06 16:09:42.61--UnitOfWork(659709738)--Exception
> [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd):
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: java.sql.SQLException: Cannot convert value '2014-11-27
> 10:25:01.000' from column 8 to TIMESTAMP.
> Error Code: 0
> Call: SELECT id, about, isactive, allowcomments, analyticscode, blacklist,
> creator, datecreated, defaultallowcomments, defaultcommentdays,
> defaultplugins, editorpage, editortheme, emailaddress, emailcomments,
> enablebloggerapi, enablemultilang, displaycnt, handle, icon, lastmodified,
> locale, commentmod, name, showalllangs, tagline, timeZone, visible,
> bloggercatid FROM weblog WHERE (handle = ?)
> bind => [1 parameter bound]
> Query: ReadAllQuery(name="Weblog.getByHandle" referenceClass=Weblog
> sql="SELECT id, about, isactive, allowcomments, analyticscode, blacklist,
> creator, datecreated, defaultallowcomments, defaultcommentdays,
> defaultplugins, editorpage, editortheme, emailaddress, emailcomments,
> enablebloggerapi, enablemultilang, displaycnt, handle, icon, lastmodified,
> locale, commentmod, name, showalllangs, tagline, timeZone, visible,
> bloggercatid FROM weblog WHERE (handle = ?)")
> We should either revert the datetime(3) change or add a migration for all
> fields effected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
