Sorry, just to post the error for any one of you to refer:DB Error # 1064
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
'\"created\" THEN 1 ELSE 0 END) AS Opened,
SUM(CASE WHEN A1.state = \' at line 2<br /> <br />
---- Backtrace ----<br />
#0
C:\xampp\htdocs\CrownTechSupport\include\mysqli.php(126):
osTicket->logDBError('DB Error #1064', '[SELECT CONCAT_...')<br />
#1
C:\xampp\htdocs\CrownTechSupport\include\ajax.reports.php(133):
db_query('SELECT CONCAT_W...')<br />
#2 C:\xampp\htdocs\CrownTechSupport\include\ajax.reports.php(159):
OverviewReportAjaxAPI->getData()<br />
#3 :
OverviewReportAjaxAPI->getTabularData()<br />
#4
C:\xampp\htdocs\CrownTechSupport\include\class.dispatcher.php(140):
call_user_func_array(Array, Array)<br />
#5
C:\xampp\htdocs\CrownTechSupport\include\class.dispatcher.php(38):
UrlMatcher->dispatch('table', Array)<br />
#6
C:\xampp\htdocs\CrownTechSupport\include\class.dispatcher.php(118):
Dispatcher->resolve('table', Array)<br />
#7 C:\xampp\htdocs\CrownTechSupport\include\class.dispatcher.php(38):
UrlMatcher->dispatch('/report/overvie...', NULL)<br />
#8 C:\xampp\htdocs\CrownTechSupport\scp\ajax.php(99):
Dispatcher->resolve('/report/overvie...')<br />
#9 {main}