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.

Comments

zero2one’s picture

Assigned: Unassigned » zero2one
zero2one’s picture

Status: Needs review » Reviewed & tested by the community
zero2one’s picture

Released see: #191510

zero2one’s picture

Status: Reviewed & tested by the community » Fixed
zero2one’s picture

Status: Fixed » Closed (fixed)