Hi,
We have this error (see below)
How can we solve this?
[SELECT COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.state = 'open' AND A1.team_id = 0 AND A1.staff_id = 0 THEN A1.ticket_id END) AS q7, COUNT(DISTINCT CASE WHEN A1.topic_id = 16 THEN A1.ticket_id END) AS q18, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND NOT A1.team_id = 0 THEN A1.ticket_id END) AS q31, COUNT(DISTINCT CASE WHEN (A1.team_id IN (1, 2) OR A1.staff_id IN (2)) AND A2.state = 'open' AND (A1.team_id IN (1, 2) OR A1.staff_id IN (2)) AND A2.state = 'open' AND (A1.team_id IN (1, 2) OR A1.staff_id IN (2)) AND A2.state = 'open' AND A1.ticket_id = Z1.ticket_id THEN A1.ticket_id END) AS q33, COUNT(DISTINCT CASE WHEN A2.state = 'open' THEN A1.ticket_id END) AS q1, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.isanswered = '1' THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN (A1.team_id IN (1, 2) OR A1.staff_id IN (2)) AND A2.state = 'open' THEN A1.ticket_id END) AS q3, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT (A1.team_id = 0 AND A1.staff_id = 0) THEN A1.ticket_id END) AS q5, COUNT(DISTINCT CASE WHEN A2.state = 'closed' THEN A1.ticket_id END) AS q4, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isoverdue = '1' THEN A1.ticket_id END) AS q6 FROM ost_ticket A1 JOIN ost_ticket_status A2 ON (A1.status_id = A2.id) LEFT JOIN ost_thread A3 ON (A3.object_type = 'T' AND A1.ticket_id = A3.object_id) LEFT JOIN ost_thread_referral A4 ON (A3.id = A4.thread_id) LEFT JOIN ost_staff A5 ON (A4.object_type = 'S' AND A4.object_id = A5.staff_id) LEFT JOIN ost_team A6 ON (A4.object_type = 'E' AND A4.object_id = A6.team_id) LEFT JOIN ost_department A7 ON (A4.object_type = 'D' AND A4.object_id = A7.id) WHERE (A2.state = 'open' AND (A1.staff_id = 2 OR A5.staff_id = 2 OR A1.team_id IN (1, 2) OR A6.team_id IN (1, 2))) OR A1.dept_id IN (1, 2, 3) OR A7.id IN (1, 2, 3)]
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/class.search.php(865): SavedQueue::counts(Object(StaffSession), true)<br />
#13 (root)/include/staff/templates/queue-tickets.tmpl.php(96): SavedQueue->getCount(Object(StaffSession))<br />
#14 (root)/scp/tickets.php(526): require_once('/home/osticketc...')<br />
#15 (root)/scp/index.php(17): require('/home/osticketc...')<br />
#16 {main}
