Description of the problem

If Forum Access is enabled, taxonomy terms are not visible in Views exposed filter drop down. I managed to pin-point this issue to Forum Access, please find steps to reproduce below.

Steps to reproduce

  • Install clean Drupal 6 (tested: 6.24) and Views (tested: 6.x-2.16)
  • Create a vocabulary (in this example Colors) and create some terms (e.g. Blue, Green, Yellow, Red)
  • Create some content and add the colors to the content
  • Create a page view, set a filter for Taxonomy: term id and expose it so that user can filter the view by color
  • See screenshot of the working scenario: dropdown-populated-normally.PNG
  • Note how this works as expected for both admin and anonymour users.

Now, let's install ACL and Forum access and see how this bug is triggered.

  • Install ACL (tested: 6.x-1.4) and Forum Access (tested: 6.x-1.7)
  • Once Forum Access is enabled, the exposed filter drop down doesn't show any taxonomy terms to anonymous users (nor authenticated users, it only works for admin who bypasses all access checks)
  • See a screenshot: dropdown-terms-missing.PNG

If you disable Forum Access but leave ACL enabled, the bug is not triggered. It is clear that Forum Access that triggers this.

CommentFileSizeAuthor
dropdown-terms-missing.PNG7.94 KBmasipila
dropdown-populated-normally.PNG9.09 KBmasipila

Comments

salvis’s picture

salvis
he/his
commented
Title: Forum access conflicts with Views: taxonomy terms not showing in exposed filter drop down » Views 2.x bug: taxonomy terms not showing in exposed taxonomy filter drop down
Status: Active » Closed (works as designed)

This is a bug in Views 6.x-2.16.

Change line 118 of views/modules/taxonomy/views_handler_filter_term_node_tid.inc from

          $result = db_query(db_rewrite_sql("SELECT * FROM {term_data} t WHERE t.vid = %d ORDER BY t.weight, t.name", 't', 'tid'), $vocabulary->vid);

to

          $result = db_query(db_rewrite_sql("SELECT t.* FROM {term_data} t WHERE t.vid = %d ORDER BY t.weight, t.name", 't', 'tid'), $vocabulary->vid);

i.e. add t.
 

Views 6.x-3.x-dev does not have this issue.

iwasnet’s picture

iwasnet commented

thx,

this worked for me too!

best regards
iwasnet