Hello, after some modification of fields in "Accounts" I have Bad server response in the list.
log file shows:
[2020-03-21 09:47:12] Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => Account ) , 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, 50' at line 8 [] []
[2020-03-21 09:47:12] 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, 50' at line 8, Code: 42000 URL: /api/v1/Account?select=name%2CshippingAddressCity%2Cshippi ngAddressState%2CshippingAddressCountry&maxSize=50 &offset=0&orderBy=customerrating&order=asc&wher e%5 B0%5D%5Btype%5D=textFilter&where%5B0%5D%5Bvalue%5D =%25 [] []
I also removed all modifications I made but didn't help
before it was:
[2020-03-21 09:48:18] Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => Account ) , 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, 50' at line 8 [] []
[2020-03-21 09:48:18] 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, 50' at line 8, Code: 42000 URL: /api/v1/Account?select=name%2Ccustomerpersrank%2CshippingA ddressCity%2CshippingAddressState%2CshippingAddres sCountry&maxSize=50&offset=0&orderBy=customerratin g&order=asc&where%5B0%5D%5Btype%5D=textFilter&wher e%5B0%5D%5Bvalue%5D=%25 [] []
Can I get a help with it please?
EspoCRM Vers 5.5.3
Made Rebuild & Clear Cache - didn't help
log file shows:
[2020-03-21 09:47:12] Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => Account ) , 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, 50' at line 8 [] []
[2020-03-21 09:47:12] 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, 50' at line 8, Code: 42000 URL: /api/v1/Account?select=name%2CshippingAddressCity%2Cshippi ngAddressState%2CshippingAddressCountry&maxSize=50 &offset=0&orderBy=customerrating&order=asc&wher e%5 B0%5D%5Btype%5D=textFilter&where%5B0%5D%5Bvalue%5D =%25 [] []
I also removed all modifications I made but didn't help
before it was:
[2020-03-21 09:48:18] Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => Account ) , 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, 50' at line 8 [] []
[2020-03-21 09:48:18] 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, 50' at line 8, Code: 42000 URL: /api/v1/Account?select=name%2Ccustomerpersrank%2CshippingA ddressCity%2CshippingAddressState%2CshippingAddres sCountry&maxSize=50&offset=0&orderBy=customerratin g&order=asc&where%5B0%5D%5Btype%5D=textFilter&wher e%5B0%5D%5Bvalue%5D=%25 [] []
Can I get a help with it please?
EspoCRM Vers 5.5.3
Made Rebuild & Clear Cache - didn't help
Comment