Announcement

Collapse
No announcement yet.

Server error 500 with custom relationship with "user"

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Server error 500 with custom relationship with "user"

    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


Working...
X