[Dbix-class] No such column

[Sebastian Willert]

On Wed, 2007-09-12 at 15:49 -0600, Craig wrote:
> Hi:
> The program has several tables that each have a primary key that 
> initially gave me the same error. Eventually I was left with one last 
> field that ultimately doesn't make sense.
> 
> The error is:
> DBIx::Class::Schema::throw_exception( ) : 
> DBIx::Class::ResultSourceProxy::set_primary_key( ) : No such column 
> job_id on table job_search at DB/Main/jobsearch.pm line 6
> Compilation  failed in require at (eval 14) line 3.
> Compilation  failed in require at jobsearch.pl line 1.
> BEGIN failed--compilation aborted at jobsearch.pll line 1.
> 
> I've verified numerous times that all the fields match with what's in 
> the mysql database schema.
> I've also verified that all modules are named properly including case 
> sensitivity.

Do you by chance have your set_primary_key call before the actual
add_columns?

Having the source for your module would be a great benefit in hunting
bugs there, by the way ;)

Cheers,
  Sebastian