A Database Error OccurredError Number: 1222The used SELECT statements have a different number of columnsSELECT * FROM ((SELECT * FROM (`tcp_shop`) JOIN `item_db2` ON `item_db2`.`id`=`tcp_shop`.`item_id`) UNION (SELECT * FROM (`tcp_shop`) JOIN `item_db_re` ON `item_db_re`.`id`=`tcp_shop`.`item_id`)) a ORDER BY `name_japanese` asc LIMIT 0, 10Filename: F:AppServwwwcorasystemdatabaseDB_driver.phpLine Number: 330
Code:
A Database Error OccurredError Number: 1222The used SELECT statements have a different number of columnsSELECT * FROM ((SELECT * FROM (`tcp_shop`) JOIN `item_db2` ON `item_db2`.`id`=`tcp_shop`.`item_id`) UNION (SELECT * FROM (`tcp_shop`) JOIN `item_db_re` ON `item_db_re`.`id`=`tcp_shop`.`item_id`)) a ORDER BY `name_japanese` asc LIMIT 0, 10Filename: F:AppServwwwcorasystemdatabaseDB_driver.phpLine Number: 330
Solved. Just adding Bindonequip to item_db2
In
application/controller/shop.php
if(isset($_GET['cat'])) { switch($_GET['cat']) { case 'consume': $cond = array('index'=>'item_db.type','val'=>array(0,2,11,18)); break; case 'head': $cond = array('index'=>'equip_locations','val'=>array(1,256,257,512,513,768,769)); break; case 'weapon': $cond = array('index'=>'item_db.type','val'=>array(5)); break; case 'shield': $cond = array('index'=>'equip_locations','val'=>array(32)); break; case 'armor': $cond = array('index'=>'equip_locations','val'=>array(16)); break; case 'robe': $cond = array('index'=>'equip_locations','val'=>array(4)); break; case 'shoes': $cond = array('index'=>'equip_locations','val'=>array(64)); break; case 'accessories': $cond = array('index'=>'equip_locations','val'=>array(8,128,136)); break; case 'pets': $cond = array('index'=>'item_db.type','val'=>array(7,8)); break; case 'cards': $cond = array('index'=>'item_db.type','val'=>array(6)); break; case 'costumes': $cond = array('index'=>'equip_locations','val'=>array(1024,2048,3072,4096,5120,6144,7168,8192)); case 'misc': $cond = array('index'=>'item_db.type','val'=>array(3,10)); break; } }
Change for:
if(isset($_GET['cat'])) { switch($_GET['cat']) { case 'consume': $cond = array('index'=>'type','val'=>array(0,2,11,18)); break; case 'head': $cond = array('index'=>'equip_locations','val'=>array(1,256,257,512,513,768,769)); break; case 'weapon': $cond = array('index'=>'type','val'=>array(5)); break; case 'shield': $cond = array('index'=>'equip_locations','val'=>array(32)); break; case 'armor': $cond = array('index'=>'equip_locations','val'=>array(16)); break; case 'robe': $cond = array('index'=>'equip_locations','val'=>array(4)); break; case 'shoes': $cond = array('index'=>'equip_locations','val'=>array(64)); break; case 'accessories': $cond = array('index'=>'equip_locations','val'=>array(8,128,136)); break; case 'pets': $cond = array('index'=>'type','val'=>array(7,8)); break; case 'cards': $cond = array('index'=>'type','val'=>array(6)); break; case 'costumes': $cond = array('index'=>'equip_locations','val'=>array(1024,2048,3072,4096,5120,6144,7168,8192)); case 'misc': $cond = array('index'=>'type','val'=>array(3,10)); break; } }