EDIT: i have also created a github issue: https://github.com/osTicket/osTicket/issues/4795

Hello, we have updated our osTicket from 1.10 to 1.11.
Since this upgrade we get a lot oft DB Errors 1064.

I found this Thread (https://forum.osticket.com/d/93620-resolved-db-error-1064-part-2) but i'm not sure what i need to solve this problem.
It would be great if someone can help me with this problem. Which DB Entrys should i delete?

The Error looks like this:

[SELECT COUNT(DISTINCT CASE WHEN THEN A1.ticket_id END) AS q15, 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-03-14 00:00:00' AND '2019-03-14 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.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-03-13 00:00:00' AND '2019-03-13 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.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-03-11 00:00:00' AND '2019-03-17 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-03-01 00:00:00' AND '2019-03-31 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-01-01 00:00:00' AND '2019-03-31 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_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) OR A7.id IN (1)] 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 A2.state = 'open' ' at line 1

---- Ablaufverfolgung ----
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1064', '[SELECT COUNT(D...')
#1 (root)/include/class.orm.php(3454): db_query('SELECT COUNT(DI...', true, true)
#2 (root)/include/class.orm.php(3501): 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(922): QuerySet->one()
#12 (root)/include/class.search.php(865): SavedQueue::counts(Object(StaffSession), true)
#13 (root)/include/staff/templates/queue-tickets.tmpl.php(96): SavedQueue->getCount(Object(StaffSession))
#14 (root)/scp/tickets.php(525): require_once('/var/www/html/s...')
#15 (root)/scp/index.php(17): require('/var/www/html/s...')
#16 {main}