[Dbix-class] strange situation, maybe dbix bug

Krzysztof Krzyzaniak eloy at kofeina.net
Fri Jul 14 17:36:39 CEST 2006


I write application in Catalyst in order to learn how to use catalyst
plugins etc. I use Catalyst::Plugin::Authentication with
Catalyst::Plugin::Authentication::Store::DBIC, all source is available
for viewing:

http://kofeina.net/websvn/listing.php?repname=SireCSM&path=%2FSireCSM%2Ftrunk%2Flib%2FSireCSM%2FSchema%2F&rev=0&sc=0

I have defined DBIx::Schema with classes:
Article Account AccountRole AccountRoleMap Feedback, recently I've added
TagMap & Tag, Tag is connected with Account as

__PACKAGE__->might_have('tag_maps' => 'SireCSM::Schema::SireDB::Tag' =>
'account_id'); (I've tried has_many as well).


.. and when I am adding Tag to __PACKAGE__->load_classes() in
SireCSM::Schema::SireDB module, authorization failed with error (with
DBIX_CLASS_STORAGE_DBI_DEBUG=1):

SELECT me.account_id, me.account_role_id FROM account_role_map me WHERE
( login = ? ) (`eloy')
DBD::Pg::st execute failed: ERROR:  column "login" does not exist
SELECT COUNT( * ) FROM account_role_map me WHERE ( login = ? ) (`eloy')
DBD::Pg::st execute failed: ERROR:  column "login" does not exist

I really don't know where bug could be. Why adding Tag.pm to classes
make such strange query. Maybe I've made some typo somewhere but I don't
see where. I need some advice where to look.

-- 
-------e-l-o-y---------------------------e-l-o-y- at -k-o-f-e-i-n-a-.-n-e-t------

       jak to dobrze, że są oceany - bez nich byłoby jeszcze smutniej



More information about the Dbix-class mailing list