Seeing sql errors for the automatically created/enabled nodequeue view. Error occurs when trying to view or 'add' (from views admin page).

Other than that and wanting to be able to make queues on a per-user basis - looks great.

Comments

Caleb G2’s picture

Caleb G2 commented

Here is the error when I go to:
/nodequeue/1

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN (''))' at line 1 query: SELECT count(node.nid) FROM node node LEFT JOIN nodequeue_nodes nodequeue_nodes ON node.nid = nodequeue_nodes.nid WHERE (.sqid IN ('')) in /Library/WebServer/Documents/drupal5_1/includes/database.mysql.inc on line 172.

Here is the error I get when I go to:
admin/build/views/add/nodequeue_1

warning: Invalid argument supplied for foreach() in /Library/WebServer/Documents/drupal5_1/includes/form.inc on line 948.

sdecabooter’s picture

sdecabooter commented

I have the same problem.
This seems to be caused by the filter in the view (nodequeue.views.inc line 220), because when i click the 'Add' link for the view, the Filters field that gets added doesn't show properly (Operator is an empty dropdown and there's no Value dropdown).

I tried a few things to get the Filter showing properly, but no luck so far...

jeff veit’s picture

jeff veit commented

I can confirm this error. The workaround: go to the View, edit it, delete the filter. Then Add a filter, choosing to filter on nodequeue is the same as your queue name.

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Fixed

This is fixed in -dev and will be in rc2! Thanks for the reports!

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)