Hello everybody,

after we Updated our osTicket from 1.10 to 1.11 we have problems with the LDAP Plugin from the Website. After we searched a new one and Installed MultiLDAP Plugin for the usage of our AD Logins we have some servial problems with osTicket, the Login works normally but the System creats the DB-Error #1064.

Here is the Message from the system (german):
[SELECT COUNT(DISTINCT CASE WHEN A1.dept_id = 1 THEN A1.ticket_id END) AS q17, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND A1.dept_id = 1 THEN A1.ticket_id END) AS q18, COUNT(DISTINCT CASE WHEN THEN A1.ticket_id END) AS q20, 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 A2.state = 'open' AND A1.dept_id = 1 THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN (A1.team_id IN (3) OR A1.staff_id IN (4)) AND A2.state = 'open' AND (A1.team_id IN (3) OR A1.staff_id IN (4)) AND A2.state = 'open' AND A1.staff_id IN (4) AND A2.state = 'open' THEN A1.ticket_id END) AS q6, COUNT(DISTINCT CASE WHEN (A1.team_id IN (3) OR A1.staff_id IN (4)) AND A2.state = 'open' THEN A1.ticket_id END) AS q5, 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 A2.state IN ('closed', 'archived', 'deleted') 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 = 4 OR A5.staff_id = 4 OR A1.team_id IN (3) OR A6.team_id IN (3))) OR A1.dept_id IN (1, 3) OR A7.id IN (1, 3)]

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 q20, COUNT(DISTINCT CASE WHEN A2.state = 'open' ' at line 1<br /> <br />
---- Ablaufverfolgung ----<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)/scp/autocron.php(51): SavedQueue::counts(Object(StaffSession), false)<br />
#13 {main}

Here the informations about the osTicket:
osTicket-Version: 1.11 (d4e240b)
Server-Version: Apache
MySQL-Version: 5.7.25
PHP-Version: 7.2.17
MultiLDAP-Version: 1.2.2

Kind regdards,
André