Error when using loadModel

[logos010]

Hello,

Does every one know why I using $this->loadModel(id) bring me an error like this:

The value for the column "ma_lc" is not supplied when querying the table "lich_chay".

C:\YII\framework\db\schema\CDbCommandBuilder.php(674)

00662:

00663: for($i=0;$i<$n;++$i)

00664: {

00665: if(isset($values[$i][$name]))

00666: {

00667: $value=$table->columns[$name]->typecast($values[$i][$name]);

00668: if(is_string($value))

00669: $values[$i][$name]=$db->quoteValue($value);

00670: else

00671: $values[$i][$name]=$value;

00672: }

00673: else

00674: throw new CDbException(Yii::t(‘yii’,‘The value for the column “{column}” is not supplied when querying the table “{table}”.’,

00675: array(’{table}’=>$table->name,’{column}’=>$name)));

00676: }

00677: }

00678: if(count($values)===1)

00679: {

00680: $entries=array();

00681: foreach($values[0] as $name=>$value)

00682: $entries[]=$prefix.$table->columns[$name]->rawName.($value===null?’ IS NULL’:’=’.$value);

00683: return implode(’ AND ',$entries);

00684: }

00685:

00686: return $this->createCompositeInCondition($table,$values,$prefix);

I have no idea for this error, help me please

[gusnips (Gustavo)]

Sorry cant help you

You should post this under General Discussion for Yii 1.1.x since its not a feature request

[mdomba (Maurizio Domba Cerin)]

Note: topic moved to proper forum - general Discussion for Yii 1.1.x

As for the problem… seems that you have a condition in the query, but you did not provide a value…

To help you better you would need to post here the query that trigers this error…

[logos010]

I dont know why? when I use loadModel() in actionIndex():

        public function actionIndex()

	{ 

               $this->loadModel(2);

	}

But when I try it in another controller, it work fine?!

[macinville]

Probably the model being called by the controller doesn’t have the primary key of value 2?

[mdomba (Maurizio Domba Cerin)]

What is the primary key for this table… is it a composite key ?

Check this similar topic - http://www.yiiframework.com/forum/index.php?/topic/15528-cactiverecord-strange-issue/