Just installed this module on D6.9, added a rolereference CCK field, and got this error when adding a node:

user warning: Unknown table 'n' in where clause query: SELECT r.rid, r.name FROM role r WHERE (n.language ='he' OR n.language ='' OR n.language IS NULL) AND ( (r.rid = 4 OR r.rid = 5 OR r.rid = 7) )ORDER BY r.name in /modules/rolereference/rolereference.module on line 614

Comments

asak’s picture

asak commented

Please ignore.. i'll check this some more...

cyu’s picture

cyu commented

The code that you referenced is very close to nodereference and userreference, so I'm curious if you are having the same issue with those field types. Were you able to track this down?

asak’s picture

asak commented

Well.. i'm not sure this module can help with what i had in mind so i kind of gave up: I thought about making a view, listing users and their roles, where the role is EDITABLE (using editable fields module) and so the admin can use this view to quickly change user's roles on the fly.

So i thought to add a role reference field to the content type i'm using as a profile, and then listing it in the view for editing

Think that's possible? should it work...?

If it is, i need this module, and so will need to track this down ;)

cyu’s picture

cyu commented
Status: Active » Fixed

This is fixed here: http://drupal.org/cvs?commit=172818

I don't know how this would work with editable fields, but it would not work with only the components you mentioned. Some sort of action would need triggered when a rolereference field on a user profile was changed to actually change a role associated with that user, because the field itself would not do that. You can think of it as a select box which just so happens to be populated with all available roles, but not in any way tied to a user's roles unless done so elsewhere.

Status: Fixed » Closed (fixed)

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