We are running MySQL 5.7.26 and PHP 7.0.33
Upgraded from 1.10.4 to 1.10.7 with no problem... then when we upgraded to 1.12.2 with a fresh download from the distro we get the same #1604:
[SELECT A1.topic_id AS topic_id, A3.topic AS topic__topic, A3.flags AS topic__flags, COUNT(CASE WHEN A1.event_id = 1 THEN 1 END) AS Opened, COUNT(CASE WHEN A1.event_id = 4 THEN 1 END) AS Assigned, COUNT(CASE WHEN A1.event_id = 8 THEN 1 END) AS Overdue, COUNT(CASE WHEN A1.event_id = 2 THEN 1 END) AS Closed, COUNT(CASE WHEN A1.event_id = 3 THEN 1 END) AS Reopened, COUNT(CASE WHEN A1.event_id = 14 THEN 1 END) AS Deleted FROM ost_thread_event A1 JOIN ost_thread A2 ON (A1.thread_id = A2.id) LEFT JOIN ost_help_topic A3 ON (A1.topic_id = A3.topic_id) WHERE A1.annulled = 0 AND A1.timestamp BETWEEN FROM_UNIXTIME(1563454808) AND FROM_UNIXTIME(1566133208) AND A2.object_type = 'T' AND A1.dept_id IN (1) AND A1.topic_id > 0 AND A1.topic_id IN () GROUP BY A1.topic_id] 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 ') GROUP BY A1.topic_id' at line 1
---- Backtrace ----
#0 (root)/include/mysqli.php(199): osTicket->logDBError('DB Error #1064', '[SELECT A1.top...')topi...', true, true)
#1 (root)/include/class.orm.php(3455): db_query('SELECT A1.
#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(1721): CachedResultSet->asArray()
#10 (root)/include/class.report.php(270): CachedResultSet->getIterator()
#11 (root)/include/staff/dashboard.inc.php(100): OverviewReport->getTabularData('topic')
#12 (root)/scp/dashboard.php(50): require_once('/Applications/M...')
#13 {main}
