Unknown Table n user warning when assigning user role [#572422]

There is a problem in the sql query in the to_do.module. When I click on the user role to assign a user I get:

user warning: Unknown table 'n' in where clause query: SELECT u.uid, u.name FROM users as u JOIN users_roles as r ON u.uid = r.uid WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL) AND ( r.rid = 3 AND u.status = 1) in XYZ/modules/to_do/to_do.module on line 1586.

Comments

Comment #1

jday commented 25 November 2009 at 03:46

here is the error I get when assigning a user (I've made the to-do node a group node - using organic groups - which does not function properly either):

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT u.uid, u.name FROM users as u JOIN users_roles as r ON u.uid = r.uid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 45 AND na.realm = 'og_subscriber'))) AND ( r.rid = 3 AND u.status = 1) in /sites/all/modules/to_do/to_do.module on line 1586.

Comment #2

tribalrose commented 5 December 2009 at 02:42

I get similar sql query errors when any type of user access module is active. So far Site notes, Content Access, Node Access, Workflow Access all conflict with To do list.