Do you have any suggestions on how to fix?
Thanks
Code: Select all
Database Error: 1054 - Unknown column 'e.field_229' in 'where clause'
Query: select e.* , ( (select (func100.field_314) from app_entity_33 func100 where func100.id>0 and func100.parent_item_id=e.id order by func100.id desc limit 1) ) as field_247, ( (select (func100.field_320) from app_entity_34 func100 where func100.id>0 and func100.parent_item_id=e.id order by func100.id desc limit 1) ) as field_272, ( (select count(*) from app_entity_22 func100 where func100.id>0 and func100.parent_item_id=e.id ) ) as field_292, ( (select count(*) from app_entity_22 func100 where func100.id>0 and (func100.field_169 in (47) ) and func100.parent_item_id=e.id ) ) as field_293, ( (select count(*) from app_entity_22 func100 where func100.id>0 and (func100.field_169 in (49) ) and func100.parent_item_id=e.id ) ) as field_294, ( (select count(*) from app_entity_22 func100 where func100.id>0 and (FROM_UNIXTIME(func100.field_176,'%Y-%m-%d')0) and func100.parent_item_id=e.id ) ) as field_295, ( (select count(*) from app_entity_22 func100 where func100.id>0 and ((FROM_UNIXTIME(func100.field_176,'%Y-%v')=date_format(DATE_ADD(now(),INTERVAL 0 WEEK),'%Y-%v'))) and func100.parent_item_id=e.id ) ) as field_296, ( (select count(*) from app_entity_26 func100 where func100.id>0 and func100.parent_item_id=e.id ) ) as field_297, ( (select count(*) from app_entity_26 func100 where func100.id>0 and ((e.field_229>0 and e.field_229<10)) and func100.parent_item_id=e.id ) ) as field_298, ( (select (func100.field_227) from app_entity_26 func100 where func100.id>0 and (func100.field_245 in (1) ) and func100.parent_item_id=e.id order by func100.id desc limit 1) ) as field_323, ( (select (func100.field_229) from app_entity_26 func100 where func100.id>0 and (func100.field_245 in (1) ) and func100.parent_item_id=e.id order by func100.id desc limit 1) ) as field_324, ( (select (func100.field_230) from app_entity_26 func100 where func100.id>0 and (func100.field_245 in (1) ) and func100.parent_item_id=e.id order by func100.id desc limit 1) ) as field_325, ( (select ((func100.field_230-func100.field_229)) from app_entity_26 func100 where func100.id>0 and (func100.field_245 in (1) ) and func100.parent_item_id=e.id order by func100.id desc limit 1) ) as field_326, ( (select (func100.field_338) from app_entity_35 func100 where func100.id>0 and func100.parent_item_id=e.id order by func100.id desc limit 1) ) as field_332 from app_entity_21 e where id='1'
Page: /rukovoditel/index.php?module=items/info&path=21-1&redirect_to=subentity