[
https://issues.apache.org/jira/browse/ROL-1932?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13410632#comment-13410632
]
Matt Raible commented on ROL-1932:
----------------------------------
In the table definition, the default value is set to CURRENT_TIMESTAMP.
The posttime attribute on the table was created with the clause 'on update
CURRENT_TIMESTAMP' which is causing this effect.
Should we revert this so it doesn't get updated everytime? It's a real pain,
especially when I find old comments with formatting issues. I don't want to
update a comment from 2007 and have it show up with today's date.
> Timestamps on approved comments are the current time, rather than the time
> posted
> ---------------------------------------------------------------------------------
>
> Key: ROL-1932
> URL: https://issues.apache.org/jira/browse/ROL-1932
> Project: Roller
> Issue Type: Bug
> Components: Comments
> Affects Versions: 5.0
> Reporter: Matt Raible
> Assignee: David Johnson
> Fix For: 5.1
>
>
> I have comment moderation turned on for my blog for two reasons 1) it allows
> me to edit the HTML mistakes people make and make my comments look good and
> 2) it allows me to delete the spam.
> However, I've noticed that the comments get the timestamp of when I approve
> it, rather than the timestamp of when it was posted. I think it should be the
> time it's posted b/c otherwise it looks like everyone commented at the same
> time.
> Mailing list discussion: http://markmail.org/message/lifny3cfwitwirod
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
