System error
error: | Column 'id' in field list is ambiguous at /home/lucy/htdocs/_maketable line 67. |
||||||||||||||||||||||
context: |
|
||||||||||||||||||||||
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 |
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(0x55ba2eb83068)', 'columns', 'ARRAY(0x55ba2b314108)', 'options', 'class="sidebar" cellspacing="0" width="100%"', 'showsummary', 1, 'redirectonsingle', 'CODE(0x55ba2e8d8b40)', '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(0x55ba2ea7e8a0)', 'query', 'select id, icon, name, itemtype, itemclass from ItemDB2,ItemSuffixes where suffix like ? and newest=\'Y\' and id=itemid and ViewLoYMaybe=\'N\'', 'args', 'ARRAY(0x55ba2eb83068)', 'columns', 'ARRAY(0x55ba2b314108)', 'options', 'class="sidebar" cellspacing="0" width="100%"', 'showsummary', 1, 'redirectonsingle', 'CODE(0x55ba2e8d8b40)', '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(0x55ba2eb83068)', 'columns', 'ARRAY(0x55ba2b314108)', 'options', 'class="sidebar" cellspacing="0" width="100%"', 'showsummary', 1, 'redirectonsingle', 'CODE(0x55ba2e8d8b40)', 'pagesize', 500, 'codesort', 'name') called at /home/lucy/htdocs/itemlist.html line 8 Lucy::Production::__ANON__('searchtext', 'of leaves') called at /usr/local/share/perl/5.30.0/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x55ba2e8897d8)', 'searchtext', 'of leaves') 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', 'of leaves') 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(0x55ba2ed01dc8)') called at /home/lucy/htdocs/autohandler line 9 Lucy::Production::__ANON__('searchtext', 'of leaves') called at /usr/local/share/perl/5.30.0/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x55ba2eaf9f98)', 'searchtext', 'of leaves') 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', 'of leaves') 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(0x55ba2ed01dc8)') 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(0x55ba2ed01dc8)') called at /usr/local/share/perl/5.30.0/HTML/Mason/ApacheHandler.pm line 825 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x55ba2e5022a0)', 'Apache2::RequestRec=SCALAR(0x55ba2ed32df0)') called at (eval 29) line 8 HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x55ba2ed32df0)') called at -e line 0 eval {...} at -e line 0