[Catalyst] "Unknown column 'me.role'" error

[Dustin Suchter]

Yup - that was it!! I have no idea when I introduced that error in
my code, but it is fixed and working now. I also think I get why the
SQL was selecting "me.role" -> because I had the User class in place
of the role class. I does "map_user_role.role" in the correct case.

Thanks Charlie and Jason.

Jason Kohles wrote:
> On Sep 7, 2007, at 3:22 PM, Dustin Suchter wrote:
> 
>> Unfortunately I thought of that one already, and the two do match.
>> Here's the useful YAML and below is the useful SQL just to double
>> check. I believe the underlying MySQL engine is 4.1.
>>
>> # cat adblue.yml | grep -v "\s*#"
>> ---
>> name: AdBlue
>> authentication:
>>     dbic:
>>         user_class: AdBlueDB::User
>>         user_field: username
>>         password_field: password
>> authorization:
>>     dbic:
>>         role_class: AdBlueDB::User
> 
> I think you meant AdBlueDB::Role for the role_class...
> 
>>         role_field: role
>>         role_rel: map_user_role
>>         user_role_user_field: user_id
>>
>