Hi - we have had an install of OSticket for several years, and just this week we are getting DB Error 1054 errors every six minutes while one particular user is logged into the system. The rest of the time we don't see them, and we are not sure what is causing this. This user doesn't appear to be doing anything abnormal. We have OSticket version 1.14.1, running on an Ubuntu 16.04 server with PHP 7.0.33. Here is the email of the error that we are getting:
[SELECT COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND B4.choices
IS NOT NULL AND A2.state
= 'open' AND B4.choices
IS NOT NULL AND A1.isoverdue
= '1' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q16
, COUNT(DISTINCT CASE WHEN A1.ticket_id
= Z1.ticket_id
THEN A1.ticket_id
END) AS q17
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND B4.choices
IS NOT NULL AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q1
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (2) OR A1.staff_id
IN (66)) AND A2.state
= 'open' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q5
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (2) OR A1.staff_id
IN (66)) AND A2.state
= 'open' AND (A1.team_id
IN (2) OR A1.staff_id
IN (66)) AND A2.state
= 'open' AND A1.staff_id
IN (66) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q6
, COUNT(DISTINCT CASE WHEN (A1.team_id
IN (2) OR A1.staff_id
IN (66)) AND A2.state
= 'open' AND (A1.team_id
IN (2) OR A1.staff_id
IN (66)) AND A2.state
= 'open' AND NOT A1.staff_id
IN (66) AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q7
, 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 '2021-01-12 00:00:00' AND '2021-01-12 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q9
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2021-01-11 00:00:00' AND '2021-01-11 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q10
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2021-01-11 00:00:00' AND '2021-01-17 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q11
, COUNT(DISTINCT CASE WHEN A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2021-01-01 00:00:00' AND '2021-01-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 '2021-01-01 00:00:00' AND '2021-03-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 '2021-01-01 00:00:00' AND '2021-12-31 23:59:59' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q14
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND B4.choices
IS NOT NULL AND A2.state
= 'open' AND B4.choices
IS NOT NULL AND A1.isanswered
= '1' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q3
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND B4.choices
IS NOT NULL AND A2.state
= 'open' AND B4.choices
IS NOT NULL AND A1.isanswered
= '0' AND A3.object_type
= 'T' THEN A1.ticket_id
END) AS q2
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
) LEFT JOIN ost_ticket__cdata
B4 ON (A1.ticket_id
= B4.ticket_id
) WHERE ((A2.state
= 'open' AND (A1.staff_id
= 66 OR A5.staff_id
= 66 OR A6.object_type
= 'C' AND A8.staff_id
= 66 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) OR B2.id
IN (1))) OR A6.object_type
= 'C' AND B3.id
IN (1))]
Unknown column 'Z1.ticket_id' in 'field list'<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(D...')<br />
#1 (root)/include/class.orm.php(3459): db_query('SELECT COUNT(DI...', true, true)<br />
#2 (root)/include/class.orm.php(3506): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2093): MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(2043): HashArrayIterator->{closure}()<br />
#5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)<br />
#9 (root)/include/class.orm.php(1336): CachedResultSet->asArray()<br />
#10 (root)/include/class.orm.php(1359): QuerySet->all()<br />
#11 (root)/include/class.search.php(973): QuerySet->one()<br />
#12 (root)/scp/autocron.php(43): SavedQueue::counts(Object(StaffSession), false)<br />
#13 {main}
Any ideas on what is causing this?
Thanks,
Rett Walters