Hi, I have a new installation of espocrm, clean without data, when I go to the account I return the error 500, I try to insert a new account but it doesn't save.
This is the log file:
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, 20' at line 1; GET /api/v1/Account?select=name%2Cwebsite%2Ctype%2CbillingAddr essCountry&maxSize=20&offset=0&orderBy=tipologiaAz ienda&order=asc; line: 132, file: /var/www/html/espocrm/application/Espo/ORM/DB/Mapper.php [] []
How can I solve it?
Thanks
This is the log file:
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, 20' at line 1; GET /api/v1/Account?select=name%2Cwebsite%2Ctype%2CbillingAddr essCountry&maxSize=20&offset=0&orderBy=tipologiaAz ienda&order=asc; line: 132, file: /var/www/html/espocrm/application/Espo/ORM/DB/Mapper.php [] []
How can I solve it?
Thanks
Comment