error when add user from command line

[vgeannin]

when I try to add a user, I have this error :
[root@xxxxxxxxxxx librenmsv2]# php artisan user:add vincent --admin
Real Name:

vincent
Email:
vincent.xxxxxx@xxxxxx
Password:

[Illuminate\Database\QueryException]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list' (SQL: insert into users (username, realname, email, level, password, updated_at, created_at) values (vincent, vincent, [email protected], 10, $2y$10$VcFo0Wji44Sm7TmGfKY7h.NXIHOVMicGRf0SZg2y6s0D/4KjKPciK, 2017-01-16 14:05:26, 2017-01-16 14:05:26))
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
[PDOException]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'

[pheinrichs]

As long as your database is up to date with all the schema's in librenms v1 this shouldn't appear. Looks like sql-schema/169.sql is where the updated_at column was added to the database.

@murrant should we make a migration to confirm that the updated_at and created_at columns exist?

[murrant]

DB Schema between v1 and v2 will be up in the air until we move to integrate. Migrations here will not apply correctly to a v1 database.

@vgeannin Validate your v1 install with ./validate.php. As @pheinrichs said updated_ad was added recently to v1 so you just have some issues with your v1 database.