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

xen’s picture

Looks like collection is trying to use a field that has been deleted. Try saving the collection settings for the other node types.

xen’s picture

Status: Active » Closed (cannot reproduce)