Returning an SQL error on all user pages with both 6.x-6.x-dev and 6.x-0.1-alpha2. I'm running MySQL 5.0.51a on a local host.

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 ') LEFT JOIN nodequeue_subqueue nodequeue_nodes_node__nodequeue_subqueue ON node' at line 4 query: SELECT node.nid AS nid, nodequeue_nodes_node.position AS nodequeue_nodes_node_position FROM node node INNER JOIN nodequeue_nodes nodequeue_nodes_node ON node.nid = nodequeue_nodes_node.nid AND nodequeue_nodes_node.qid IN () LEFT JOIN nodequeue_subqueue nodequeue_nodes_node__nodequeue_subqueue ON nodequeue_nodes_node.qid = nodequeue_nodes_node__nodequeue_subqueue.qid WHERE nodequeue_nodes_node__nodequeue_subqueue.reference = '1' ORDER BY nodequeue_nodes_node_position ASC LIMIT 0, 10 in \sites\all\modules\views\includes\view.inc on line 677.

Comments

dydecker’s picture

dydecker commented
Status: Active » Closed (fixed)

Never mind: it generates this on a fresh install if you've not hook up your queue to a content type. No probs;)

ezra-g’s picture

ezra-g commented

Could you clarify what you mean by "not hook up your queue to a content type?" I'll try to recreate this, but there shouldn't be SQL errors, regardless of configuration.

dydecker’s picture

dydecker commented

I meant add the queue type to the smartqueue_user_users relationship in Views. But looking further into it, there seems to be something wrong with my configuration. I'm getting this SQL error on all smartqueue pages except user/1.

warning: array_intersect() [function.array-intersect]: Argument #2 is not an array in \4\sites\all\modules\nodequeue-6.x-2.0-rc16\nodequeue\nodequeue.module on line 1458.

Nodes associated with smartqueue also have no smartqueue link & generate:


    * warning: array_fill() [function.array-fill]: Number of elements must be positive in C:\wamp\www\4\includes\database.inc on line 240.
    * warning: implode() [function.implode]: Invalid arguments passed in C:\wamp\www\4\includes\database.inc on line 240.
    * 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 ')' at line 1 query: SELECT nq.qid, nq.show_in_tab, nq.show_in_links, show_in_ui FROM nodequeue_queue nq INNER JOIN nodequeue_types nt ON nt.qid = nq.qid INNER JOIN nodequeue_roles nr ON nr.qid = nq.qid WHERE nt.type = 'event' AND nr.rid IN () in \sites\all\modules\nodequeue-6.x-2.0-rc16\nodequeue\nodequeue.module on line 1561.

The user profile pages don't generate the smartqueue title, and instead say 'Nodequeue '' '

I'm going to try deleting nodequeue & smartqueue and starting again. Will report back.

dydecker’s picture

dydecker commented

Uninstalled, deleted all refs to nodequeue & smartqueue in database, reinstalled, now there are no more SQL errors.

dydecker’s picture

dydecker commented
Version: 6.x-1.x-dev » 6.x-0.1-alpha2
Status: Closed (fixed) » Active

Nodequeue is working fine, but when I install Smartqueue, it automatically creates a “Manipulate My Nodequeue” link at user/1 linking to admin/content/nodequeue/%252Fview/. The title of the page is Nodequeue “ (with the quote mark)

When I create a Smartqueue, all user pages link to admin/content/nodequeue/%252Fview/. (Display on user profile pages is checked in settings).

Also, for any user, no links show on the nodes associated with the smartqueue.

Currently all permissions are turned on. Is there something wrong with my configuration? I can’t quite work out what is a bug & what is a settings issue…

ezra-g’s picture

ezra-g commented
Title: SQL syntax error on user pages » Strange alpha behavior

Yikes. Sounds like an alpha release ;). I'll look into this.

ezra-g’s picture

ezra-g commented

I am able to replicate the malformed link that displays at user/1 and the resulting view. However, users with "manipulate queues" and "manipulate my user queue" permissions are able to manipulate their queues in my testing.

Have you verified that the user you are testing has her own queue? If that user does not have a queue, you can create one by editing the user queue at admin/content/nodequeue and specifying 'Create new NodeQueues'.

ezra-g’s picture

ezra-g commented
Status: Active » Fixed

I just committed a fix to both 5.x and 6.x that prevents the 'manipulate my node queue' link from displaying when the user does not have a queue. Please re-open this issue if you are still having the other issue you described.

Anonymous’s picture

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

Automatically closed -- issue fixed for two weeks with no activity.