Tweet
I created an entity called Expenses, and when I want to createview of the entity's scope, I get the error below. Not sure why
Server side error 200: 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 ') AND expenses.deleted = '0' ORDER BY expenses.created_at DESC LIMIT 0, 5' at line 3
( [controller] => Expenses ) , 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 ') AND expenses.deleted = '0' ORDER BY expenses.created_at DESC LIMIT 0, 5' at line 3 [] [] [2016-02-26 14:34:59] 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 ') AND expenses.deleted = '0' ORDER BY expenses.created_at DESC LIMIT 0, 5' at line 3, Code: 42000 URL: /espocrm/api/v1/Expenses?maxSize=5&offset=0&sortBy=createdAt&asc=f alse&where%5B0%5D%5Btype%5D=primary&where%5B0%5D%5 Bvalue%5D=planned&where%5B1%5D%5Btype%5D=equals&wh ere%5B1%5D%5Bfield%5D=accountId&where%5B1%5D%5Bval ue%5D=565392a3bc859bb99 [] [] [2016-02-26 14:38:27] Espo.ERROR: API [GET]:/:controller, Params:Array
Server side error 200: 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 ') AND expenses.deleted = '0' ORDER BY expenses.created_at DESC LIMIT 0, 5' at line 3
( [controller] => Expenses ) , 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 ') AND expenses.deleted = '0' ORDER BY expenses.created_at DESC LIMIT 0, 5' at line 3 [] [] [2016-02-26 14:34:59] 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 ') AND expenses.deleted = '0' ORDER BY expenses.created_at DESC LIMIT 0, 5' at line 3, Code: 42000 URL: /espocrm/api/v1/Expenses?maxSize=5&offset=0&sortBy=createdAt&asc=f alse&where%5B0%5D%5Btype%5D=primary&where%5B0%5D%5 Bvalue%5D=planned&where%5B1%5D%5Btype%5D=equals&wh ere%5B1%5D%5Bfield%5D=accountId&where%5B1%5D%5Bval ue%5D=565392a3bc859bb99 [] [] [2016-02-26 14:38:27] Espo.ERROR: API [GET]:/:controller, Params:Array
Comment