Closed (fixed)
Project:
Drupal core
Version:
5.2
Component:
mysql database
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
15 Oct 2007 at 22:25 UTC
Updated:
19 Feb 2008 at 15:28 UTC
I get this error when clicking on statistics link in project-issues.
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 /opt/drupal/includes/database.mysql.inc on line 172.
does this have to do with the version of MySQL that i am running?
Comments
Comment #1
ricabrantes commentedNo activity, Close..