SQL Error when viewing user profile

R4tt3xx - September 14, 2009 - 10:35
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)
Description

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

merlinofchaos - September 14, 2009 - 14:02
Status:active» duplicate

http://drupal.org/node/284392

#2

merlinofchaos - September 14, 2009 - 14:03
Status:duplicate» active

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

#3

ezra-g - September 29, 2009 - 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?

#4

R4tt3xx - September 30, 2009 - 06:50

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

#5

ezra-g - September 30, 2009 - 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?

 
 

Drupal is a registered trademark of Dries Buytaert.