When I add a field to my view of type "Taxonomy: All Terms", one of the options is "Limit terms by vocabulary". When I check this, it opens up a list of vocabularies for me to specify. If I save the view without selecting any specific vocabularies, 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 ') ORDER BY td.weight, td.name' at line 1 query: SELECT tn.vid AS node_vid, td.*, v.name as vocabulary FROM term_data td INNER JOIN term_node tn ON td.tid = tn.tid INNER JOIN vocabulary v ON v.vid = td.vid WHERE tn.vid IN (1295) AND td.vid IN () ORDER BY td.weight, td.name in [...]/sites/all/modules/views/modules/taxonomy/views_handler_field_term_node_tid.inc on line 85.
I get a similar error every time I try to display the view. Seems like the UI just needs to require you to pick at least one vocab.
Comment | File | Size | Author |
---|---|---|---|
#1 | 898990-term-vid_limit-error.patch | 699 bytes | dawehner |
Comments
Comment #1
dawehnerHere is a patch for this
Comment #2
merlinofchaos CreditAttribution: merlinofchaos commentedCommitted to 6.x-2.x and 6.x-3.x. Needs porting to 7.x
Comment #3
dawehnerAnd commited