roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dave Johnson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ROL-1932) Timestamps on approved comments are the current time, rather than the time posted
Date Mon, 06 Aug 2012 11:49:03 GMT

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

Dave Johnson commented on ROL-1932:
-----------------------------------

Mine looks like this and is apparently the same as yours, except for the default charset:

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,
  `status` varchar(20) NOT NULL DEFAULT 'APPROVED',
  `plugins` varchar(255) DEFAULT NULL,
  `contenttype` varchar(128) NOT NULL DEFAULT 'text/plain',
  PRIMARY KEY (`id`),
  KEY `co_entryid_idx` (`entryid`),
  KEY `rc_combo1_idx` (`posttime`),
  KEY `co_status_idx` (`status`),
  KEY `co_combo1_idx` (`status`,`posttime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
                
> 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