Closed (duplicate)
Project:
Nodequeue
Version:
5.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
5 Apr 2008 at 03:36 UTC
Updated:
5 Apr 2008 at 03:54 UTC
The following query
$count = db_result(db_query(db_rewrite_sql("SELECT COUNT(n.*) FROM {node} n INNER JOIN {nodequeue_nodes} nn ON n.nid = nn.nid WHERE nn.sqid = %d AND n.status = 1"), $sqid));
fails for me because of the n.*. The attached patch fixes it with n.nid
$count = db_result(db_query(db_rewrite_sql("SELECT COUNT(n.nid) FROM {node} n INNER JOIN {nodequeue_nodes} nn ON n.nid = nn.nid WHERE nn.sqid = %d AND n.status = 1"), $sqid));
| Comment | File | Size | Author |
|---|---|---|---|
| patch53.patch | 942 bytes | Scott Reynolds |
Comments
Comment #1
Scott Reynolds commentedit appears this was introduced by: http://drupal.org/node/238182 so closing this as a dup and moving my patch over there.