Jump to:
| Project: | Referenced By Views Filter |
| Version: | 5.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
Thank you for producing this module - it seems to be exactly what I need. The only issue is that I can't seem to get it to work. I tried to follow the steps in the readme but get the following error:
user warning: Unknown table 'node2' in where clause query: SELECT node.nid FROM node node LEFT JOIN content_field_setlist content_field_setlist ON node.nid = content_field_setlist.field_setlist_nid WHERE (node.status = '1') AND (content_field_setlist.nid = 2) AND (node2.vid = content_field_setlist.vid) LIMIT 0, 10 in /home/vughosti/subdomains/omp/includes/database.mysql.inc on line 172.
At this point, I'm assuming that this is an error in my setup rather than a general issue with the module. Let me outline my needs - maybe I'm missing something.
I've created a "concert archive" for a band's community site. The basic setup is that there are two content types: "concert" and "song". Each have their own relevant fields. "Concert" has a "setlist" multi-select node reference field for choosing all of the songs that were played that night. This works great for browsing the setlist archive page. However, what I'd really like to do is provide a listing for every song that shows all the shows that it was played at. I know that this is going to need to be a block - for now I'm trying to get this setup as a page view and arguments as a proof of concept.
Any idea why this isn't working? Perhaps multi references are not supported...
Comments
#1
The error you're describing is definitly not a configuration problem but a module bug.
it sounds like you have the version that requires a patch in the vie wmodule with out the patch.
if it's not the case, (you have the version that works with out the patch), then it's some bug of mine.
I'll check multi reference
hed
#2
@Rick,
If I understand it correctly, for this specific thing you didn't need the module. You need to create a Views:
* Page URL = songs_from_concert
* In the arguments add
node reference:reference_to_song.* Fields = Title, date, location (for example)
* In the filter add
content type = ConcertSo now when user enters
/drupal/songs_from_concret/1then all concerts that have a song with NID 1 will show.Is this what you need?
#3
Hey i have the same error. Do you have a solution? A patch? Pleas!
Is iexactly what I need, but i can't use it.
#4
@dcine,
Can you describe your need, as I didn't get exactly rickbug's one
#5
Should be fixed - http://drupal.org/cvs?commit=93368
#6
Automatically closed -- issue fixed for two weeks with no activity.