I try the role reference and got the following message when creating a content that have a role reference field.

user warning: Unknown column 'n.language' in 'where clause' query: SELECT r.rid, r.name FROM role r WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( (r.rid = 1 OR r.rid = 2 OR r.rid = 3) )ORDER BY r.name in /var/www/html/sites/all/modules/rolereference/rolereference.module on line 614.

I am quite new to drupal. Can advice what I should do?

Comments

cyu’s picture

cyu commented
Assigned: Unassigned » cyu

db_rewrite_sql is being used where it should not be. It made sense when it was used in nodereference module, but should be replaced by a simple db_query here in the rolereference module.

cyu’s picture

cyu commented

Fixed by deekayen in latest commit, http://drupal.org/cvs?commit=207220

If the views integration code ends up not breaking anything I'll make a release, in the meantime this will be fixed when the next dev is packaged up.

cyu’s picture

cyu commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

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

ycwjjjj’s picture

ycwjjjj commented
Version: 6.x-1.0 » 6.x-1.x-dev

user warning: Unknown column 'n.language' in 'where clause' query: SELECT name FROM role WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( rid = 4) in E:\xampp\htdocs\drupal2\sites\all\modules\rolereference\rolereference.module on line 410.

I have some of this errors when using 6.x-1.0 version. And some errors have gone when using 6.x-1.x-dev, however, there is still one similar error not fixing as the above.
fix from #2 seems not the exact code in 6.x-1.x-dev, should I apply the fix?