How to add column in MODEL in yii2

Question

I have created Model called ExpertQuestion using Gii

After that i added column in table from which i generated Table.

So, my question is how to add column in my ExpertQuestion Model to access it.

Error:

Unknown Property – yii\base\UnknownPropertyException

Setting unknown property: app\models\ExpertQuestion::is_deleted

The error is about `ExpertQuestion`, not `User`... – soju May 24 '16 at 13:05 — soju, May 24 '16 at 13:05
sorry, i Edited my question, please check – Yasin Patel May 24 '16 at 13:12 — Yasin Patel, May 24 '16 at 13:12

score 1 · Answer 1 · answered May 24 '16 at 13:15

Re run Gii for that table and copy and paste the missing information over into your model.

Alternatively if you have no additional code in the model just overwrite the whole model

Or you can use something like Giiant where you have base models that your actual model inherit from, this means you just re run the base model when changes in your DB occur and you don't overwrite any code in your actual model that implements this base model.

score 1 · Answer 2 · edited Oct 10 '16 at 14:11

Let's consider the new column name as newCol in your model

update rule function

public function rules()
{   
   return [.....

      [['newCol'], 'string', 'max' => 30],

      ];   
}

Then add labels

public function attributeLabels()
{
        return [...

         'newCol' => Yii::t('app', 'L Name'),

       ];    
}

Now open Search model and update

public function search($params)
{
    ....

    $query->andFilterWhere(['like', 'newCol ', $this->newCol ])

    ....

    return $dataProvider;    
}

score 0 · Answer 3 · edited May 25 '16 at 05:36

0

Edit model file and write new field name in rules.

Ex: new field is is_deleted(string) then write new rule for this field.

[['is_deleted'], 'string'],

edited May 25 '16 at 05:36

Yasin Patel

5,624
8
31
53

answered May 24 '16 at 13:25

Arshad Shaikh

564
1
3
13

score 0 · Answer 4 · answered May 24 '16 at 13:29

0

Аgain generate the model in Gii, click on the diff button, and copy and paste to your Model that relates to your new field.

screen diff button

answered May 24 '16 at 13:29

Vitaly

1,261
2
10
20

score 0 · Answer 5 · answered May 24 '16 at 16:04

0

This is related at the way yii1 cache the models

If you don't need tu re run Gii for a new generation of model ..

you can simply .. delete the runtime directory of your app

   yourApp/runtime

answered May 24 '16 at 16:04

ScaisEdge

131,976
10
91
107

How to add column in MODEL in yii2

5 Answers5