Hi, when opening the contact list EspoCRM shows an error in the upper part. Looking into the logs I find:
[2019-08-13 18:00:14] 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 'DESC LIMIT 0, 10' at line 1; GET /espo-crm/api/v1/Contact?select=salutationName%2CfirstName%2ClastNa me%2Cname&maxSize=10&offset=0&orderBy=users&order= desc&where%5B0%5D%5Btype%5D=primary&where%5B0%5D%5 Bvalue%5D=all [] []
Any ideas? Everything seems to be correct in the GUI
[2019-08-13 18:00:14] 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 'DESC LIMIT 0, 10' at line 1; GET /espo-crm/api/v1/Contact?select=salutationName%2CfirstName%2ClastNa me%2Cname&maxSize=10&offset=0&orderBy=users&order= desc&where%5B0%5D%5Btype%5D=primary&where%5B0%5D%5 Bvalue%5D=all [] []
Any ideas? Everything seems to be correct in the GUI
Comment