Advanced Pack : Report arrow folder

[item]

Hello Teams,
espo : 570
advPack : 2.3.14

when we have folder in report.. when we click on arrow for expand folder .. give error 500

https://xxxxxx/api/v1/ReportCategory/action/lastChildrenIdList?parentId=5c8022c01b23eea05

other way, all see work well. de children is expanded.
can not replicate on demo crm.

Regards

[Maximus]

Hello,
It works good on my instance. Check for the error description in the log file located in data/logs/.

[item]

Hello Maximus

[2019-10-04 19:15:46] Espo.ERROR: (42000) SQLSTATE[42000]: Syntax error or access violation: 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 'ASC' at line 1; GET /api/v1/ReportCategory/action/lastChildrenIdList?parentId=5c71e1b13ac509fb3; line: 132, file: /var/www/vhosts/xxxx/htdocs/application/Espo/ORM/DB/Mapper.php [] [] 

This
maybe old version of mariaDB ?

Regards

[Maximus]

>maybe old version of mariaDB?
What MariaDB version do you use?
In EspoCRM v.5.7.0. we have dropped supporting of MySQL v.5.5. Perhaps, this may be a reason of this error.

[item]

Server version: 10.0.38-MariaDB MariaDB Server

[Maximus]

I have made one more test on php7.3. and MariaDB v.10.0.38. Everything is ok.
Try to reproduce this error in the incognito window mode to check whether it is not a cache problem.
You can also open F12 mode, then call the error, and in the 'network' tab find the query to DB.

[item]

Hello Maximus,
i have put log on the mapper and this are result : i think order by and maybe in new version of espo new field createAt or somethink like so ?

[2019-10-07 11:22:42] Espo.WARNING: SELECT report_category.id AS `id`, report_category.name AS `name`, report_category.deleted AS `deleted`, report_category.order AS `order`, report_category.description AS `description`, report_category.created_at AS `createdAt`, report_category.modified_at AS `modifiedAt`, report_category.created_by_id AS `createdById`, TRIM(CONCAT(createdBy.first_name, ' ', createdBy.last_name)) AS `createdByName`, report_category.modified_by_id AS `modifiedById`, TRIM(CONCAT(modifiedBy.first_name, ' ', modifiedBy.last_name)) AS `modifiedByName`, report_category.parent_id AS `parentId`, parent.name AS `parentName` FROM `report_category` LEFT JOIN `report_category` AS `parent` ON report_category.parent_id = parent.id LEFT JOIN `user` AS `modifiedBy` ON report_category.modified_by_id = modifiedBy.id LEFT JOIN `user` AS `createdBy` ON report_category.created_by_id = createdBy.id WHERE (report_category.parent_id = '5c71e80b92030f81f') AND report_category.deleted = '0' ORDER BY  ASC [] [] 

[Maximus]

Could you try to reproduce this error in the KnowladgeBase?
When this error occured?

[item]

Hello Maximus,
I can not reproduce on KnowladgeBase.
only on report .. strange
error only when I click "arrow" in patients/contacts (sample with the printscreen.. but occur in all) category.
Thanks for all

[item]

Hello Maximus,

reproduced on portal.espocrm.com

login portal -> go knowledgeBase -> VoIP Integration -> click arrow .. hehe

Regards

[yuri]

I'll look into.

[item]

resolved with 5.7.1
Thanks Yuri and teams