Journal 2SZP Editable Comments

Editable Comments

by
in pipedot on (#2SZP)
Eagle eyed viewers may have noticed a new "Edit" button next to their comments. Yes, you can now fix a broken link, correct a typo, or add additional information to your comments.

Things to note:
  • Any positive moderation points will be removed. Negative moderation points will remain to prevent trolls from reseting the comment's score by simply editing their comment.
  • The "Edit Time" of the comment will change. This will allow visitors to see it as a new comment (and turn it blue.)
  • The full history of the modifications can be seen by clicking on the comment link. The diff is colored with green (additions) and red (deletions) backgrounds to help highlight the changes.
Example edited comment below.
    Reply 6 comments
    Fatal Error - sql [select reason, count(reason) as reason_count, value from comment_vote where comment_id = ? group by reason order by reason_count desc] arg [92151] msg [SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pipedot.comment_vote.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] - bryan.pipedot.org
    Fatal Error
    sql [select reason, count(reason) as reason_count, value from comment_vote where comment_id = ? group by reason order by reason_count desc] arg [92151] msg [SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pipedot.comment_vote.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]