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] => Expense ) , 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 expense.deleted = '0' ORDER BY expense.created_at DESC LIMIT 0, 5' at line 3 [] [] [2016-02-26 15:19:56] 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 expense.deleted = '0' ORDER BY expense.created_at DESC LIMIT 0, 5' at line 3, Code: 42000 URL: /espocrm/api/v1/Expense?maxSize=5&offset=0&sortBy=createdAt&asc=fa lse&where%5B0%5D%5Btype%5D=primary&where%5B0%5D%5B value%5D=planned&where%5B1%5D%5Btype%5D=equals&whe re%5B1%5D%5Bfield%5D=accountId&where%5B1%5D%5Bvalu e%5D=565392a3bc859bb99 [] []
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] => Expense ) , 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 expense.deleted = '0' ORDER BY expense.created_at DESC LIMIT 0, 5' at line 3 [] [] [2016-02-26 15:19:56] 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 expense.deleted = '0' ORDER BY expense.created_at DESC LIMIT 0, 5' at line 3, Code: 42000 URL: /espocrm/api/v1/Expense?maxSize=5&offset=0&sortBy=createdAt&asc=fa lse&where%5B0%5D%5Btype%5D=primary&where%5B0%5D%5B value%5D=planned&where%5B1%5D%5Btype%5D=equals&whe re%5B1%5D%5Bfield%5D=accountId&where%5B1%5D%5Bvalu e%5D=565392a3bc859bb99 [] []
Comment