Dear Sir,
I am not sure what's the cause of this error. But this error it shows only on one of the user groups, for example, this error it is seen only by the manager. Not anyone else.
"Database Error: 1054 - Unknown column 'e.field_158' in 'order clause'
Query: select e.* from app_entity_22 e where e.id>0 and ((select count(*) from app_entity_22_values as cv where cv.items_id=e.id and cv.fields_id='288' and cv.value in (1,9,11,2)) >0 and (select count(*) from app_entity_22_values as cv where cv.items_id=e.id and cv.fields_id='288' and cv.value in (4,5)) =0 and (FROM_UNIXTIME(e.field_175,'%Y-%m-%d')=date_format(DATE_ADD(now(),INTERVAL 0 DAY),'%Y-%m-%d') or FROM_UNIXTIME(e.field_175,'%Y-%m-%d')=date_format(DATE_ADD(now(),INTERVAL 2 DAY),'%Y-%m-%d') or FROM_UNIXTIME(e.field_175,'%Y-%m-%d')=date_format(DATE_ADD(now(),INTERVAL 3 DAY),'%Y-%m-%d'))) and e.parent_item_id in (select item_id from (select e.id as item_id , ( (select count(*) from app_entity_22 func100 where func100.id>0 and func100.parent_item_id=e.id ) ) as field_342, ( (select SUM(func100.field_174+0) from app_entity_22 func100 where func100.id>0 and func100.parent_item_id=e.id ) - (select SUM(func100.field_173+0) from app_entity_22 func100 where func100.id>0 and func100.parent_item_id=e.id ) ) as field_343 from app_entity_21 e where e.id>0 and ((FROM_UNIXTIME(e.field_159,'%Y-%m-%d')=date_format(DATE_ADD(now(),INTERVAL 0 DAY),'%Y-%m-%d') or FROM_UNIXTIME(e.field_159,'%Y-%m-%d')=date_format(DATE_ADD(now(),INTERVAL 2 DAY),'%Y-%m-%d') or FROM_UNIXTIME(e.field_159,'%Y-%m-%d')=date_format(DATE_ADD(now(),INTERVAL 3 DAY),'%Y-%m-%d')))) as parent_entity_21 ) order by e.field_158 asc,(e.field_159+0) asc,(e.field_337+0) asc,(e.field_242+0) asc
Page: /index.php?module=dashboard/&action=update_hot_reports&reports_id=124"
Kind Regards,
Frankie
Database Field Bug
- Frankriva2003
- Posts: 137
- Joined: 09 Jul 2018, 21:07
- Name: Frankie Rivalde
- Location: Exmouth
- Company Name: Tempus
- Contact:
- Frankriva2003
- Posts: 137
- Joined: 09 Jul 2018, 21:07
- Name: Frankie Rivalde
- Location: Exmouth
- Company Name: Tempus
- Contact:
Re: Database Field Bug
Solved,
One of the reports.
Not to worry
One of the reports.
Not to worry