500 - DB function failed with error number 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL=SELECT b.`id` as _comment_last_id, b.`date` as _comment_date, count( b.`comment` ) as _comment_count, b.`comment` as _comment_last , b.`post_by` as _comment_last_by, c.`like` as _likes, a.*, TO_DAYS('2023-09-24 11:12:17') - TO_DAYS( DATE_ADD(a.`created`, INTERVAL 0 HOUR ) ) as _daydiff FROM `jos_community_activities` as a LEFT JOIN ( SELECT `id`, `date`, `comment`, `contentid`, `type`, `post_by` FROM `jos_community_wall` ORDER BY `id` DESC ) as b ON a.`comment_id` = b.`contentid` AND a.`comment_type` = b.`type` LEFT JOIN `jos_community_likes` AS c ON a.`like_id` = c.`uid` AND a.`like_type` = c.`element` WHERE `archived`=0 AND (a.`access` <= 10) GROUP BY a.`id` ORDER BY a.`created` DESC LIMIT 160

You may not be able to visit this page because of:

  1. an out-of-date bookmark/favourite
  2. a search engine that has an out-of-date listing for this site
  3. a mistyped address
  4. you have no access to this page
  5. The requested resource was not found.
  6. An error has occurred while processing your request.

Please try one of the following pages:

If difficulties persist, please contact the System Administrator of this site.

DB function failed with error number 1055
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL=SELECT b.`id` as _comment_last_id, b.`date` as _comment_date, count( b.`comment` ) as _comment_count, b.`comment` as _comment_last , b.`post_by` as _comment_last_by, c.`like` as _likes, a.*, TO_DAYS('2023-09-24 11:12:17') - TO_DAYS( DATE_ADD(a.`created`, INTERVAL 0 HOUR ) ) as _daydiff FROM `jos_community_activities` as a LEFT JOIN ( SELECT `id`, `date`, `comment`, `contentid`, `type`, `post_by` FROM `jos_community_wall` ORDER BY `id` DESC ) as b ON a.`comment_id` = b.`contentid` AND a.`comment_type` = b.`type` LEFT JOIN `jos_community_likes` AS c ON a.`like_id` = c.`uid` AND a.`like_type` = c.`element` WHERE `archived`=0 AND (a.`access` <= 10) GROUP BY a.`id` ORDER BY a.`created` DESC LIMIT 160