I have recently taken over a role and we use OsTicket but im not overly familiar with the setup. We started getting errors sent to the admin email stating DB Error #1504. I was wondering if anyone has come across this or can look at the log file attached. Thanks in advance.
[SELECT COUNT(DISTINCT CASE WHEN A2.id
IN (1) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q15
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q16
, COUNT(DISTINCT CASE WHEN A1.topic_id
IN (13, 14) AND A2.state
= 'open' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q17
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A1.staff_id
= 11 THEN A1.ticket_id
END) AS q19
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A2.state
= 'closed' AND A1.staff_id
= 11 AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q28
, COUNT(DISTINCT CASE WHEN A1.topic_id
= 16 AND A2.state
= 'open' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q55
, COUNT(DISTINCT CASE WHEN A1.topic_id
= 15 AND A2.state
= 'open' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q56
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.topic_id
= 16 AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q58
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.dept_id
= 7 AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q72
, COUNT(DISTINCT CASE WHEN A2.id
IN (26) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q82
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.staff_id
IN (11) AND A1.topic_id
IN (1, 14) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q86
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.staff_id
IN (13) AND A1.topic_id
IN (1, 14) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q87
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.staff_id
IN (9) AND A1.topic_id
IN (1, 14) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q88
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A1.staff_id
IN (10) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q89
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A1.staff_id
IN (14) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q90
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A2.state
= 'open' AND A1.topic_id
IN (1, 14) AND A1.staff_id
IN (20) AND A1.ticket_id
= Z1.ticket_id
AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q127
, 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.team_id
IN (1, 4) OR A1.staff_id
IN (11)) AND A2.state
= 'open' AND (A1.team_id
IN (1, 4) OR A1.staff_id
IN (11)) AND A2.state
= 'open' AND A1.staff_id
IN (11) 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-05-12 00:00:00' AND '2022-05-12 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q9
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (1, 4) OR A1.staff_id
IN (11)) AND A2.state
= 'open' AND (A1.team_id
IN (1, 4) OR A1.staff_id
IN (11)) AND A2.state
= 'open' AND NOT A1.staff_id
IN (11) 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-05-11 00:00:00' AND '2022-05-11 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.team_id
IN (1, 4) OR A1.staff_id
IN (11)) 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-05-09 00:00:00' AND '2022-05-15 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-05-01 00:00:00' AND '2022-05-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-04-01 00:00:00' AND '2022-06-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_team
B0 ON (A4.object_type
= 'E' AND A4.object_id
= B0.team_id
) LEFT JOIN ost_team
B1 ON (A7.object_type
= 'E' AND A7.object_id
= B1.team_id
) LEFT JOIN ost_department
B2 ON (A4.object_type
= 'D' AND A4.object_id
= B2.id
) LEFT JOIN ost_department
B3 ON (A7.object_type
= 'D' AND A7.object_id
= B3.id
) WHERE ((A2.state
= 'open' AND (A1.staff_id
= 11 OR A5.staff_id
= 11 OR A6.object_type
= 'C' AND A8.staff_id
= 11 OR A1.team_id
IN (1, 4) OR B0.team_id
IN (1, 4) OR A6.object_type
= 'C' AND B1.team_id
IN (1, 4))) OR (A2.state
IN ('open', 'closed') AND (A1.dept_id
IN (1, 7) OR B2.id
IN (1, 7))) OR A6.object_type
= 'C' AND B3.id
IN (1, 7))]
Unknown column 'Z1.ticket_id' in 'field list'<br /> <br />
---- Backtrace ----<br />
#0 C:\xampp\htdocs\osTicket\upload\include\mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...')<br />
#1 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(3459): db_query('SELECT COUNT(DI...', true, true)<br />
#2 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(3506): MySqlExecutor->execute()<br />
#3 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(2093): MySqlExecutor->getArray()<br />
#4 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(2043): HashArrayIterator->{closure}()<br />
#5 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(2022): CallbackSimpleIterator->next()<br />
#6 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(2031): CallbackSimpleIterator->rewind()<br />
#7 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(1703): CallbackSimpleIterator->valid()<br />
#8 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)<br />
#9 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(1336): CachedResultSet->asArray()<br />
#10 C:\xampp\htdocs\osTicket\upload\include\class.orm.php(1359): QuerySet->all()<br />
#11 C:\xampp\htdocs\osTicket\upload\include\class.search.php(973): QuerySet->one()<br />
#12 C:\xampp\htdocs\osTicket\upload\include\ajax.search.php(397): SavedQueue::counts(Object(StaffSession), true, Array)<br />
#13 C:\xampp\htdocs\osTicket\upload\include\class.dispatcher.php(145): SearchAjaxAPI->collectQueueCounts()<br />
#14 C:\xampp\htdocs\osTicket\upload\include\class.dispatcher.php(38): UrlMatcher->dispatch('counts', Array)<br />
#15 C:\xampp\htdocs\osTicket\upload\include\class.dispatcher.php(120): Dispatcher->resolve('counts', Array)<br />
#16 C:\xampp\htdocs\osTicket\upload\include\class.dispatcher.php(38): UrlMatcher->dispatch('/queue/counts', NULL)<br />
#17 C:\xampp\htdocs\osTicket\upload\scp\ajax.php(308): Dispatcher->resolve('/queue/counts')<br />
#18 {main}
mail.jensen.com.au:4000/osticket/upload