I upgraded from Version 1.10.1 to 1.11 and keep getting these email warnings every 10 minutes or so. Besides this the system seems to work smooth. Any ideas why? Thanks!
SELECT COUNT(DISTINCT CASE WHEN THEN A1.ticket_id
END) AS q15
, COUNT(DISTINCT CASE WHEN A1.dept_id
= 10 THEN A1.ticket_id
END) AS q16
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A2.state
= 'open' AND A2.state
= 'open' THEN A1.ticket_id
END) AS q17
, COUNT(DISTINCT CASE WHEN A2.state
= 'open' AND A2.state
= 'open' AND A2.state
= 'open' THEN A1.ticket_id
END) AS q18
, 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.team_id
IN (4) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND (A1.team_id
IN (4) 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 A2.state
= 'closed' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2019-02-19 10:00:00' AND '2019-02-20 09: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.team_id
IN (4) OR A1.staff_id
IN (1)) AND A2.state
= 'open' AND (A1.team_id
IN (4) 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' AND A2.state
= 'closed' AND A1.closed
BETWEEN '2019-02-18 10:00:00' AND '2019-02-19 09: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.team_id
IN (4) OR 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-02-18 10:00:00' AND '2019-02-25 09: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-02-01 10:00:00' AND '2019-03-01 09: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-01-01 10:00:00' AND '2019-04-01 08: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 10:00:00' AND '2020-01-01 09: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 (4) OR A6.team_id
IN (4))) OR A1.dept_id
IN (1, 13, 14, 10, 4, 7, 8, 11, 12) OR A7.id
IN (1, 13, 14, 10, 4, 7, 8, 11, 12)]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN A1.ticket_id
END) AS q15
, COUNT(DISTINCT CASE WHEN A1.dept_id
= 10 TH' at line 1<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1064', '[SELECT COUNT(D...')<br />
#1 (root)/include/class.orm.php(3454): db_query('SELECT COUNT(DI...', true, true)<br />
#2 (root)/include/class.orm.php(3501): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2085): MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(2035): HashArrayIterator->{closure}()<br />
#5 (root)/include/class.orm.php(2014): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(2023): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1695): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1705): CachedResultSet->fillTo(9223372036854775807)<br />
#9 (root)/include/class.orm.php(1328): CachedResultSet->asArray()<br />
#10 (root)/include/class.orm.php(1351): QuerySet->all()<br />
#11 (root)/include/class.search.php(922): QuerySet->one()<br />
#12 (root)/include/class.search.php(865): SavedQueue::counts(Object(StaffSession), true)<br />
#13 (root)/include/staff/templates/queue-tickets.tmpl.php(96): SavedQueue->getCount(Object(StaffSession))<br />
#14 (root)/scp/tickets.php(525): require_once('/home/phandbook...')<br />
#15 {main}