SQL Error when viewing user profile [#576804]

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

Comments

Comment #1

merlinofchaos CreditAttribution: merlinofchaos commented 14 September 2009 at 14:02

Status:

Active

» Closed (duplicate)

http://drupal.org/node/284392

Comment #2

merlinofchaos CreditAttribution: merlinofchaos commented 14 September 2009 at 14:03

Status:

Closed (duplicate)

» Active

Oh wait, I swear the query in the email was different from the one posted here. Ignore #1.

Comment #3

ezra-g CreditAttribution: ezra-g commented 29 September 2009 at 16:28

Title:	SQL Issue	» SQL Error when viewing user profile
Status:	Active	» Postponed (maintainer needs more info)

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?

Comment #4

R4tt3xx CreditAttribution: R4tt3xx commented 30 September 2009 at 06:50

I am using the smartqueue_user modules. No, I don't think that it is set to interact.

Comment #5

ezra-g CreditAttribution: ezra-g commented 30 September 2009 at 16:55

Project:	Nodequeue	» Smartqueue Per User
Version:	6.x-2.4	» 6.x-2.x-dev

Ok, I'm moving this issue over to the proper queue. What version of the module are you using?

Comment #6

markevans CreditAttribution: markevans commented 13 January 2010 at 18:50

Version:

6.x-2.x-dev

» 6.x-0.1-alpha2

I have just installed this module and am experiencing the same problem.

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 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 /htdocs/test/sites/all/modules/views/includes/view.inc on line 739.

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 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 /htdocs/test/sites/all/modules/views/includes/view.inc on line 765.

I am using 6.x-0.1-alpha2