I have been getting a ton of these errorm messages. Does anyone know how to resolve?
[SELECT COUNT(DISTINCT CASE WHEN A1.staff_idIN (11) AND A1.isanswered= '1' THEN A1.ticket_idEND) ASq50, COUNT(DISTINCT CASE WHEN (A1.team_idIN (2) OR A1.staff_idIN (11)) AND A2.state= 'open' AND (A1.team_idIN (2) OR A1.staff_idIN (11)) AND A2.state= 'open' AND A1.staff_idIN (11) AND A2.state= 'open' AND A3.lastresponse<= (NOW() - INTERVAL '2' DAY) AND A3.lastmessage<= (NOW() - INTERVAL '49' HOUR) AND A1.isanswered= '1' THEN A1.ticket_idEND) ASq142, COUNT(DISTINCT CASE WHEN (A1.team_idIN (2) OR A1.staff_idIN (11)) AND A2.state= 'open' AND A1.staff_idIN (11) AND (A1.team_idIN (2) OR A1.staff_idIN (11)) AND A2.state= 'open' AND A1.staff_idIN (11) AND A1.staff_idIN (11) AND A2.state= 'open' AND A1.ticket_id= Z1.ticket_idTHEN A1.ticket_idEND) ASq176, COUNT(DISTINCT CASE WHEN A2.state= 'open' THEN A1.ticket_idEND) ASq1, COUNT(DISTINCT CASE WHEN A2.state= 'open' AND A2.state= 'open' AND A1.isanswered= '0' THEN A1.ticket_idEND) ASq2, COUNT(DISTINCT CASE WHEN (A1.team_idIN (2) OR A1.staff_idIN (11)) AND A2.state= 'open' AND (A1.team_idIN (2) OR A1.staff_idIN (11)) AND A2.state= 'open' AND A1.staff_idIN (11) THEN A1.ticket_idEND) ASq6, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-12-17 08:00:00' AND '2019-12-18 07:59:59' THEN A1.ticket_idEND) ASq9, COUNT(DISTINCT CASE WHEN A2.state= 'open' AND A2.state= 'open' AND A1.isanswered= '1' THEN A1.ticket_idEND) ASq3, COUNT(DISTINCT CASE WHEN (A1.team_idIN (2) OR A1.staff_idIN (11)) AND A2.state= 'open' AND (A1.team_idIN (2) OR A1.staff_idIN (11)) AND A2.state= 'open' AND NOT A1.staff_idIN (11) THEN A1.ticket_idEND) ASq7, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-12-16 08:00:00' AND '2019-12-17 07:59:59' THEN A1.ticket_idEND) ASq10, COUNT(DISTINCT CASE WHEN A2.state= 'open' AND A2.state= 'open' AND A1.isoverdue= '1' THEN A1.ticket_idEND) ASq4, COUNT(DISTINCT CASE WHEN A1.isanswered= '0' AND (A1.team_idIN (2) OR A1.staff_idIN (11)) AND A2.state= 'open' THEN A1.ticket_idEND) ASq5, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-12-16 08:00:00' AND '2019-12-23 07:59:59' THEN A1.ticket_idEND) ASq11, COUNT(DISTINCT CASE WHEN A2.state= 'closed' THEN A1.ticket_idEND) ASq8, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-12-01 08:00:00' AND '2020-01-01 07:59:59' THEN A1.ticket_idEND) ASq12, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-10-01 07:00:00' AND '2020-01-01 07:59:59' THEN A1.ticket_idEND) ASq13, COUNT(DISTINCT CASE WHEN A2.state= 'closed' AND A2.state= 'closed' AND A1.closedBETWEEN '2019-01-01 08:00:00' AND '2020-01-01 07:59:59' THEN A1.ticket_idEND) ASq14FROMost_ticketA1 JOINost_ticket_statusA2 ON (A1.status_id= A2.id) LEFT JOINost_threadA3 ON (A3.object_type= 'T' AND A1.ticket_id= A3.object_id) LEFT JOINost_thread_referralA4 ON (A3.id= A4.thread_id) LEFT JOINost_staffA5 ON (A4.object_type= 'S' AND A4.object_id= A5.staff_id) LEFT JOINost_teamA6 ON (A4.object_type= 'E' AND A4.object_id= A6.team_id) LEFT JOINost_departmentA7 ON (A4.object_type= 'D' AND A4.object_id= A7.id) WHERE (A2.state= 'open' AND (A1.staff_id= 11 OR A5.staff_id= 11 OR A1.team_idIN (2) OR A6.team_idIN (2))) OR (A2.stateIN ('open', 'closed') AND (A1.dept_idIN (1) OR A7.id` IN (1)))]
Unknown column 'Z1.ticket_id' in 'field list'<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...')<br />
#1 (root)/include/class.orm.php(3455): db_query('SELECT COUNT(DI...', true, true)<br />
#2 (root)/include/class.orm.php(3502): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2085): MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(2035): HashArrayIterator->{closure}()<br />
#5 (root)/include/class.orm.php(2014): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(2023): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1695): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807)<br />
#9 (root)/include/class.orm.php(1328): CachedResultSet->asArray()<br />
#10 (root)/include/class.orm.php(1351): QuerySet->all()<br />
#11 (root)/include/class.search.php(925): QuerySet->one()<br />
#12 (root)/include/ajax.search.php(397): SavedQueue::counts(Object(StaffSession), true, Array)<br />
#13 (root)/include/class.dispatcher.php(145): SearchAjaxAPI->collectQueueCounts()<br />
#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('counts', Array)<br />
#15 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('counts', Array)<br />
#16 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/queue/counts', NULL)<br />
#17 (root)/scp/ajax.php(289): Dispatcher->resolve('/queue/counts')<br />
#18 {main}
`
