Hi All,
From this morning constantly getting DB Error #1054 emails. There has not been any changes to custom fields which seems to be the most common problem causing DB Error #1054 when i search the forums.
Any assistance would be greatly appreciated!
SELECT COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A2.id IN (3) AND A2.state = 'closed' AND A1.created IS NOT NULL AND A1.est_duedate IS NOT NULL THEN A1.ticket_id END) AS q15, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.state = 'open' AND A2.id IN (1) AND A1.created IS NOT NULL AND A1.est_duedate IS NOT NULL THEN A1.ticket_id END) AS q23, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.state = 'open' AND A2.id IN (1) AND A1.created IS NOT NULL AND A1.est_duedate IS NOT NULL THEN A1.ticket_id END) AS q26, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.isanswered = '0' AND A2.state = 'open' AND A1.isanswered = '0' AND A2.state = 'open' AND A2.id IN (1) AND A1.created IS NOT NULL AND A1.est_duedate IS NOT NULL AND A1.ticket_id = Z1.ticket_id THEN A1.ticket_id END) AS q27, COUNT(DISTINCT CASE WHEN A2.state = 'open' THEN A1.ticket_id END) AS q1, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '0' THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN A1.staff_id IN (1) AND A2.state = 'open' AND A1.staff_id IN (1) AND A2.state = 'open' AND A1.staff_id IN (1) THEN A1.ticket_id END) AS q6, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-06-13 00:00:00' AND '2019-06-13 23:59:59' THEN A1.ticket_id END) AS q9, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '1' THEN A1.ticket_id END) AS q3, COUNT(DISTINCT CASE WHEN A1.staff_id IN (1) AND A2.state = 'open' AND A1.staff_id IN (1) AND A2.state = 'open' AND NOT A1.staff_id IN (1) THEN A1.ticket_id END) AS q7, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-06-12 00:00:00' AND '2019-06-12 23:59:59' THEN A1.ticket_id END) AS q10, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isoverdue = '1' THEN A1.ticket_id END) AS q4, COUNT(DISTINCT CASE WHEN A1.staff_id IN (1) AND A2.state = 'open' THEN A1.ticket_id END) AS q5, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-06-10 00:00:00' AND '2019-06-16 23:59:59' THEN A1.ticket_id END) AS q11, COUNT(DISTINCT CASE WHEN A2.state = 'closed' THEN A1.ticket_id END) AS q8, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-06-01 00:00:00' AND '2019-06-30 23:59:59' THEN A1.ticket_id END) AS q12, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-04-01 00:00:00' AND '2019-06-30 23:59:59' THEN A1.ticket_id END) AS q13, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2019-01-01 00:00:00' AND '2019-12-31 23:59:59' 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_department A6 ON (A4.object_type = 'D' AND A4.object_id = A6.id) WHERE (A2.state = 'open' AND (A1.staff_id = 1 OR A5.staff_id = 1)) OR A1.dept_id IN (2, 4, 5, 6) OR A6.id IN (2, 4, 5, 6)]

Unknown column 'Z1.ticket_id' in 'field list' 
---- Backtrace ---- 
#0 C:\xampp\htdocs\include\mysqli.php(199): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...') 
#1 C:\xampp\htdocs\include\class.orm.php(3455): db_query('SELECT COUNT(DI...', true, true) 
#2 C:\xampp\htdocs\include\class.orm.php(3502): MySqlExecutor->execute() 
#3 C:\xampp\htdocs\include\class.orm.php(2085): MySqlExecutor->getArray() 
#4 C:\xampp\htdocs\include\class.orm.php(2035): HashArrayIterator->{closure}() 
#5 C:\xampp\htdocs\include\class.orm.php(2014): CallbackSimpleIterator->next() 
#6 C:\xampp\htdocs\include\class.orm.php(2023): CallbackSimpleIterator->rewind() 
#7 C:\xampp\htdocs\include\class.orm.php(1695): CallbackSimpleIterator->valid() 
#8 C:\xampp\htdocs\include\class.orm.php(1705): CachedResultSet->fillTo(2147483647) 
#9 C:\xampp\htdocs\include\class.orm.php(1328): CachedResultSet->asArray() 
#10 C:\xampp\htdocs\include\class.orm.php(1351): QuerySet->all() 
#11 C:\xampp\htdocs\include\class.search.php(925): QuerySet->one() 
#12 C:\xampp\htdocs\include\class.search.php(865): SavedQueue::counts(Object(StaffSession), true) 
#13 C:\xampp\htdocs\include\staff\templates\queue-tickets.tmpl.php(96): SavedQueue->getCount(Object(StaffSession)) 
#14 C:\xampp\htdocs\scp\tickets.php(526): require_once('C:\xampp\htdocs...') 
#15 C:\xampp\htdocs\scp\index.php(17): require('C:\xampp\htdocs...') 
#16 {main}