Database error: Unknown column 'itl_location' in 'field list'
SQL: select inv.icon, inv.typeID, itp.price, kb3_item_types.*, dga.value as techlevel, dc.value as usedcharge, dl.value as usedlauncher, inv.groupID, inv.typeName, inv.capacity, inv.raceID, inv.basePrice, inv.marketGroupID, if(dl.attributeID IS NULL,sum(itd.itd_quantity),truncate(sum(itd.itd_quantity)/count(dl.attributeID),0)) as itd_quantity, itd_itm_id, itd_itl_id, itl_location from kb3_invtypes inv left join kb3_dgmtypeattributes dga on dga.typeID=inv.typeID and dga.attributeID=633 left join kb3_item_price itp on itp.typeID=inv.typeID left join kb3_item_types on inv.groupID=itt_id left join kb3_dgmtypeattributes dc on dc.typeID = inv.typeID AND dc.attributeID IN (128) left join kb3_dgmtypeattributes dl on dl.typeID = inv.typeID AND dl.attributeID IN (137,602) join kb3_items_destroyed itd on inv.typeID = itd_itm_id and itd_kll_id in (77756) left join kb3_item_locations itl on (itd.itd_itl_id = itl.itl_id or (itd.itd_itl_id = 0 and itl.itl_id = 1))group by itd.itd_itm_id, itd.itd_itl_id order by itd.itd_itl_id
ERROR [256] SQL error (Unknown column 'itl_location' in 'field list'
Error on line 46 in file /home/agony/webapps/external_kb/common/includes/class.dbnormalquery.php
PHP 5.3.27 (Linux), EDK 4.0.7.1 (Rubicon 1.3)
File: /home/agony/webapps/external_kb/common/includes/class.dbnormalquery.php, line: 46, function: trigger_error
File: /home/agony/webapps/external_kb/common/includes/class.itemlist.php, line: 134, class: DBNormalQuery, function: execute
File: /home/agony/webapps/external_kb/common/includes/class.itemlist.php, line: 146, class: ItemList, function: execute
File: /home/agony/webapps/external_kb/common/includes/class.kill.php, line: 894, class: ItemList, function: getItem
File: /home/agony/webapps/external_kb/common/includes/class.kill.php, line: 989, class: Kill, function: execQuery
File: /home/agony/webapps/external_kb/common/kill_related.php, line: 90, class: Kill, function: exists
File: /home/agony/webapps/external_kb/common/includes/class.pageassembly.php, line: 70, function: call_user_func_array
File: /home/agony/webapps/external_kb/common/includes/class.pageassembly.php, line: 37, class: pageAssembly, function: call
File: /home/agony/webapps/external_kb/common/kill_related.php, line: 675, class: pageAssembly, function: assemble
File: /home/agony/webapps/external_kb/common/index.php, line: 294, function: include
File: /home/agony/webapps/external_kb/index.php, line: 27, function: include