Main

  • warning: pg_query() [function.pg-query]: Query failed: ERROR: ORDER BY "changed" is ambiguous in /Library/WebServer/communityos/cms/includes/database.pgsql.inc on line 146.
  • user warning: query: SELECT DISTINCT(n.nid), n.title, n.sticky, n.type, nr.teaser, nr.format, pip.issues, MAX(prn.file_date) AS changed, n.changed AS changed FROM node n INNER JOIN node_revisions nr ON n.vid = nr.vid INNER JOIN project_projects p ON n.nid = p.nid LEFT JOIN term_node r ON n.nid = r.nid INNER JOIN project_issue_projects pip ON n.nid = pip.nid INNER JOIN project_release_nodes prn ON n.nid = prn.nid INNER JOIN project_release_projects prp ON n.nid = prp.nid WHERE ((n.type NOT IN ('project_issue'))) AND ( n.status = 1 AND r.tid = 2 AND prp.releases = 1 ) GROUP BY n.nid ORDER BY changed DESC, n.sticky DESC, n.title ASC LIMIT 30 OFFSET 0 in /Library/WebServer/communityos/cms/includes/database.pgsql.inc on line 165.