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.

CommentFileSizeAuthor
#1 898990-term-vid_limit-error.patch699 bytesdawehner
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

dawehner’s picture

Status: Active » Needs review
FileSize
699 bytes

Here is a patch for this

merlinofchaos’s picture

Version: 6.x-2.11 » 7.x-3.x-dev
Status: Needs review » Patch (to be ported)

Committed to 6.x-2.x and 6.x-3.x. Needs porting to 7.x

dawehner’s picture

Status: Patch (to be ported) » Fixed

And commited

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.