Hello friends
i need some help
how to solve this problem

[SELECT COUNT(*) FROM (SELECT A1.ticket_id FROM imagenet_ticket A1 JOIN imagenet_ticket_status A2 ON (A1.status_id = A2.id) WHERE (A1.team_id IN (3, 9) OR A1.staff_id IN (101)) AND A2.state = 'open' AND (A1.team_id IN (3, 9) OR A1.staff_id IN (101)) AND A2.state = 'open' AND A2.state = 'open' AND (A1.team_id IN (3, 9) OR A1.staff_id IN (101)) AND A1.collaborator_count > 0) __] Unknown column 'A1.collaborator_count' in 'where clause'

---- Backtrace ----
#0 (raiz)/include/mysqli.php(201): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(...')
#1 (raiz)/include/class.orm.php(3466): db_query('SELECT COUNT()...', true, true)
#2 (raiz)/include/class.orm.php(3522): MySqlExecutor->execute()
#3 (raiz)/include/class.orm.php(2952): MySqlExecutor->getRow()
#4 (raiz)/include/class.orm.php(1380): MySqlCompiler->compileCount(Object(QuerySet))
#5 (raiz)/include/class.search.php(904): QuerySet->count()
#6 (raiz)/include/class.search.php(997): SavedQueue->getTotal()
#7 (raiz)/include/ajax.search.php(402): SavedQueue::counts(Object(StaffSession), true, Array)
#8 (raiz)/include/class.dispatcher.php(145): SearchAjaxAPI->collectQueueCounts()
#9 (raiz)/include/class.dispatcher.php(38): UrlMatcher->dispatch('counts', Array)
#10 (raiz)/include/class.dispatcher.php(120): Dispatcher->resolve('counts', Array)
#11 (raiz)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/queue/counts', NULL)
#12 (raiz)/scp/ajax.php(316): Dispatcher->resolve('/queue/counts')
#13 {main}

v1.15 is old and no longer supported.
I would recommend that you upgrade.

The error says that its looking for a piece of information (a column named collaborator_count), and saying that it cannot find it (unknown column).

I'm not real sure what is generating this query, but it does not run on my server.

Write a Reply...