Tweet
Hi,
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 logfile has:
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 [] []
Any ideas?
Thanks!
Christoph
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 logfile has:
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 [] []
Any ideas?
Thanks!
Christoph