Strange Behaviour In Yii Web Service/mssql

[yii_king (Micho23)]

I have a Yii web service which has been working fine until now.

All of a sudden I am getting an error message when trying to update an existing record, saying:

Column name must be either a string or an array.

I’ve looked in the MSSQL db and the table which I am using has a primary key set for it. However, after reading some posts I noticed one solution was to include the following method in the model:

public function primaryKey() {

return array(‘id’);

}

After including this piece of code, the update creates a new row with id = 1, although it is not this id that it should update. Running a second update updates the correct row with id 815.

I have also managed to remove this error by specify id in the findByAttributes query, but I should not have to specify the id as I don’t know it before it is being inserted/updated. This does not work:

$readingExists = CarReadings::model()->findByAttributes(array(‘carNumber’=>$carNumber, ‘date’=>$date, ‘inputType’=>‘forecast’));

But this works:

$readingExists = CarReadings::model()->findByAttributes(array(‘id’=>‘100’, ‘carNumber’=>$carNumber, ‘date’=>$date, ‘inputType’=>‘forecast’));

Is there something wrong in the MSSQL table settings, or in the Yii code somehow?

[yii_king (Micho23)]

Are there any active users in the Yii forum??

[hemc (Hemendra Chaudhary619)]

This message generally comes when primary key is not defined for the table. Check this link

[yii_king (Micho23)]

The primary key is defined for the table. As you can read in my post, I have also tried to add the following rows to the model class, and then it works to update. However, it will then only update row with id 1 without taking other criteria into consideration.

public function primaryKey() {

return array(‘id’);

}

This message generally comes when primary key is not defined for the table. Check this link