PHP(CakePHP)システムを作っています。
ばけを実装中に以下のエラーメッセージが発生しました。
###発生している問題・エラーメッセージ
Database Error 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 'AS `Data__data id`, Data.value AS `Data__value`, Data.date AS `Data__date`, Data' at line 1 If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php. SQL Query: SELECT Data.data id AS `Data__data id`, Data.value AS `Data__value`, Data.date AS `Data__date`, Data.senor id AS `Data__senor id`, Data.machine id AS `Data__machine id`, Data.Date created AS `Data__Date created`, Data.Update date AS `Data__Update date` FROM data Data LIMIT 20 OFFSET 0 If you want to customize this error message, create src/Template/Error/pdo_error.ctp
あなたの回答
tips
プレビュー