Export template error
Posted: 02 Mar 2021, 03:42
Hi we are getting the following error in an export template when adding a sub entity report to the template (works fine in other templates?)
Database Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'select id from app_entity_57 where parent_item_id in (select id from app_enti...' at line 1
Query: select e.* from app_entity_70 e where e.id>0 and e.parent_item_id in (select id from app_entity_68 where parent_item_id in (4196))select id from app_entity_57 where parent_item_id in (select id from app_entity_39 where parent_item_id in ( and e.parent_item_id in (select e.id from app_entity_68 e where e.id>0 and e.parent_item_id in (select item_id from (select e.id as item_id , ( (select MAX(func100.field_1193+0) from app_entity_60 func100 where func100.id>0 and (func100.field_1511 in (723) ) and func100.parent_item_id=e.id ) ) as field_1513, ( (select MAX(func100.field_1686+0) from app_entity_68 func100 where func100.id>0 and func100.parent_item_id=e.id ) ) as field_1690, ( (select count(*) from app_entity_41 func100 where func100.id>0 and (func100.field_463 not in (277,232,271,182,212,112,188,297,213,187,216,171,166,169,167,303,302,301,170) ) and func100.parent_item_id=e.id ) ) as field_767, ( (select count(*) from app_entity_60 func100 where func100.id>0 and func100.parent_item_id=e.id ) ) as field_1539 from app_entity_34 e where e.id>0 and e.parent_item_id in (select e.id from app_entity_57 e where e.id>0 and e.parent_item_id in (select item_id from (select e.id as item_id , (e.field_1611) as field_1616 from app_entity_39 e where e.id>0 ) as parent_entity_39 ))) as parent_entity_34 ))
Page: /Property/index.php?module=items/export_template&path=39-35/57-25/34-4196/68-1&templates_id=4
Database Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'select id from app_entity_57 where parent_item_id in (select id from app_enti...' at line 1
Query: select e.* from app_entity_70 e where e.id>0 and e.parent_item_id in (select id from app_entity_68 where parent_item_id in (4196))select id from app_entity_57 where parent_item_id in (select id from app_entity_39 where parent_item_id in ( and e.parent_item_id in (select e.id from app_entity_68 e where e.id>0 and e.parent_item_id in (select item_id from (select e.id as item_id , ( (select MAX(func100.field_1193+0) from app_entity_60 func100 where func100.id>0 and (func100.field_1511 in (723) ) and func100.parent_item_id=e.id ) ) as field_1513, ( (select MAX(func100.field_1686+0) from app_entity_68 func100 where func100.id>0 and func100.parent_item_id=e.id ) ) as field_1690, ( (select count(*) from app_entity_41 func100 where func100.id>0 and (func100.field_463 not in (277,232,271,182,212,112,188,297,213,187,216,171,166,169,167,303,302,301,170) ) and func100.parent_item_id=e.id ) ) as field_767, ( (select count(*) from app_entity_60 func100 where func100.id>0 and func100.parent_item_id=e.id ) ) as field_1539 from app_entity_34 e where e.id>0 and e.parent_item_id in (select e.id from app_entity_57 e where e.id>0 and e.parent_item_id in (select item_id from (select e.id as item_id , (e.field_1611) as field_1616 from app_entity_39 e where e.id>0 ) as parent_entity_39 ))) as parent_entity_34 ))
Page: /Property/index.php?module=items/export_template&path=39-35/57-25/34-4196/68-1&templates_id=4