I can't find where my error is while doing the tutorial.

I make it all the way to end of 06 Authorization and suddenly I get errors starting with:

Couldn't render template "books/list.tt2: undef error - search_related: result source 'UserRole' has no such relationship role_id at /usr/lib/perl5/site_perl/5.8.8/DBIx/Class/Schema.pm line 1071

The only difference is I didn't use the code for encrypted passwords and did not encrypt them in the database.

This is on a CentOS 5 Linux-vserver guest and as you can see I haven't put in a newer (more recent) version of Perl.

I have looked to to see if I missed some code and have checked in the database to make sure test01/mypass is in there.

Here are the results of a recursive grep starting at MyApp looking for role_id.

lib/MyApp/Schema/Result/User.pm:110:__PACKAGE__->many_to_many(roles => 'user_roles', 'role_id');
lib/MyApp/Schema/Result/UserRole.pm:32:=head2 role_id
lib/MyApp/Schema/Result/UserRole.pm:43:  "role_id",
lib/MyApp/Schema/Result/UserRole.pm:46:__PACKAGE__->set_primary_key("user_id", "role_id");
lib/MyApp/Schema/Result/UserRole.pm:61:  { id => "role_id" },
lib/MyApp/Schema/Result/Role.pm:60:  { "foreign.role_id" => "self.id" },
myapp02.sql:21: role_id INTEGER REFERENCES role(id) ON DELETE CASCADE ON UPDATE CASCADE,
myapp02.sql:22:                 PRIMARY KEY (user_id, role_id)
Binary file myapp.db matches

Does anything catch your collective eye?

TIA,
Rod
--

_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/

Reply via email to