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
Error showing on dashboard
- support
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Error showing on dashboard
File from archive replace to modules\items\actions\
Let me know if issue is fixed.
Let me know if issue is fixed.
- Attachments
-
- actions.zip
- (2.23 KiB) Downloaded 78 times
-
- 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
Yes that fixed the issue thanks