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

Post Reply
hawkeye
Posts: 20
Joined: 25 Apr 2018, 22:18
Name: Kevin
Location: USA

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

Post by 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

User avatar
support
Site Admin
Posts: 3418
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

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

Post by 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
Posts: 20
Joined: 25 Apr 2018, 22:18
Name: Kevin
Location: USA

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

Post by hawkeye »

Ok thanks Sergey.

Post Reply