Posted by Josh Waihi on September 30, 2009 at 10:01pm
| Project: | Node Comments |
| Version: | 6.x-2.0-beta3 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
this query failed in PostgreSQL because it lacks a GROUP BY clause which is required when using a ORDER BY:
SELECT COUNT(*) FROM node_comments nc INNER JOIN node n ON n.nid = nc.cid WHERE nc.thread <= '' AND n.status <> 0 AND n.nid != 122 AND nc.nid = 121 ORDER BY nc.thread ASC;However, where counting here, not trying to retrive particular columns, so why are we even bothering with ordering the returned dataset. It merely slows the query.
Comments
#1
Yep, the query doesn't make sense.
#2
Please try this patch.
#3
#4
Automatically closed -- issue fixed for 2 weeks with no activity.