Closed (won't fix)
Project:
Vocabulary Index
Version:
6.x-2.0-rc2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
6 Dec 2008 at 13:10 UTC
Updated:
6 Dec 2008 at 16:47 UTC
Hi,
this select, which is from Vocabulary Index module:
SELECT distinct(n.nid) FROM term_node t INNER JOIN node n ON t.nid = n.nid WHERE n.status = 1 and t.tid = 2 and n.nid not in (-1,3);
results in:
ERROR 2013 (HY000): Lost connection to MySQL server during query
if I remove the -1, like:
SELECT distinct(n.nid) FROM term_node t INNER JOIN node n ON t.nid = n.nid WHERE n.status = 1 and t.tid = 2 and n.nid not in (3);
then it works fine
this query also works fine:
SELECT distinct(n.nid) FROM term_node t INNER JOIN node n ON t.nid = n.nid WHERE n.status = 1 and t.tid = 2 and n.nid not in (-1);
can you please remove the -1 when it is not required, or can you please tell me what could be wrong with my database..
I have only 16 nodes, so performance can't be a problem.
Comments
Comment #1
xanoThis query isn't executed by Vocabulary Index, so this issue doesn't belong here. I also wouldn't be able to tell you what was wrong if it did, I'm sorry.