FS::Model::Items can't SELECT FROM items WHERE address = ? AND zip = ? : DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM items WHERE address = '170 W. 15th St.' AND zip = '10011'' at line 2 [for Statement "SELECT FROM items WHERE address = ? AND zip = ? " with ParamValues: 0='170 W. 15th St.', 1='10011'] at /Library/Perl/5.8.8/DBIx/ContextualFetch.pm line 52. at /Library/Perl/5.8.8/Class/DBI/Search/Basic.pm line 169 #### # within FS::Model::Items->new(); $self->table('items'); $self->columns( qw/item item_type name lng lat zip url phone fax address/ ); #### # within FS::Model::Items->get_info my $item = $self->search( address => $item_info->{address}, zip => $item_info->{zip}, ); #### my $item_obj = FS::Model::Items->new(); my $res_obj = $item_obj->get_info($item_info); #### package FS::Model::Items; use Object::InsideOut qw(FS::Model::DBI); #### package FS::Model::DBI; use base ( Class::DBI ); use Object::InsideOut;