Error showing on dashboard

Any critical bugs will be fixed within 24-48 hours.
Post Reply
rmcdonald
Investor
Investor
Posts: 417
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud
Contact:

Error showing on dashboard

Post by rmcdonald »

I am getting the following error on the main dashboard after upgrade (was working fine before)

The error is showing up in an entity listing / table on the dash

Database Error: 1052 - Column 'parent_id' in where clause is ambiguous
Query: select count(e.id) as total from app_entity_30 e left join app_fields_choices fc0 on fc0.id=e.field_259 where e.id>0 and (e.field_259 not in (83,84) and (select count(*) from app_entity_30_values as cv where cv.items_id=e.id and cv.fields_id='261' and cv.value in (36)) >0) and e.parent_item_id in (select item_id from (select e.id as item_id , ( (select SUM(func100.field_304+0) from app_entity_32 func100 where func100.id>0 and func100.id in (select cv.value from app_entity_21_values cv where cv.fields_id='423' and cv.items_id=e.id)) ) as field_421, ( (select SUM(func100.field_304+0) from app_entity_32 func100 where func100.id>0 and func100.id in (select cv.value from app_entity_21_values cv where cv.fields_id='423' and cv.items_id=e.id)) ) as field_497 from app_entity_21 e where e.id>0 ) as parent_entity_21 ) and parent_id=0 order by fc0.sort_order asc, fc0.name asc
Page: /index.php?module=items/listing
User avatar
support
Site Admin
Posts: 6222
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Error showing on dashboard

Post by support »

File from archive replace to modules\items\actions\
Let me know if issue is fixed.
Attachments
actions.zip
(2.23 KiB) Downloaded 78 times
rmcdonald
Investor
Investor
Posts: 417
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud
Contact:

Re: Error showing on dashboard

Post by rmcdonald »

Yes that fixed the issue thanks
Post Reply