SQL Error on Dashboard overview. Error is as follows:
user warning: 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 'd_Join casetracker_case AS b ON (a.nid = b.pid) Inner Join d_node AS d ON ' at line 1 query: SELECT a.nid, c.csid, Count(1) AS numberOfCases FROM d_node AS a Inner d_Join casetracker_case AS b ON (a.nid = b.pid) Inner Join d_node AS d ON (b.vid = d.vid) Inner Join d_casetracker_case_states AS c ON (b.case_status_id = c.csid) WHERE a.type IN ("casetracker_basic_project ") AND a.status = 1 GROUP BY a.nid, c.csid ORDER BY a.title ASC, c.csid ASC in /var/www/html/includes/database.mysqli.inc on line 151.
| Comment | File | Size | Author |
|---|---|---|---|
| casetracker_dashboard_2007103001.patch | 733 bytes | Craig Gardner |
Comments
Comment #1
zero2one commentedComment #2
zero2one commentedComment #3
zero2one commentedReleased see: #191510
Comment #4
zero2one commentedComment #5
zero2one commented