Tweet
Hello,
I have configured a custom relationship between "contact" and "user". I also included this "user" field in the contact view list. When sorting by "user" I get an error, the log file has: tellpopeyes
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 MySQL server version for the right syntax to use near 'ASC LIMIT 0, 200' at line 1; GET /api/v1/Contact?select=salutationName%2CfirstName%2ClastNa me%2Cname%2Ctitle%2CaccountId%2CaccountName%2Cclie ntFunction%2CclientSegment%2CusersIds%2CusersNames %2CcreatedAt&maxSize=200&offset=0&orderBy=users&or der=asc; line: 132, file: /is/htdocs/xxxxxxxx/www/application/Espo/ORM/DB/Mapper.php [] []
Solution needed.
Regards.
I have configured a custom relationship between "contact" and "user". I also included this "user" field in the contact view list. When sorting by "user" I get an error, the log file has: tellpopeyes
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 MySQL server version for the right syntax to use near 'ASC LIMIT 0, 200' at line 1; GET /api/v1/Contact?select=salutationName%2CfirstName%2ClastNa me%2Cname%2Ctitle%2CaccountId%2CaccountName%2Cclie ntFunction%2CclientSegment%2CusersIds%2CusersNames %2CcreatedAt&maxSize=200&offset=0&orderBy=users&or der=asc; line: 132, file: /is/htdocs/xxxxxxxx/www/application/Espo/ORM/DB/Mapper.php [] []
Solution needed.
Regards.
Comment