Solved: $model->save() is not fired, no log, no error, no insert

Archives Yii 1.0.x Discussions
1

I have a problem - hope someone has a solution

I am calling a private function in the controller itself before moving to model: Expecting to insert and return the InsertId. I need the InsertId or UpdateId back to maintain other tables.

<?php


    private function CreateEvent($e) {


        $event=Event::model();


        //$event = new Event;


        $event->ansi=$e->ansi;


        $event->feature_id=$e->city; 


        $event->name=$e->event_name; 


        ...


        $event->description=$e->event_desc; 


        $id = $event->save(); echo "<pre>CreateEvent $id";


        //print_r($event); die;


    }

It does not give me error. all SQLs shows in runtime log EXCEPT for insert.

My AR reads but does not do any DML.

Part of the log:

2009/07/02 01:37:55 [trace][system.db.ar.CActiveRecord][system.db.CDbCommand][system.web.CModule][system.web.filters.CFilterChain][system.db.CDbConnection]  Executing SQL: DELETE FROM ae_session WHERE expire<1246516675

2009/07/02 01:37:55 [/s][/s][/s][/s][/s][trace][system.db.ar.CActiveRecord][system.db.CDbCommand][system.web.CModule][system.web.filters.CFilterChain][system.db.CDbConnection]  Querying SQL:

SELECT data FROM ae_session

WHERE expire>1246516675 AND id='5ca42f4b4e676cfae1da69305d3cb38e'

2009/07/02 01:37:55 [/s][/s][/s][/s][/s][trace][system.db.ar.CActiveRecord][system.db.CDbCommand][system.web.CModule][system.web.filters.CFilterChain][system.db.CDbConnection]  Loading "securityManager" application component

2009/07/02 01:37:55 [/s][/s][/s][/s][/s][trace][system.db.ar.CActiveRecord][system.db.CDbCommand][system.web.CModule][system.web.filters.CFilterChain][system.db.CDbConnection]  Loading "statePersister" application component[/s][/s][/s][/s][/s]

2

I think it's your model declaration:

It should look something like this:



<?php


$event = new Event;


$event -> attribute1 = $e -> whatever;


$event -> save();

Chris

3

I tried that too. I am using MySQL and innodb table.

Not working.

4

Check to see if there are any validation errors.

5

Don't forget returning true in the method.

 return true;
6

Thank you!

"return true;" did the trick

One last question, I would like to return PKey from $model->save(), be it Insert or Update.

What would be the Syntax? I tried looking for sample code in forum and site. 

7

override save() and return the PK you want ?

8

Thank you qiang

I see what you are saying, after save, return $model->id