Following is the out put of my error:
/
*********************************************************************************/
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 'addStar' at line 1 [CORE\cake\libs\model
\datasources\dbo_source.php, line 521]
Code | Context
$sql = "addStar"
$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 'addStar' at line 1"
$out = null
$out = null;
if ($error) {
trigger_error("<span style = \"color:Red;text-
align:left\"><b>SQL Error:</b> {$this->error}</span>",
E_USER_WARNING);
DboSource::showQuery() - CORE\cake\libs\model\datasources
\dbo_source.php, line 521
DboSource::execute() - CORE\cake\libs\model\datasources
\dbo_source.php, line 208
DboSource::fetchAll() - CORE\cake\libs\model\datasources
\dbo_source.php, line 344
DboSource::query() - CORE\cake\libs\model\datasources\dbo_source.php,
line 305
Model::call__() - CORE\cake\libs\model\model.php, line 404
Overloadable::__call() - CORE\cake\libs\overloadable_php5.php, line 59
AppModel::addStar() - [internal], line ??
BooksController::star() - APP\controllers\books_controller.php, line
65
Object::dispatchMethod() - CORE\cake\libs\object.php, line 116
Dispatcher::_invoke() - CORE\cake\dispatcher.php, line 259
Dispatcher::dispatch() - CORE\cake\dispatcher.php, line 213
[main] - APP\webroot\index.php, line 90
Query: addStar
Warning (2): Cannot modify header information - headers already sent
by (output started at C:\xampp\htdocs\cake12\CakePHP\cake\basics.php:
111) [CORE\cake\libs\controller\controller.php, line 587]
Code | Context
$status = "Location: http://localhost/cake12/CakePHP/books";
header - [internal], line ??
Controller::header() - CORE\cake\libs\controller\controller.php, line
587
Controller::redirect() - CORE\cake\libs\controller\controller.php,
line 568
BooksController::star() - APP\controllers\books_controller.php, line
68
Object::dispatchMethod() - CORE\cake\libs\object.php, line 116
Dispatcher::_invoke() - CORE\cake\dispatcher.php, line 259
Dispatcher::dispatch() - CORE\cake\dispatcher.php, line 213
[main] - APP\webroot\index.php, line 90
(default) 1 query took 0 ms Nr Query Error Affected Num. rows
Took
(ms)
1 addStar 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 'addStar' at line 1 0
/
*************************************************************************************/
BUT I WANT TO SEE ACTUAL QUERY EXECUTED.
On Oct 22, 3:47 pm, phpcurious <[EMAIL PROTECTED]> wrote:
> if you don't see any debug dump, that could have been due to your
> $cakeDebug is either empty or not in default.ctp layout
>
> On Oct 22, 6:38 pm, xelios <[EMAIL PROTECTED]> wrote:
>
> > My debug line is as follows:
> > Configure::write('debug', 2);
>
> > but still its not showing queries
>
> > On Oct 22, 3:24 pm, "[EMAIL PROTECTED]"
>
> > <[EMAIL PROTECTED]> wrote:
> > > app/config/core.php - the first line of code.
>
> > > ---
> > > /**
> > > * CakePHP Debug Level:
> > > *
> > > * Production Mode:
> > > * 0: No error messages, errors, or warnings shown. Flash messages
> > > redirect.
> > > *
> > > * Development Mode:
> > > * 1: Errors and warnings shown, model caches refreshed, flash
> > > messages halted.
> > > * 2: As in 1, but also with full debug messages and SQL output.
> > > * 3: As in 2, but also with full controller dump.
> > > *
> > > * In production mode, flash messages redirect after a time interval.
> > > * In development mode, you need to click the flash message to
> > > continue.
> > > */
> > > ---
>
> > > On Oct 22, 12:20 pm, xelios <[EMAIL PROTECTED]> wrote:
>
> > > > I've an error in my sql query. How can I print query for debugging
> > > > purposes.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
