[Catalyst] C::P::Session::Store::DBIC

[Ivan Wills]

Daniel Westermann-Clark wrote:
> On 2006-11-07 11:03:43 +1000, Ivan Wills wrote:
>   
>> I'm trying to use C::P::Session::Store::DBIC for storing my sessions
>> but I am getting an error due to it apparently using the wrong DBIC
>> module.  Here is a example error:
>>
>> [error] Caught exception in engine
>> "DBIx::Class::ResultSet::find_or_create(): Error executing 'SELECT
>> me.member_role_timestamp, me.member_id, me.role_id FROM member_role
>> me WHERE ( me.session_id = ? )': ERROR: column me.session_id does
>> not exist"
>>     
>
> It looks like the session and authentication configuration is getting
> mixed up somehow.  Check that the $c->config->{session}{dbic_class}
> value corresponds to your session table class and not your user-role
> mapping class.
>   
The $c->config->{session}{dbic_class} points to the DBIC model 
App::Model::DB as per the documentation (and pointing it to the session 
class App::Schema::Session causes a runtime error). Is there some way to 
tell C::P::S::Store::DBIC the correct table to use?

Ivan Wills