Closed (fixed)
Project:
Nodequeue
Version:
5.x-1.2-beta
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Anonymous (not verified)
Created:
19 Jun 2007 at 18:47 UTC
Updated:
25 Mar 2017 at 20:41 UTC
The query that retrieves the eligible queues for a given node doesn't work unless it happens that your content type is named "nq."
$result = db_query(
"SELECT nq.qid, nq.title, nq.size, MAX(nqn.position) AS num_nodes " .
"FROM {nodequeue_queue} nq " .
"INNER JOIN {nodequeue_types} nt ON nt.qid = nq.qid " .
"LEFT JOIN {nodequeue_nodes} nqn ON nqn.qid = nq.qid " . $roles_join .
"WHERE nt.type = '%s' " . $roles_where .
"GROUP BY nq.qid ORDER BY nq.title", 'nq', 'qid', array_merge(array($node->type), $roles));
last line should be:
"GROUP BY nq.qid ORDER BY nq.title", array_merge(array($node->type)));
yes?
Comments
Comment #1
merlinofchaos commentedComment #2
merlinofchaos commentedIt seems this change has already been made.
Comment #3
(not verified) commented