Hey all,
I've had osticket running for about 8 months now. A few months ago started getting DB Error #1064. Have traced to the Dashboard page, as generates an error every time the dashboard is opened. The page is slow to load and the graph never generates. We never use the dashboard page for our setup/use of osticket, but everytime a user clicks it by mistake I get an error email.

Nothing changed, and graph used to work, now just errors. I have moved to a new permanent server from the test setup and same error.

Any help would be awesome ?

osTicket Version v1.12 (a076918)
Web Server Software Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.15
MySQL Version 10.1.9
PHP Version 5.6.15

DB Error #1064
[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(1557425755) AND FROM_UNIXTIME(1560104155) AND A2.object_type = 'T' AND A1.dept_id IN (7) 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 MariaDB server version for the right syntax to use near ') GROUP BY A1.topic_id' at line 1

---- Backtrace ----
#0 C:\xampp\htdocs\osticket\include\mysqli.php(199): osTicket->logDBError('DB Error #1064', '[SELECT A1.top...') #1 C:\xampp\htdocs\osticket\include\class.orm.php(3455): db_query('SELECT A1.topi...', true, true)
#2 C:\xampp\htdocs\osticket\include\class.orm.php(3502): MySqlExecutor->execute()
#3 C:\xampp\htdocs\osticket\include\class.orm.php(2085): MySqlExecutor->getArray()
#4 C:\xampp\htdocs\osticket\include\class.orm.php(2035): HashArrayIterator->{closure}()
#5 C:\xampp\htdocs\osticket\include\class.orm.php(2014): CallbackSimpleIterator->next()
#6 C:\xampp\htdocs\osticket\include\class.orm.php(2023): CallbackSimpleIterator->rewind()
#7 C:\xampp\htdocs\osticket\include\class.orm.php(1695): CallbackSimpleIterator->valid()
#8 C:\xampp\htdocs\osticket\include\class.orm.php(1705): CachedResultSet->fillTo(2147483647)
#9 C:\xampp\htdocs\osticket\include\class.orm.php(1721): CachedResultSet->asArray()
#10 C:\xampp\htdocs\osticket\include\class.report.php(270): CachedResultSet->getIterator()
#11 C:\xampp\htdocs\osticket\include\staff\dashboard.inc.php(100): OverviewReport->getTabularData('topic')
#12 C:\xampp\htdocs\osticket\scp\dashboard.php(50): require_once('C:\xampp\htdocs...')
#13 {main}