Database Field Bug
Posted: 09 Aug 2018, 14:46
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
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