Log actual query?

Yii 1.1 General Discussion
1

I turned on the weblogroute… but how do I see the actual query?

Example


Querying SQL: SELECT `t`.`id` AS `t0_c0`, `t`.`content` AS `t0_c1`,

`t`.`book_id` AS `t0_c2`, `t`.`page_id` AS `t0_c3`, `book`.`id` AS `t1_c0`,

`book`.`slug` AS `t1_c1`, `book`.`title` AS `t1_c2`, `book`.`directory` AS

`t1_c3`, `book`.`description` AS `t1_c4`, `book`.`created` AS `t1_c5`,

`book`.`modified` AS `t1_c6` FROM `pages` `t`  LEFT OUTER JOIN `books`

`book` ON (`t`.`id`=`book`.`id`) WHERE (content LIKE :keyword) LIMIT 10

Does not have params replaced yet?

2

add property


'enableParamLogging'=>true

in you "db" section of main.php

3

Thanks but it does not seem to have effect… or does it need to be in the Weblog? And why is this not enabled by default? is anybody actually using it with params?

Error in executing SQL: INSERT INTO comments (content, status,

book_id, created, user_id) VALUES (:yp0, :yp1, :yp2, NOW(), :yp3).

Bind with parameter :yp0='sdasdsda ', :yp1=2, :yp2=1, :yp3=1


'db'=>array(

            'connectionString' => 'mysql:host=localhost;dbname=ebooks',

            'emulatePrepare' => true,            

            'username' => 'root',

            'password' => '123qwe',

            'charset' => 'utf8',

            'enableParamLogging'=> true,

            'tablePrefix' => ''

        ),
4

Is exactly your params. So it works ;)