System error

error:  Column 'id' in field list is ambiguous at /home/lucy/htdocs/_maketable line 67.
context: 
... 
63:  $prevstr = $pagenum > 1 ? "<a href=$prevpage> <<< </a>" : "";
64:  }
65:  }
66:  $sth = $dbh->prepare($query) || die $dbh->errstr;
67:  $sth->execute(@$args) || die $dbh->errstr;
68: 
69:  $matches = $sth->rows unless($countstr);
70: 
71:  my @rows;
... 
code stack:  /home/lucy/htdocs/_maketable:67
/usr/local/share/perl/5.30.0/HTML/Mason/Component.pm:135
/home/lucy/htdocs/itemlist.html:8
/usr/local/share/perl/5.30.0/HTML/Mason/Component.pm:135
/home/lucy/htdocs/autohandler:9
/usr/local/share/perl/5.30.0/HTML/Mason/Component.pm:135
raw error






























Column 'id' in field list is ambiguous at /home/lucy/htdocs/_maketable line 67.


Trace begun at /usr/local/share/perl/5.30.0/HTML/Mason/Exceptions.pm line 125
HTML::Mason::Exceptions::rethrow_exception('Column \'id\' in field list is ambiguous at /home/lucy/htdocs/_maketable line 67.^J') called at /home/lucy/htdocs/_maketable line 67
Lucy::Production::__ANON__('query', 'select id, icon, name, itemtype, itemclass from ItemDB2,ItemSuffixes where suffix like ? and newest=\'Y\' and id=itemid and ViewLoYMaybe=\'N\'', 'args', 'ARRAY(0x560011bbf268)', 'columns', 'ARRAY(0x560011bb2ba8)', 'options', 'class="sidebar" cellspacing="0" width="100%"', 'showsummary', 1, 'redirectonsingle', 'CODE(0x560011861680)', 'pagesize', 500, 'codesort', 'name') called at /usr/local/share/perl/5.30.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x5600119ecd98)', 'query', 'select id, icon, name, itemtype, itemclass from ItemDB2,ItemSuffixes where suffix like ? and newest=\'Y\' and id=itemid and ViewLoYMaybe=\'N\'', 'args', 'ARRAY(0x560011bbf268)', 'columns', 'ARRAY(0x560011bb2ba8)', 'options', 'class="sidebar" cellspacing="0" width="100%"', 'showsummary', 1, 'redirectonsingle', 'CODE(0x560011861680)', 'pagesize', 500, 'codesort', 'name') called at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 1302
eval {...} at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, 'query', 'select id, icon, name, itemtype, itemclass from ItemDB2,ItemSuffixes where suffix like ? and newest=\'Y\' and id=itemid and ViewLoYMaybe=\'N\'', 'args', 'ARRAY(0x560011bbf268)', 'columns', 'ARRAY(0x560011bb2ba8)', 'options', 'class="sidebar" cellspacing="0" width="100%"', 'showsummary', 1, 'redirectonsingle', 'CODE(0x560011861680)', 'pagesize', 500, 'codesort', 'name') called at /home/lucy/htdocs/itemlist.html line 8
Lucy::Production::__ANON__('searchtext', 'Crystallized Ball of Cosgrove Clay') called at /usr/local/share/perl/5.30.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x56001186def8)', 'searchtext', 'Crystallized Ball of Cosgrove Clay') called at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 1300
eval {...} at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'searchtext', 'Crystallized Ball of Cosgrove Clay') called at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x56000e35ba80)') called at /home/lucy/htdocs/autohandler line 9
Lucy::Production::__ANON__('searchtext', 'Crystallized Ball of Cosgrove Clay') called at /usr/local/share/perl/5.30.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x560011aa2388)', 'searchtext', 'Crystallized Ball of Cosgrove Clay') called at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 1300
eval {...} at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'searchtext', 'Crystallized Ball of Cosgrove Clay') called at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 481
eval {...} at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 481
eval {...} at /usr/local/share/perl/5.30.0/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x56000e35ba80)') called at /usr/local/share/perl/5.30.0/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x56000e35ba80)') called at /usr/local/share/perl/5.30.0/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x560011421318)', 'Apache2::RequestRec=SCALAR(0x560011cdbbb0)') called at (eval 29) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x560011cdbbb0)') called at -e line 0
eval {...} at -e line 0