Getting unknown property: amnah\yii2\user\models\User::banned_at

[sircovsw]

After update (10/11/2015) I see error: Getting unknown property: amnah\yii2\user\models\User::banned_at How to update the table structure without data loss?

[greenxiii]

Has same problem as @sircovsw

[amnah]

Yes, I just released a new version.

Easy solution: limit composer.json version to "amnah/yii2-user": "^3.0"

Harder solution: change db column names:

role.create_time -> role.created_at
role.update_time -> role.updated_at

profile.create_time -> profile.created_at
profile.update_time -> profile.updated_at

user_auth.create_time -> user_auth.created_at
user_auth.update_time -> user_auth.updated_at

user_key -> user_token (change the table name)
user_key.user_id -> user_token.user_id (make nullable)
user_key.key_value -> user_token.token
user_key.create_time -> user_token.created_at
user_key.expire_time-> user_token.expired_at
user_key.consume_time -> (delete)
... -> (add) user_token.data

user.new_email -> (delete)
user.api_key -> user.access_token
user.create_time -> user.created_at
user.update_time -> user.updated_at
user.login_ip -> user.logged_in_ip
user.login_time -> user.logged_in_at
user.create_ip -> user.created_ip
user.ban_time-> user.banned_at
user.ban_reason -> user.banned_reason

That ... should be it. Let me know if I missed any.

[sircovsw]

Thank you. I will do the sql script to alter table.

[amnah]

Created a migration, seems to work but may want to test a bit more

https://gist.github.com/amnah/384e607f5e2d3cbfbc72

[sircovsw]

Thank you. Works. Only no existed user_token field->key_value. There was user_token->key