Active
Project:
NodeReferrer
Version:
5.x-1.x-dev
Component:
User interface
Priority:
Critical
Category:
Task
Assigned:
Unassigned
Reporter:
Created:
14 Jul 2008 at 17:01 UTC
Updated:
1 Jan 2009 at 21:15 UTC
Hallo,
Nodereferrer seems is exactly what I need for our school website.
Now I try to create a view that lists all exercises of a class.
Ok, now in I only want to create a view that catches the Nodes of type exercise that refer to class with node:id 131, I added the filters node:type=exercise and nodereferrer:field_exercises_used_in_class.
But I get this error
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 ''131') LIMIT 0, 10' at line 1 query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed FROM node node WHERE (nodereferrer.nid in '131') LIMIT 0, 10 in ...
This query cannot work because of WHERE (nodereferrer.nid in '131'), the syntax is wrong and nodereferrer is no table??
Any guess?
thx in advance
Comments
Comment #1
pixelpreview@gmail.com commentedhello
do you have find a solution to your problem ? I have the same issue and I don't understand where the query is changed in nodereferrer module...
Comment #2
Ghostthinker commentedNo, I gave up...
Comment #3
pixelpreview@gmail.com commentedthanks I follow my investigations...