Hi there
osTicket Version v1.14.1 (f1e9e88)
MySQL Version 5.6.40
PHP Version 7.0.33
Our version is an upgrade from 1.12.5, I believe. We have a slew of these errors in logs, and I have read through and searched similar reports that mention deleting and recreating a queue. However, I am not quite sure WHICH one to do so and why.
OR! If perhaps the actual error is the "unknown column"? Not quite sure, here.
[SELECT COUNT(DISTINCT CASE WHEN A1.topic_id
= 14 AND A1.ticket_id
= Z1.ticket_id
THEN A1.ticket_id
END) AS q17
, COUNT(DISTINCT CASE WHEN A1.topic_id
= 13 THEN A1.ticket_id
END) AS q18
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A2.state
= 'open' AND A2.state
= 'open' AND A1.dept_id
= 4 AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q20
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A2.state
= 'open' AND A2.state
= 'open' AND A1.topic_id
IN (15, 16) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q21
, 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 (2) OR A1.staff_id
IN (2)) AND A2.state
= 'open' AND (A1.team_id
IN (2) OR A1.staff_id
IN (2)) AND A2.state
= 'open' AND A1.staff_id
IN (2) 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 '2020-02-25 05:00:00' AND '2020-02-26 04: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.team_id
IN (2) OR A1.staff_id
IN (2)) AND A2.state
= 'open' AND (A1.team_id
IN (2) OR A1.staff_id
IN (2)) AND A2.state
= 'open' AND NOT A1.staff_id
IN (2) 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 '2020-02-24 05:00:00' AND '2020-02-25 04: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 (2) OR A1.staff_id
IN (2)) 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 '2020-02-24 05:00:00' AND '2020-03-02 04: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 '2020-02-01 05:00:00' AND '2020-03-01 04: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 '2020-01-01 05:00:00' AND '2020-04-01 03: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 '2020-01-01 05:00:00' AND '2021-01-01 04: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
= 2 OR A5.staff_id
= 2 OR A6.object_type
= 'C' AND A8.staff_id
= 2 OR A1.team_id
IN (2) OR B0.team_id
IN (2) OR A6.object_type
= 'C' AND B1.team_id
IN (2))) OR (A2.state
IN ('open', 'closed') AND (A1.dept_id
IN (1, 4, 5) OR B2.id
IN (1, 4, 5))) OR A6.object_type
= 'C' AND B3.id
IN (1, 4, 5))] Unknown column 'Z1.ticket_id' in 'field list'
---- Backtrace ----
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...')
#1 (root)/include/class.orm.php(3459): db_query('SELECT COUNT(DI...', true, true)
#2 (root)/include/class.orm.php(3506): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2093): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(2043): HashArrayIterator->{closure}()
#5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1336): CachedResultSet->asArray()
#10 (root)/include/class.orm.php(1359): QuerySet->all()
#11 (root)/include/class.search.php(973): QuerySet->one()
#12 (root)/include/class.search.php(905): SavedQueue::counts(Object(StaffSession), true)
#13 (root)/include/staff/templates/queue-tickets.tmpl.php(111): SavedQueue->getCount(Object(StaffSession))
#14 (root)/scp/tickets.php(539): require_once('/efs/helpdroid....')
#15 {main}