[jira] [Commented] (ROL-1932) Timestamps on approved comments are the current time, rather than the time posted

["Matt Raible (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ROL-1932?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428190#comment-13428190 ] 

Matt Raible commented on ROL-1932:
----------------------------------

I think there might be something wrong with my comments table. Here's the create table syntax for it:

CREATE TABLE `roller_comment` (
  `id` varchar(255) NOT NULL default '',
  `entryid` varchar(255) NOT NULL default '',
  `name` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `content` text,
  `posttime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `remotehost` varchar(128) default NULL,
  `notify` tinyint(1) default NULL,
  `referrer` varchar(255) default NULL,
  `useragent` varchar(255) default NULL,
  `plugins` varchar(255) default NULL,
  `contenttype` varchar(128) NOT NULL default 'text/plain',
  `status` varchar(20) NOT NULL default 'APPROVED',
  PRIMARY KEY  (`id`),
  KEY `co_entryid_idx` (`entryid`),
  KEY `co_status_idx` (`status`),
  KEY `co_combo1_idx` (`status`,`posttime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
                
> 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