Spam Filtering

by
in pipedot on (#2WNE)
Recently, Soylent News discussed adding more labels to the moderation system. Although opinions on “Disagree” and “Factually Incorrect” may still be varied, nearly everyone supported the addition of a “Spam” label.

For Pipedot, we've gone ahead and added the later. Moderating a comment as “Spam” will decrease its score by one and flag it for further review by an editor. This way, normal users can greatly help the editors identify junk comments.

Once an editor marks a comment as spam, the message will be “hidden” one step deeper than the normal “Hide Threshold” slider setting. However, comments are never deleted. If you want to continue to see all comments, including the spam, click the “Show Junk Comments” checkbox on your profile settings page. Similar to the current blue (new) and gray (seen) rendering, the title bar of junk comments will be colored red to easily differentiate them from the good stuff.
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 [94896] 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] - Pipedot
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 [94896] 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]