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 :)
     
  5. Bhabanisankar Das

    Bhabanisankar Das New Member

    Hi @supportskins

    "Check if mysql_mode is set to mysql_mode = ''

    Where I found it ?
     
  6. Alex Saavedra

    Alex Saavedra Member

    Hi Bhabanisankar Das,
    That depends on your OS and MySQL version. I am using v 5.7, and the directive can be set on mysqld.cnf configuration file as:
    sql-mode = ""
    HTH
     
  7. Bhabanisankar Das

    Bhabanisankar Das New Member

    @supportskins

    I am using the centos and mysql version same as you using.

    But is there any option i could do it GUI mode ?

    lots of database is out there.

    i appreciate your suggestions....

    Thx
     
  8. Alex Saavedra

    Alex Saavedra Member

    Hi Bhabanisankar Das,
    Mysql Workbench should be good.
    phpMyAdmin might help too.
    Regards, --Alex S.
     
  9. Bhabanisankar Das

    Bhabanisankar Das New Member

    Hi @supportskins

    I did this

    # vi /etc/my.cnf file
    sql-mode = '';

    will it work ?
     
  10. Alex Saavedra

    Alex Saavedra Member

    Hi Bhabanisankar,

    Probably not. There is no semicolon for mysql config files, afaik

    If it doesn't work, try an underscore, and also no string delimiters. In a testing server I have this:
    sql_mode=

    In a Windows server I have this:
    sql-mode = ""

    Once you restart the service, you can always tell in the mysql console the current status of your variables:
    show global variables;

    If list is too long, just filter:
    show global variables like 'sql%';

    Good luck
     
  11. Bhabanisankar Das

    Bhabanisankar Das New Member

  12. supportskins

    supportskins Kayako Guru

    No worries :)
     

Share This Page