SQL Error when viewing user profile
| Project: | Smartqueue Per User |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
I get the following SQL error when trying to access a users profile
"
* 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 ') LEFT JOIN nodequeue_subqueue nodequeue_nodes_node__nodequeue_subqueue ON node' at line 3 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid 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.sqid = nodequeue_nodes_node__nodequeue_subqueue.sqid WHERE nodequeue_nodes_node__nodequeue_subqueue.reference = '1' ) count_alias in E:\wamp\www\proof\sites\all\modules\views\includes\view.inc on line 729.
* 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 ') LEFT JOIN nodequeue_subqueue nodequeue_nodes_node__nodequeue_subqueue ON node' at line 4 query: SELECT DISTINCT(node.nid) AS nid, 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.sqid = nodequeue_nodes_node__nodequeue_subqueue.sqid WHERE nodequeue_nodes_node__nodequeue_subqueue.reference = '1' ORDER BY ASC LIMIT 0, 10 in E:\wamp\www\proof\sites\all\modules\views\includes\view.inc on line 755."
I am using MySql version 5.1.33, PHP Version 5.2.9-2, Apache version 2.2.11.
I am also using the Automatic Nodetitles module version 6.x-1.2.
Thanks for the help, I look forward to your response

#1
http://drupal.org/node/284392
#2
Oh wait, I swear the query in the email was different from the one posted here. Ignore #1.
#3
I'm not immediately sure why you'd be getting this error when viewing user profiles.
Are you using smartqueue_users.module? Do you have nodequeue set to interact with user profiles in any way?
#4
I am using the smartqueue_user modules. No, I don't think that it is set to interact.
#5
Ok, I'm moving this issue over to the proper queue. What version of the module are you using?