I received the notification "DB Error #1054", I saw on the forum that we should delete and create the queue. My questions are :
1- In the SQL request, Z1 table is missing, so the request should failed, how to fix the request ?
2- If I delete the queue, what are the impacts on the stored tickets ? What are the impact on the sub/linked queues ?
SELECT COUNT(DISTINCT CASE WHEN A1.topic_id = 21 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q22, COUNT(DISTINCT CASE WHEN A1.topic_id = 21 AND A1.topic_id = 21 AND A1.staff_id IN (13, 23) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q25, COUNT(DISTINCT CASE WHEN A1.topic_id = 21 AND A1.topic_id = 21 AND NOT A1.staff_id IN (13, 23) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q26, COUNT(DISTINCT CASE WHEN A1.topic_id = 21 AND A1.topic_id = 21 AND A1.topic_id = 21 AND A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q36, COUNT(DISTINCT CASE WHEN A1.topic_id = 21 AND A1.topic_id = 21 AND A1.topic_id = 21 AND A2.id IN (3) AND A1.ticket_id = Z1.ticket_id AND A3.object_type = 'T' THEN A1.ticket_id END) AS q37, COUNT(DISTINCT CASE WHEN A1.topic_id = 21 AND A1.topic_id = 21 AND A1.topic_id = 21 AND A2.id IN (2) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q38, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q1, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '0' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN A1.staff_id IN (14) AND A2.state = 'open' AND A1.staff_id IN (14) AND A2.state = 'open' AND A1.staff_id IN (14) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q6, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2022-07-01 00:00:00' AND '2022-07-01 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q9, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '1' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q3, COUNT(DISTINCT CASE WHEN A1.staff_id IN (14) AND A2.state = 'open' AND A1.staff_id IN (14) AND A2.state = 'open' AND NOT A1.staff_id IN (14) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q7, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2022-06-30 00:00:00' AND '2022-06-30 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q10, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isoverdue = '1' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q4, COUNT(DISTINCT CASE WHEN A1.staff_id IN (14) AND A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q5, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2022-06-27 00:00:00' AND '2022-07-03 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q11, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q8, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2022-07-01 00:00:00' AND '2022-07-31 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q12, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2022-07-01 00:00:00' AND '2022-09-30 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q13, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2022-01-01 00:00:00' AND '2022-12-31 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q14 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_thread A6 ON (A1.ticket_id = A6.object_id AND A6.object_type = 'C') LEFT JOIN ost_thread_referral A7 ON (A6.id = A7.thread_id) LEFT JOIN ost_staff A8 ON (A7.object_type = 'S' AND A7.object_id = A8.staff_id) LEFT JOIN ost_department B0 ON (A4.object_type = 'D' AND A4.object_id = B0.id) LEFT JOIN ost_department B1 ON (A7.object_type = 'D' AND A7.object_id = B1.id) WHERE ((A2.state = 'open' AND (A1.staff_id = 14 OR A5.staff_id = 14 OR A6.object_type = 'C' AND A8.staff_id = 14)) OR (A2.state IN ('open', 'closed') AND (A1.dept_id IN (7) OR B0.id IN (7))) OR A6.object_type = 'C' AND B1.id IN (7))]
Unknown column 'Z1.ticket_id' in 'field list'<br />
<br />
---- Trace ----<br />
#0 (racine)/include/mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...')<br />
#1 (racine)/include/class.orm.php(3459): db_query('SELECT COUNT(DI...', true, true)<br />
#2 (racine)/include/class.orm.php(3506): MySqlExecutor->execute()<br />
#3 (racine)/include/class.orm.php(2093): MySqlExecutor->getArray()<br />
#4 (racine)/include/class.orm.php(2043): HashArrayIterator->{closure}()<br />
#5 (racine)/include/class.orm.php(2022): CallbackSimpleIterator->next()<br />
#6 (racine)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()<br />
#7 (racine)/include/class.orm.php(1703): CallbackSimpleIterator->valid()<br />
#8 (racine)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)<br />
#9 (racine)/include/class.orm.php(1336): CachedResultSet->asArray()<br />
#10 (racine)/include/class.orm.php(1359): QuerySet->all()<br />
#11 (racine)/include/class.search.php(973): QuerySet->one()<br />
#12 (racine)/include/class.search.php(905): SavedQueue::counts(Object(StaffSession), true)<br />
#13 (racine)/include/staff/templates/queue-tickets.tmpl.php(111): SavedQueue->getCount(Object(StaffSession))<br />
#14 (racine)/scp/tickets.php(539): require_once('/volume1/web/os...')<br />
#15 {main}
