Closed (cannot reproduce)
Project:
Collection
Version:
6.x-2.4
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
11 Jan 2011 at 19:33 UTC
Updated:
3 Feb 2011 at 08:08 UTC
While it appears that this module may be working, I am getting this warning whenever it is invoked by viewing a node in a collection:
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 '= 4 AND type = "event" ORDER BY n.nid' at line 1 query: SELECT n.nid FROM content_ JOIN node n USING (nid, vid) WHERE = 4 AND type = "event" ORDER BY n.nid in /var/www/dev.mydomain.com/htdocs/sites/all/modules/collection/collection.module on line 305.
line 305 is this:
result = db_query('SELECT n.nid FROM {' . $table_name . '} JOIN {node} n USING (nid, vid) WHERE ' . $column_name . ' = %d AND type = "%s" ' . $where . ' ORDER BY n.nid', $args);
so it looks like $column_name isn't being populated... which would be odd in any case, since it looks like it's comparing it to an nid, not an actual column name.
Comments
Comment #1
xen commentedLooks like collection is trying to use a field that has been deleted. Try saving the collection settings for the other node types.
Comment #2
xen commented