Skip to content

Instantly share code, notes, and snippets.

@d8vjork
Created May 25, 2017 08:05
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save d8vjork/71264a2f0b909ac17c16ec0379662602 to your computer and use it in GitHub Desktop.
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'permissions' in 'field list' in C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php:445
Stack trace:
#0 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php(445): PDO->prepare('insert into `us...')
#1 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `us...', Array)
#2 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('insert into `us...', Array, Object(Closure))
#3 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php(450): Illuminate\Database\Connection->run('insert into `us...', Array, Object(Closure))
#4 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php(404): Illuminate\Database\Connection->statement('insert into `us...', Array)
#5 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `us...', Array)
#6 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2139): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `us...', Array, 'id')
#7 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(1247): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(684): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#9 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(649): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(518): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(735): Illuminate\Database\Eloquent\Model->save()
#12 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Support\helpers.php(883): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}(Object(Orchid\Core\Models\User))
#13 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(736): tap(Object(Orchid\Core\Models\User), Object(Closure))
#14 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1341): Illuminate\Database\Eloquent\Builder->create(Array)
#15 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1353): Illuminate\Database\Eloquent\Model->__call('create', Array)
#16 C:\inetpub\wwwroot\orchid\vendor\orchid\platform\app\Console\Commands\CreateAdminCommand.php(67): Illuminate\Database\Eloquent\Model::__callStatic('create', Array)
#17 [internal function]: Orchid\Console\Commands\CreateAdminCommand->fire()
#18 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(29): call_user_func_array(Array, Array)
#19 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#20 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))
#21 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Container\Container.php(531): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)
#22 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Console\Command.php(182): Illuminate\Container\Container->call(Array)
#23 C:\inetpub\wwwroot\orchid\vendor\symfony\console\Command\Command.php(264): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#24 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Console\Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#25 C:\inetpub\wwwroot\orchid\vendor\symfony\console\Application.php(835): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#26 C:\inetpub\wwwroot\orchid\vendor\symfony\console\Application.php(200): Symfony\Component\Console\Application->doRunCommand(Object(Orchid\Console\Commands\CreateAdminCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#27 C:\inetpub\wwwroot\orchid\vendor\symfony\console\Application.php(124): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#28 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Foundation\Console\Kernel.php(122): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#29 C:\inetpub\wwwroot\orchid\artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#30 {main}
Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'permissions' in 'field list' (SQL: insert into `users` (`name`, `email`, `password`, `permissions`, `updated_at`, `created_at`) values (example, test@example.com, $2y$10$0LtaxpWcT8tQHMjRVGWNIODCXUFB8iKj4F3eNPyzH7vN9Te76KuOe, {"dashboard.index":1,"Main menu":1,"dashboard.pages":1,"Pages":1,"dashboard.posts":1,"Posts":1,"dashboard.tools":1,"Tools":1,"dashboard.systems":1,"Systems":1,"dashboard.marketing":1,"Marketing":1,"dashboard.tools.menu":1,"Menu":1,"dashboard.tools.category":1,"Category":1,"dashboard.tools.attachment":1,"File upload":1,"dashboard.tools.media":1,"Media":1,"dashboard.systems.backup":1,"Backups":1,"dashboard.systems.defender":1,"Defender":1,"dashboard.systems.monitor":1,"Monitor":1,"dashboard.systems.logs":1,"Logs":1,"dashboard.systems.roles":1,"Roles":1,"dashboard.systems.schema":1,"Schema":1,"dashboard.systems.settings":1,"Settings":1,"dashboard.systems.users":1,"Users":1,"dashboard.marketing.comment":1,"Comments":1,"dashboard.marketing.advertising":1,"Advertising":1,"dashboard.marketing.utm":1,"UTM tags":1,"dashboard.marketing.robots":1,"Robots.txt":1}, 2017-05-25 07:51:50, 2017-05-25 07:51:50)) in C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php:647
Stack trace:
#0 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php(607): Illuminate\Database\Connection->runQueryCallback('insert into `us...', Array, Object(Closure))
#1 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php(450): Illuminate\Database\Connection->run('insert into `us...', Array, Object(Closure))
#2 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Connection.php(404): Illuminate\Database\Connection->statement('insert into `us...', Array)
#3 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `us...', Array)
#4 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(2139): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `us...', Array, 'id')
#5 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(1247): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(684): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(649): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(518): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(735): Illuminate\Database\Eloquent\Model->save()
#10 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Support\helpers.php(883): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}(Object(Orchid\Core\Models\User))
#11 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(736): tap(Object(Orchid\Core\Models\User), Object(Closure))
#12 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1341): Illuminate\Database\Eloquent\Builder->create(Array)
#13 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1353): Illuminate\Database\Eloquent\Model->__call('create', Array)
#14 C:\inetpub\wwwroot\orchid\vendor\orchid\platform\app\Console\Commands\CreateAdminCommand.php(67): Illuminate\Database\Eloquent\Model::__callStatic('create', Array)
#15 [internal function]: Orchid\Console\Commands\CreateAdminCommand->fire()
#16 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(29): call_user_func_array(Array, Array)
#17 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#18 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))
#19 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Container\Container.php(531): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)
#20 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Console\Command.php(182): Illuminate\Container\Container->call(Array)
#21 C:\inetpub\wwwroot\orchid\vendor\symfony\console\Command\Command.php(264): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#22 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Console\Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#23 C:\inetpub\wwwroot\orchid\vendor\symfony\console\Application.php(835): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#24 C:\inetpub\wwwroot\orchid\vendor\symfony\console\Application.php(200): Symfony\Component\Console\Application->doRunCommand(Object(Orchid\Console\Commands\CreateAdminCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#25 C:\inetpub\wwwroot\orchid\vendor\symfony\console\Application.php(124): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#26 C:\inetpub\wwwroot\orchid\vendor\laravel\framework\src\Illuminate\Foundation\Console\Kernel.php(122): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#27 C:\inetpub\wwwroot\orchid\artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#28 {main}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment