librenms
error when add user from command line
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'
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?
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.
