./lnms migrate -vvv SQL[select `config_name`, `config_value` from `config` [] 0.27ms] SQL[select * from `graph_types` [] 0.25ms] ************************************** * Application In Production! * ************************************** Do you really wish to run this command? (yes/no) [no]: > y SQL[select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE' ["librenms","migrations"] 145.61ms] SQL[select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE' ["librenms","migrations"] 0.55ms] SQL[select `migration` from `migrations` order by `batch` asc, `migration` asc [] 42.25ms] SQL[select `migration` from `migrations` order by `batch` asc, `migration` asc [] 0.38ms] SQL[select max(`batch`) as aggregate from `migrations` [] 0.45ms] Migrating: 2021_10_03_164200_update_hrsystem_table There is no column with name 'hrsystemnumusers' on table 'hrSystem'. {"exception":"[object] (Doctrine\\DBAL\\Schema\\SchemaException(code: 30): There is no column with name 'hrsystemnumusers' on table 'hrSystem'. at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:86)"} In SchemaException.php line 86: [Doctrine\DBAL\Schema\SchemaException (30)] There is no column with name 'hrsystemnumusers' on table 'hrSystem'. Exception trace: at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/SchemaException.php:86 Doctrine\DBAL\Schema\SchemaException::columnDoesNotExist() at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:711 Doctrine\DBAL\Schema\Table->getColumn() at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Table.php:342 Doctrine\DBAL\Schema\Table->changeColumn() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/ChangeColumn.php:110 Illuminate\Database\Schema\Grammars\ChangeColumn::getDoctrineColumn() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/ChangeColumn.php:80 Illuminate\Database\Schema\Grammars\ChangeColumn::getTableWithColumnChanges() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/ChangeColumn.php:64 Illuminate\Database\Schema\Grammars\ChangeColumn::getChangedDiff() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/ChangeColumn.php:41 Illuminate\Database\Schema\Grammars\ChangeColumn::compile() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/Grammar.php:83 Illuminate\Database\Schema\Grammars\Grammar->compileChange() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:135 Illuminate\Database\Schema\Blueprint->toSql() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:108 Illuminate\Database\Schema\Blueprint->build() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:365 Illuminate\Database\Schema\Builder->build() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:212 Illuminate\Database\Schema\Builder->table() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 Illuminate\Support\Facades\Facade::__callStatic() at /opt/librenms/database/migrations/2021_10_03_164200_update_hrsystem_table.php:20 UpdateHrSystemTable->up() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:394 Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:403 Illuminate\Database\Migrations\Migrator->runMigration() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:202 Illuminate\Database\Migrations\Migrator->runUp() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:167 Illuminate\Database\Migrations\Migrator->runPending() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:112 Illuminate\Database\Migrations\Migrator->run() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:85 Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:585 Illuminate\Database\Migrations\Migrator->usingConnection() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:94 Illuminate\Database\Console\Migrations\MigrateCommand->handle() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php:40 Illuminate\Container\Util::unwrapIfClosure() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93 Illuminate\Container\BoundMethod::callBoundMethod() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:37 Illuminate\Container\BoundMethod::call() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php:653 Illuminate\Container\Container->call() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php:136 Illuminate\Console\Command->execute() at /opt/librenms/vendor/symfony/console/Command/Command.php:299 Symfony\Component\Console\Command\Command->run() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Command.php:121 Illuminate\Console\Command->run() at /opt/librenms/vendor/symfony/console/Application.php:978 Symfony\Component\Console\Application->doRunCommand() at /opt/librenms/vendor/symfony/console/Application.php:295 Symfony\Component\Console\Application->doRun() at /opt/librenms/vendor/symfony/console/Application.php:167 Symfony\Component\Console\Application->run() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Console/Application.php:94 Illuminate\Console\Application->run() at /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:129 Illuminate\Foundation\Console\Kernel->handle() at /opt/librenms/app/Console/Kernel.php:72 App\Console\Kernel->handle() at /opt/librenms/lnms:40