I’m using yii-1.1.8.r3324 and I have the strange problem that a database field, which has a value in the MySQL database, does not have a value while selecting it using Yii.
This is the User Model:
class User extends CActiveRecord {
public static function model($className=__CLASS__) {
return parent::model($className);
}
public function tableName() {
return 'tbl_user';
}
public function primaryKey() {
return 'id';
}
}
And this is the table create statement:
CREATE TABLE `tbl_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(128) NOT NULL,
`password` varchar(128) NOT NULL,
`email` varchar(128) NOT NULL,
`language` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
I selected a row from this table in different ways - with the same result - but here is one:
$db = Yii::app()->db;
$command = $db->createCommand('SELECT * FROM tbl_user WHERE id = 1');
$result = $command->queryAll();
print_r($result);
The result shows an empty value for the field ‘language’ which in fact has ‘de’ as value in the database. I’ve thought about caching and so on but caching has not been activated for the database. I’ve tried
Yii::app()->cache->flush();
as well as
User::model()->refreshMetaData();
User::model()->refresh();
The really strange thing is that I remember that the field was delivered before but I can’t think about what I could have done to change something leading to this result.
I hope anyone could help me with that.