Hi
I have osTicket 1.17.5 with php 8.0.20 and mysql 8.0.26. I am getting DB error #1054 with different messages. Not sure how to work it out.
some are like
//------------------
[SELECT COUNT(*) FROM (SELECT A1.ticket_id FROM ost_ticket A1 JOIN ost_ticket_status A2 ON (A1.status_id = A2.id) WHERE A2.id IN (3) AND A1.dept_id = 9 AND NOT (A1.team_id = 0 AND A1.staff_id = 0) AND A1.created IS NOT NULL AND A1.closed IS NOT NULL AND A1.thread_count = 1) __]
Unknown column 'A1.thread_count' in 'where clause'<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(224): osTicket->logDBError()<br />
#1 (root)/include/class.orm.php(3482): db_query()<br />
#2 (root)/include/class.orm.php(3538): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2964): MySqlExecutor->getRow()<br />
#4 (root)/include/class.orm.php(1381): MySqlCompiler->compileCount()<br />
#5 (root)/include/class.search.php(910): QuerySet->count()<br />
#6 (root)/include/class.search.php(1012): SavedQueue->getTotal()<br />
#7 (root)/include/class.search.php(918): SavedQueue::counts()<br />
#8 (root)/include/staff/templates/queue-tickets.tmpl.php(124): SavedQueue->getCount()<br />
#9 (root)/scp/tickets.php(569): require_once('/var/www/html/t...')<br />
#10 {main}
--------------///
some are
//--------------------
[SELECT COUNT(DISTINCT CASE WHEN A2.id IN (3) AND A1.dept_id = 9 AND NOT (A1.team_id = 0 AND A1.staff_id = 0) AND A1.created IS NOT NULL AND A1.closed IS NOT NULL AND A1.thread_count = 1 THEN A1.ticket_id END) AS q21, COUNT(DISTINCT CASE WHEN A2.id IN (3) AND A1.dept_id = 9 AND NOT (A1.team_id = 0 AND A1.staff_id = 0) AND A1.created IS NOT NULL AND A1.closed IS NOT NULL AND A1.thread_count > 1 THEN A1.ticket_id END) AS q22, 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 (41) AND A2.state = 'open' AND A1.staff_id IN (41) AND A2.state = 'open' AND A1.staff_id IN (41) 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 '2023-11-20 00:00:00' AND '2023-11-20 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 (41) AND A2.state = 'open' AND A1.staff_id IN (41) AND A2.state = 'open' AND NOT A1.staff_id IN (41) 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 '2023-11-19 00:00:00' AND '2023-11-19 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 (41) 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 '2023-11-20 00:00:00' AND '2023-11-26 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 NOT (A1.team_id = 0 AND A1.staff_id = 0) AND A2.state = 'closed' AND A1.closed BETWEEN '2023-11-01 00:00:00' AND '2023-11-30 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 '2023-10-01 00:00:00' AND '2023-12-31 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 '2023-01-01 00:00:00' AND '2023-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 = 41 OR A5.staff_id = 41 OR A6.object_type = 'C' AND A8.staff_id = 41)) OR (A2.state IN ('open', 'closed') AND (A1.dept_id IN (5, 6, 7, 8, 9, 10) OR B0.id IN (5, 6, 7, 8, 9, 10))) OR A6.object_type = 'C' AND B1.id IN (5, 6, 7, 8, 9, 10))]
Unknown column 'A1.thread_count' in 'field list'<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(224): osTicket->logDBError()<br />
#1 (root)/include/class.orm.php(3482): db_query()<br />
#2 (root)/include/class.orm.php(3529): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2104): MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(2054): HashArrayIterator->{closure}()<br />
#5 (root)/include/class.orm.php(2033): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(2042): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1713): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1723): CachedResultSet->fillTo()<br />
#9 (root)/include/class.orm.php(1337): CachedResultSet->asArray()<br />
#10 (root)/include/class.orm.php(1360): QuerySet->all()<br />
#11 (root)/include/class.search.php(1009): QuerySet->one()<br />
#12 (root)/include/class.search.php(918): SavedQueue::counts()<br />
#13 (root)/include/staff/templates/queue-tickets.tmpl.php(124): SavedQueue->getCount()<br />
#14 (root)/scp/tickets.php(569): require_once('/var/www/html/t...')<br />
#15 {main}
------------------//
Can someone guide me to the right direction please?
Thanks
