Proposals view issues warning for all user roles except admin

StevenK - February 20, 2008 - 12:28
Project:Democracy forum
Version:5.x-1.x-dev
Component:Code
Category:support request
Priority:normal
Assigned:Unassigned
Status:active
Description

I am using the latest Drupal (5.7) and supporting modules. I have installed the module, the supporting modules and the installation profile. When i am logged in as admin and go to the forum, everything is fine. If i log in as a different user/role, i get the error:

user warning: Unknown column 'term_node_2.name' in 'field list' query: SELECT DISTINCT(node.nid), term_data.weight AS term_data_weight, term_data.name AS term_data_name, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, term_node_2.name AS term_node_2_name FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid INNER JOIN users users ON node.uid = users.uid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access') OR (na.gid = 4 AND na.realm = 'term_access'))) AND ( (node.status = '1') AND (node.type IN ('proposal')) ) ORDER BY term_data_weight ASC, term_data_name ASC, node_changed_changed ASC LIMIT 0, 10 in /var/www/www.greekliberalsbe/includes/database.mysql.inc on line 172.

and no Proposals are displayed, although the Arguments are displayed just fine. Having googled it a bit, i found out that this is probably due to the view not being updated, ie 'term_node_2.name' was not updated to the proper term.

The solution is to clear the cache just in case, and save the view to update it. I had to save all the views, but it worked. After adding some roles i had the same issue again, and this time saving the views again did not solve the problem.

I posted this incident as a bug in "Democracy Forum installation profile" but I am posting it here since it might be more appropriate.

Any ideas?

StevenK

 
 

Drupal is a registered trademark of Dries Buytaert.