So I go to Queue: All Queues and View By: All Tickets
I can click on submitter, created, priority, etc, and my ticket list sorts.  But when I click on "status" it has issues loading the data (you know the big red bar, "I can't do this").

In addition, If I do an Advanced Search and look up say, only "New" or "Closed" it sorts fine.  This leads me to believe that one of my "statuses" has something that is making the sort fail.  Is anyone aware of a bug?

This is more of an annoyance than issue since only the Helpdesk Supervisor does this, but any info would be helpful.

I'm using an appliance on Ver. Version: 6.4.119927

2 Comments   [ + ] Show Comments

Comments

  • Do you know where to get the error logs? If so, can you copy the error logs when you get the error about the status so we can try to figure out what's causing your error?

    Settings>Logs>Server Errors
    • [Fri Apr 15 12:33:02.755032 2016] [proxy_fcgi:error] [pid 46963:tid 34460508160] [client 10.187.12.106:50000] AH01071: Got error 'PHP message: Exception in KGridPage::GetPagedData: mysqli error: [1054: Unknown column 'TITLE' in 'order clause'] in EXECUTE("select * from (SELECT HD_TICKET.SUMMARY, HD_IMPACT.NAME AS IMPACT, HD_CATEGORY.NAME AS CATEGORY, HD_STATUS.NAME AS STATUS_NAME, HD_PRIORITY.NAME AS PRIORITY, O.FULL_NAME AS OWNER_NAME, MACHINE.NAME AS SYSTEM_NAME, HD_TICKET.DUE_DATE, HD_TICKET.CC_LIST, HD_TICKET.CREATED, HD_TICKET.MODIFIED, S.FULL_NAME AS SUBMITTER_NAME, AP.FULL_NAME, HD_TICKET.PARENT_ID, HD_TICKET.RESOLUTION, HD_TICKET.ID, HD_TICKET.SATISFACTION_COMMENT, HD_TICKET.SATISFACTION_RATING, GROUP_CONCAT(DISTINCT HD_TICKET_CHANGE.COMMENT SEPARATOR '\\n') AS HD_TICKET_CHANGE_COMMENT_GROUPED, HD_TICKET.TIME_STALLED, HD_TICKET.TIME_CLOSED, HD_TICKET.TIME_OPENED, HD_TICKET.ESCALATED, HD_TICKET.IS_PARENT, HD_TICKET.APPROVAL_NOTE, HD_TICKET.APPROVAL, ASSET.NAME AS ASSET_NAME, ASSET_TYPE.NAME AS ASSET_TYPE, USER.FULL_NAME AS ASSET_USER, (LEFT(GROUP_CONCAT(DISTINCT COMMENT SEPARATOR '\n'),255)) AS SHORT_COMMENT, @limitct as LIMIT_...\n', referer: http://apkace1/adminui/ticket_list.php?TYPE=aq_search
      • Can you get a screenshot of the error when it occurs and also a screenshot of the statuses that are set up in your queue configuration?
  • This content is currently hidden from public view.
    Reason: Removed by member request
    For more information, visit our FAQ's.
  • After a recent update the error has gone away, I cannot replicate it. It's good, but I feel like it's going to pop its ugly face later. For now, all is good, Thanks KACE_Irwin!
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity