[
https://issues.apache.org/jira/browse/ROL-1932?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428190#comment-13428190
]
Matt Raible edited comment on ROL-1932 at 8/3/12 3:32 PM:
----------------------------------------------------------
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;
Would it be possible to simply alter the table to fix this?
was (Author: mraible):
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
