roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Raible (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ROL-1932) Timestamps on approved comments are the current time, rather than the time posted
Date Tue, 10 Jul 2012 17:56:35 GMT

    [ 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

        

Mime
View raw message