We're updating the issue view to help you get more done. 

Moderating and approving comments does not work

Description

Moderating comments doesn't work.
When approving a comment it's still in the waiting-to-be-moderated list.
This is because the value "moderated_on" is never set in the database.

It seems to work by changing field-type for "moderated_on" in file "/app/models/ca_item_comments.php" to "INT" instead of "FT_TIMESTAMP" and in the moderate() function changing
$this->set('moderated_on', 'now')); to $this->set('moderated_on', time());
Since in the DB the column-type is Integer that saves an epoch-timestamp;
But this probably isn't the best solution?

Tested this on both a 1.7.5 install we have and a 1.7 install.
Both are upgraded from earlier versions of CA.

Environment

None

Assignee

User known

Reporter

Torbjörn Hagenstam

Labels

None

Components

Fix versions

Affects versions

Priority

Major
Configure