Story 2014-04-28 3JD Comment Reply Notification

Comment Reply Notification

by
in pipedot on (#3JD)
Plenty of updates this week! Nearly every single source file and database table was modified this week to help further the distributed goal of the Pipecode project. More information on this will be given over the following weeks as more functionality gets merged to live.
  • Comment Reply Notification - You now get an internal email notification sent to you when someone replies to one of your comments.
  • UID to ZID - Usernames and Identification are now shown in an email style format (username@pipedot.org)
  • Clickable Bare Links - Bare links will now automatically be wrapped with the correct HTML tags to make them clickable.
  • Consistent Newlines - Posts with blockquote/ul/ol/li/pre HTML tags should now have better newline handling.
  • Servers upgraded from Ubuntu 12.04 LTS to 14.04 LTS.
Reply 11 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 [1250] 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 [1250] 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]