Database Error: 1054 - Unknown column 'e.field_229' in 'where clause'
Posted: 02 May 2018, 20:03
Hi Sergey. I am running 2.1 and ext 1.7. I'm getting the following error when I apply a filter to one of my formulas. It happens when I try to apply any kind of filter. I'm getting these errors on dashboard, entity 26 info pages, and tasks entity.
Do you have any suggestions on how to fix?
Thanks
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