HESK version: 2.6.8 - Can't execute SQL

[boang311]

HESK version: 2.6.8 - Check for updates
Mods for HESK Version: 2.6.4 - Check for updates
PHP version: 7.2.19-0ubuntu0.18.04.1 (MySQLi)
MySQL version: 5.7.26-0ubuntu0.18.04.1
/hesk_settings.inc.php Exists, Writable
/attachments Exists, Writable

Write your message below: Hi Good Day Everyone, Hope someone could help me with this Hesk Helpdesk software when I attempted to MERGE TICKET ID.. After Debugging the Error Shows Below..

Error:

Can't execute SQL: SELECT COUNT(*) as `cnt`, `staffid` FROM `hesk_replies` WHERE `replyto`=2248 GROUP BY CASE WHEN `staffid` = 0 THEN 0 ELSE 1 END ASC
MySQL said:
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'trackingsys.hesk_replies.staffid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Hopefully someone could help me.. I'm a Hesk Deskhelp user.. thanks

[Klemen]

You will need to update your help desk to the latest version which has a fix for this change in MySQL default settings.