I have a VBO view which has three exposed taxonomy filters. Maximum number of results if no filter is used is around 2000 nodes. pagination is 25 results per page.

If I don't filter the list and select all the results VBO operations works fine.

If I filter the list and the result fits on one page (i.e. less than 25 results) VBO operations works fine with all results selected

If I filter the list and the result is more than one page (i.e. more than 25 results) but I only select the first page of results VBO works fine.

If I filter the list and the result is on more than one page (i.e. more than 25 results) but I select ALL the results VBO spits out the following error.

user warning: Unknown column 'term_node_value_0.tid' in 'where clause' query: SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node_data_field_resource_author.field_resource_author_value AS node_data_field_resource_author_field_resource_author_value, node_data_field_resource_author.nid AS node_data_field_resource_author_nid, node.type AS node_type, node.vid AS node_vid, node.created AS node_created FROM node node LEFT JOIN content_type_resource node_data_field_resource_author ON node.vid = node_data_field_resource_author.vid WHERE (node.type in ('resource')) AND (term_node_value_0.tid = 6) ORDER BY node_created DESC in /var/www/sites/all/modules/views/includes/view.inc on line 735.

The above error was only using one taxonomy filter.

Any help with this would be greatly appreciated.

Comments

infojunkie’s picture

Assigned: Unassigned » infojunkie

Thanks for your report I'll take a look at the problem.

infojunkie’s picture

Some questions:
* Which taxonomy filter are you using? Taxonomy: Term or Taxonomy: Vocabulary?
* Does it happen *only* when you select all? Which select all: is it the checkbox in the header or the "select across pages" button?
* At which stage does it happen? Right after you click the Execute button or later on in the process?

In the mean time, I am trying to reproduce that bug here.

infojunkie’s picture

Status: Active » Fixed

I've checked in a fix in the latest dev version - you'll have to wait for 12 hours or pull from DRUPAL-6--1 to get it. Please try it and let me know.

arvinsingla’s picture

Sorry for the delayed reply. I have tried the latest dev version out and it seems to be working great. Thank you so very much for the quick response and fix! Much appreciated.

Status: Fixed » Closed (fixed)
Issue tags: -taxonomy, -pagination

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