Closed (duplicate)
Project:
Project issue tracking
Version:
5.x-1.3
Component:
Miscellaneous
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
14 Mar 2008 at 09:31 UTC
Updated:
14 Mar 2008 at 11:22 UTC
Module works fine, except id I click on the statistics link. I get immediately this:
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 'DISTINCT(n.nid), pn.title, p.sid, COUNT(n.nid) AS total FROM node n INNER JOIN p' at line 1 query: SELECT p DISTINCT(n.nid), pn.title, p.sid, COUNT(n.nid) AS total FROM node n INNER JOIN project_issues p ON n.nid = p.nid INNER JOIN node pn ON p.pid = pn.nid WHERE n.status = 1 AND pn.status = 1 GROUP BY pn.nid, p.sid, pn.title in C:\apache\htdocs\paseo11\includes\database.mysql.inc on line 172.
Comments
Comment #1
aclight commentedDuplicate of #172035: Error getting statistics on project issues.