Jul 21, · I would imagine that having in - in the table name is the problem. It might not have been picked up in the initial create but might becausing a problem when doing the desc. Nov 29, · I paid for and downloaded a program called tweakbit which stated they could fix it. They did not fix it and therefore I wasted my money. Do not believe all you read! By default CakePHP does not quote identifiers in generated SQL queries. The reason for this is identifier quoting has a few drawbacks: Performance overhead - Quoting identifiers is .
Sql error 1064 cake php
Jul 21, · I would imagine that having in - in the table name is the problem. It might not have been picked up in the initial create but might becausing a problem when doing the desc. Hello all, thank you in advance for any help you may be able to provide. I'm using cakePHP The following code works perfectly: class OptionsController extends AppController. How to fix it: Just because the word alter is reserved does not mean it cannot be used, it just has special requirements to use it as the MySQL engine is trying to call the functionality for the alter command. To fix the issue, you will want to surround the word with backticks (`), this is usually the button just to the left of the "1" button on the keyboard.You are correct, that method is deprecated. Replace findAll("status=1"). with find(' all', array('conditions'=>"status=1")). See the manual. error Error: [PDOException] SQLSTATE: Syntax error or access violation: You have an error in your SQL. The SQL query being performed is: display. As you know, the SQL query you are looking for should start like: SELECT FROM.
see the video Sql error 1064 cake php
Cakephp Ajax Tutorial - Using Cakephp's Js Helper and jQuery, time: 58:33