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;