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));
CommentFileSizeAuthor
patch53.patch942 bytesScott Reynolds

Comments

Scott Reynolds’s picture

Status: Needs review » Closed (duplicate)

it appears this was introduced by: http://drupal.org/node/238182 so closing this as a dup and moving my patch over there.