librenms / librenmsv2

LibreNMS WebUI Rewrite
GNU General Public License v3.0
26 stars 15 forks source link

error when add user from command line #192

Open vgeannin opened 7 years ago

vgeannin commented 7 years ago

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, vincent.xxxxx@xxxxxxx.Com, 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 commented 7 years ago

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 commented 7 years ago

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.