[
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
