I've create a new ticket queues with the following condition:

  • open ticket
  • number of thread = 1
    This is useful for seeing all the open tickets that have not yet been answered yet.

I have a problem:
seems that the field thread_count has problem with the count query.
The page with the ticket list is loaded correctly but I receive an error log for a problem with the count.
In fact in the footer it says: 0 results and the number in the menu item is not shown.
(I upload screenshot).

This is the log:
SELECT COUNT(*) FROM (SELECT A1.ticket_idFROMost2_ticketA1 JOINost2_ticket_statusA2 ON (A1.status_id= A2.id) WHERE A2.state= 'open' AND A1.isanswered= '0' AND A2.state= 'open' AND A1.isanswered= '0' AND A1.thread_count` = 1) __]

Unknown column 'A1.thread_count' in 'where clause'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(...')<br />
#1 (root)/include/class.orm.php(3466): db_query('SELECT COUNT()...', true, true)<br />
#2 (root)/include/class.orm.php(3522): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2952): MySqlExecutor->getRow()<br />
#4 (root)/include/class.orm.php(1380): MySqlCompiler->compileCount(Object(QuerySet))<br />
#5 (root)/include/class.search.php(904): QuerySet->count()<br />
#6 (root)/include/class.search.php(997): SavedQueue->getTotal()<br />
#7 (root)/include/class.search.php(912): SavedQueue::counts(Object(StaffSession), true)<br />
#8 (root)/include/staff/templates/queue-tickets.tmpl.php(128): SavedQueue->getCount(Object(StaffSession))<br />
#9 (root)/scp/tickets.php(541): require_once('/var/www/vhosts...')<br />
#10 {main}`

How can I solve?
Thanks

You appear to be using a 3rd party theme mod.
You will want to talk to the author for support.

Write a Reply...