Systems Management : In the Service Desk Module (Tickets) Sorting "Status" gives a "data loading error"

In the Service Desk Module (Tickets) Sorting "Status" gives a "data loading error"

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

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 - KACE_Irwin 8 years ago
- [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 - Soloman007 8 years ago
  - 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? - KACE_Irwin 8 years ago
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! - Soloman007 8 years ago

Answers (0)

Be the first to answer this question

Answer this question

Posted by:

View more:

Systems Management Questions

question

In the Service Desk Module (Tickets) Sorting "Status" gives a "data loading error"

Answers (0)

Posted by:

View more:

Related Questions

Related Links

Related Posts

Systems Management

In the Service Desk Module (Tickets) Sorting "Status" gives a "data loading error"

Answers (0)

Posted by:

Don't be a Stranger!

View more:

Related Questions

Related Links

Related Posts

Share