1. Kayako Download customers: we will continue to develop and support Kayako Download beyond July 2017, alongside the new Kayako for existing customers.

    Find out more.

  2. 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

Discussion in 'Using Kayako Classic' started by Alex Saavedra, Mar 19, 2018.

  1. Alex Saavedra

    Alex Saavedra Member

    Hi everyone,

    Upon fresh install of Kayako Fusion 4.91, I cannot advance beyond following error message:

    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

    #0 ./__apps/tickets/library/Ticket/class.SWIFT_TicketManager.php(144): SWIFT_Database->Query('SELECT COUNT(*)...')
    #1 [internal function]: SWIFT_TicketManager::RebuildCache()
    #2 ./__swift/library/Cache/class.SWIFT_CacheManager.php(115): call_user_func_array(Array, Array)
    #3 ./__swift/library/Setup/class.SWIFT_Setup.php(195): SWIFT_CacheManager::RebuildEntireCache()
    #4 ./__swift/apps/core/setup/class.Controller_Setup.php(658): SWIFT_Setup->RebuildAllCaches(Array)
    #5 ./__swift/apps/core/setup/class.Controller_Setup.php(350): Controller_Setup->_RunStep7()
    #6 [internal function]: Controller_Setup->StepProcessor()
    #7 ./__swift/library/MVC/class.SWIFT_Controller.php(371): call_user_func_array(Array, Array)
    #8 ./__swift/library/App/class.SWIFT_App.php(176): SWIFT_Controller::Load(Object(SWIFT_Interface), Object(SWIFT_App), Object(SWIFT_Router), false)
    #9 ./__swift/library/class.SWIFT.php(16): SWIFT_App->ExecuteController(Object(SWIFT_Router))
    #10 ./__swift/library/class.SWIFT.php(16): SWIFT->Initialize()
    #11 ./__swift/swift.php(16): SWIFT::GetInstance()
    #12 ./setup/index.php(29): require_once('/var/www/kayako...')
    #13 {main}
  2. supportskins

    supportskins Kayako Guru

    Check if mysql_mode is set to mysql_mode = ''
  3. Alex Saavedra

    Alex Saavedra Member

    Hi supportskins,

    That did the trick. Thank you!
  4. supportskins

    supportskins Kayako Guru

    No problem :)

Share This Page