DB Error #1054

Roccob

Good day.
I need assistance with the below 2x DB 1054 errors:
Error 1:
[SELECT COUNT(*) FROM (SELECT A1.ticket_id FROM ost_ticket A1 JOIN ost_ticket_status A2 ON (A1.status_id = A2.id) WHERE A2.state = 'open' AND A2.state = 'open' AND A2.state = 'open' AND A1.task_count > 0 AND A1.dept_id IN (22, 23, 20, 21)) __] Unknown column 'A1.task_count' in 'where clause' ---- Backtrace ---- #0 (root)/include/mysqli.php(211): osTicket->logDBError() #1 (root)/include/class.orm.php(3482): db_query() #2 (root)/include/class.orm.php(3538): MySqlExecutor->execute() #3 (root)/include/class.orm.php(2964): MySqlExecutor->getRow() #4 (root)/include/class.orm.php(1381): MySqlCompiler->compileCount() #5 (root)/include/class.search.php(910): QuerySet->count() #6 (root)/include/class.search.php(1012): SavedQueue->getTotal() #7 (root)/include/class.search.php(918): SavedQueue::counts() #8 (root)/include/staff/templates/queue-tickets.tmpl.php(124): SavedQueue->getCount() #9 (root)/scp/tickets.php(569): require_once('...') #10 (root)/scp/index.php(17): require('...') #11 {main}

Error 2 (The error is very long, so I have taken a screenshot):

KevinTheJedi

Roccob

Queue with ID of 147 is the culprit. You need to find this Queue and remove the Task Count criteria or delete the Queue all together. There are issues with some "count" based criteria.

Cheers.

Roccob

Hi Kevin.

I trust you are well.

Thank you for getting back to me, I will have a look and advise.

Please can you also advise on how you saw that it is Queue ID 147 so that I can resolve in the future?

KevinTheJedi

Roccob

Your first error look at the criteria and then look at the second error. You’ll see the same criteria has AS 'q147'.

Cheers.