Hi, Just updated from 1.10 to 1.12 and now in the system logs it is showing a DB Error #1054. How can I fix this?
With this in the details...
[SELECT 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 A2.state
= 'open' AND A2.state
= 'open' AND A1.isanswered
= '1' THEN A1.ticket_id
END) AS q3
, 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.ticket_id
= Z1.ticket_id
THEN A1.ticket_id
END) AS q15
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' THEN A1.ticket_id
END) AS q5
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND (A1.team_id
IN (1, 2) OR 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 (A1.team_id
IN (1, 2) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND (A1.team_id
IN (1, 2) OR 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' THEN A1.ticket_id
END) AS q8
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2019-05-23 04:00:00' AND '2019-05-24 03:59:59' THEN A1.ticket_id
END) AS q9
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2019-05-22 04:00:00' AND '2019-05-23 03:59:59' THEN A1.ticket_id
END) AS q10
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2019-05-20 04:00:00' AND '2019-05-27 03:59:59' THEN A1.ticket_id
END) AS q11
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2019-05-01 04:00:00' AND '2019-06-01 03: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 04:00:00' AND '2019-07-01 03: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 05:00:00' AND '2020-01-01 04: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_team
A6 ON (A4.object_type
= 'E' AND A4.object_id
= A6.team_id
) LEFT JOIN ost_department
A7 ON (A4.object_type
= 'D' AND A4.object_id
= A7.id
) WHERE (A2.state
= 'open' AND (A1.staff_id
= 1 OR A5.staff_id
= 1 OR A1.team_id
IN (1, 2) OR A6.team_id
IN (1, 2))) OR A1.dept_id
IN (1, 2, 3, 4, 5, 6, 7, 8) OR A7.id
IN (1, 2, 3, 4, 5, 6, 7, 8)] Unknown column 'Z1.ticket_id' in 'field list'
---- Backtrace ----
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...')
#1 (root)/include/class.orm.php(3455): db_query('SELECT COUNT(DI...', true, true)
#2 (root)/include/class.orm.php(3502): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2085): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(2035): HashArrayIterator->{closure}()
#5 (root)/include/class.orm.php(2014): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(2023): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1695): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1328): CachedResultSet->asArray()
#10 (root)/include/class.orm.php(1351): QuerySet->all()
#11 (root)/include/class.search.php(925): QuerySet->one()
#12 (root)/scp/autocron.php(51): SavedQueue::counts(Object(StaffSession), false)
#13 {main}