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 >> > _______________________________________________ List: Catalyst@lists.rawmode.org Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/ Dev site: http://dev.catalyst.perl.org/