The forum you are viewing relates to Kayako Classic. If you signed up or upgraded to the new Kayako (after the 4th July 2016), the information in this thread may not apply to you. You can visit the forums for the new Kayako here.

Installation Error v. 4.91

Uncaught Exception
Invalid SQL: SELECT COUNT(*) AS totalitems, departmentid, ticketstatusid, ownerstaffid, tickettypeid, MAX(lastactivity) AS lastactivity FROM swtickets
GROUP BY departmentid, ticketstatusid, ownerstaffid (Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kayako_test.swtickets.tickettypeid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by) in ./__swift/library/Database/class.SWIFT_Database.php:860
=================================================================================================================================