Hi All,
I'm new to CakePHP and I used the cake bake tool to generate my model
classes, controllers and views for a fairly complex data model. One of my
model classes is returning the message below and appears to be sending
'setFlash' to the database as a query. Can someone point me to where the
problem might be occurring so I can fix it.
Thanks,
Warning (512): SQL Error: 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 'setFlash' at line 1
[CORE/cake/libs/model/datasources/dbo_source.php, line 512]
Code | Context
$sql = "setFlash"
$error = "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
'setFlash' at line 1"
$out = null
$out = null;
if ($error) {
trigger_error("SQL Error: {$this->error}", E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php,
line 512
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line
202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php,
line 338
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line
299
Model::call__() - CORE/cake/libs/model/model.php, line 397
Overloadable::__call() - CORE/cake/libs/overloadable_php5.php, line 59
Session::setFlash() - [internal], line ??
SessionsController::add() - APP/controllers/sessions_controller.php, line 24
Object::dispatchMethod() - CORE/cake/libs/object.php, line 114
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - /home/doychi/public_html/index.php, line 92
>From the query log produced in debug mode (I think):
25 SELECT `SessionsSession`.`session_id` FROM `sessions_sessions` AS
`SessionsSession` WHERE `SessionsSession`.`session_id` = 1 0
0 0
26 setFlash 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 'setFlash' at line 1 0
--
View this message in context:
http://www.nabble.com/Bad-SQL%3A--setFlash-tp19284992p19284992.html
Sent from the CakePHP mailing list archive at Nabble.com.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
