How to display the SQL query ?

Yii 1.1 General Discussion
1

Hi,

is it possible to display the sql query? I have a problem when inserting a new record, Yii not generate any problem but insertion is not done!

Thanks.

2 



'db'=>array(

         …

        'enableProfiling'=>true,

        'enableParamLogging' => true,

),

'log'=>array(

    'class'=>'CLogRouter',

    'routes'=>array(

        …

        array(

            'class'=>'CProfileLogRoute',

            'levels'=>'profile',

            'enabled'=>true,

        ),

    ),

),
3

Thanks samdark,

I find all requests except the one that does not work, I have not found a solution. I use the method save.


$ModeleImpression->save();

Have you any idea?

4

Check the return value from save(). If false check if it’s a validation problem. You can replace save with validate() followed by save(false). I you use before/after functions, make sure they return proper values (false will inhibit further processing).

/Tommy

5

validate return false!!

6

I found the problem

is a required field :lol:

Thank you all :)