Database Error: 1054 - Unknown column 'e.field_229' in 'where clause'

[hawkeye]

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

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

[support]

There will be version 2.2 soon (2-3 weeks) and if issue still will be after upgrade then we will try to sort out.

[hawkeye]

Ok thanks Sergey.