Tweet
We have a custom entity that gives a "Bad Server Response" any time we try to sort the contact names in the list view. Here is the error I am getting:
[2018-05-11 19:50:41] Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => Assignment ) , InputData: - 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, 100' at line 5 [] []
[2018-05-11 19:50:41] Espo.ERROR: Display Error: 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, 100' at line 5, Code: 42000 URL: /espocrm/api/v1/Assignment?maxSize=100&offset=0&sortBy=contacts&as c=true [] []
[2018-05-11 19:50:41] Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => Assignment ) , InputData: - 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, 100' at line 5 [] []
[2018-05-11 19:50:41] Espo.ERROR: Display Error: 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, 100' at line 5, Code: 42000 URL: /espocrm/api/v1/Assignment?maxSize=100&offset=0&sortBy=contacts&as c=true [] []
Comment