Database Field Bug

Post Reply
Frankriva2003
Posts: 45
Joined: 09 Jul 2018, 21:07
Name: Frankie Rivalde
Location: Exmouth
Company Name: Tempus
Contact:

Database Field Bug

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

Frankriva2003
Posts: 45
Joined: 09 Jul 2018, 21:07
Name: Frankie Rivalde
Location: Exmouth
Company Name: Tempus
Contact:

Re: Database Field Bug

Post by Frankriva2003 » 09 Aug 2018, 14:53

Solved,

One of the reports.
Not to worry

Post Reply