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.

Issue With User List, 'There is nothing to display here'...

Discussion in 'Using Kayako Classic' started by PGreen, Jul 16, 2017.

  1. PGreen

    PGreen Member

    We have recently migrated our helpdesk to a new server and everything seems to be working fine apart from when we go to 'manage users' from the staff control panel. We are told...

    There is nothing to display here

    ...and the list is empty, although the number of pages is showing correctly...

    Page 1 of 148 1 2 3 4 5 > Last »

    Searching for a user we get the same message, although the number of pages updates correctly so the search is working:

    Page 1 of 6 1 2 3 4 5 > Last »

    There are some slight differences in the two servers, namely updating from PHP 5.4 to PHP 5.6 and that we are now using xcache (disabling it makes no difference) but the new server is setup from scratch in line with the server requirements and the migration done following the guide with no issues.

    As far as we can see everything else is working fine in the helpdesk itself, although we have seen an issue when trying to run an in place upgrade which is documented by other users with different versions here:

    http://forums.kayako.com/threads/4-70-upgrade-issue.42525/page-1

    We have only just noticed this so have rolled back the upgrade, if it is related then we can look into that too. It may be relevant that upgrades never failed on the previous server.

    Any help on either issue much appreciated.

    Our environment is Ubuntu 16.04, Apache, PHP5.6, Kayako 4.77.
     
  2. PGreen

    PGreen Member

    To add to this, using the quick filter by user group on the left gives...


    "0" Results Found
    Kayako was unable to locate any records matching the specified criteria.
     
  3. PGreen

    PGreen Member

    This is sorted now, the issue is with the grouping in the query used to return the list of users. There is a SQL mode setting which is default in later versions of MySQL and needs to be removed for the users query to function correctly. This is from MySQL:

    As of MySQL 5.7.5, the default SQL mode includes ONLY_FULL_GROUP_BY. (Before 5.7.5, MySQL does not detect functional dependency and ONLY_FULL_GROUP_BY is not enabled by default.)

    The full document is here.
     

Share This Page