Closed (duplicate)
Project:
Spaces
Version:
6.x-2.0-beta3
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
19 Aug 2009 at 15:23 UTC
Updated:
2 Jul 2010 at 19:29 UTC
When I tried to create a view that filtered nodes by term and by space (using a vocabulary for my spaces), I found that I was not seeing any nodes. Upon further digging, I discovered that the following query was being constructed (I was able to see this query by going to edit the view and prefacing the URL with the appropriate space term name):
SELECT node.nid AS nid
FROM node node
LEFT JOIN term_node term_node ON node.vid = term_node.vid
WHERE (node.type in ('page')) AND (term_node.tid = 1) AND (term_node.tid = 7)
It should be doing this:
SELECT node.nid AS nid
FROM node node
INNER JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_node term_node2 ON node.vid = term_node2.vid AND term_node2.tid != 7
WHERE (node.type in ('page')) AND (term_node.tid = 7) AND (term_node2.tid = 1)
I'm not really sure at present how to go about fixing this, but I may dig around a bit and see if a patch becomes immediately obvious.
Comments
Comment #1
mnlund commentedI don't know if this is related but in 6.x-3.0-beta3 I found that space SID is used to create the views filter.
Take a look here to see if it's worth checking: http://drupal.org/node/776230
Comment #2
jmiccolis commentedWe're no longer maintaining the 2.x branch, and as no one has volunteered to take it over it's being deprecated. As this has been address in 3.x I'm setting the issue to 'duplicate'.