{"action":"created","issue":{"url":"https://api.github.com/repos/mrakodol/Laravel-5-Bootstrap-3-Starter-Site/issues/30","labels_url":"https://api.github.com/repos/mrakodol/Laravel-5-Bootstrap-3-Starter-Site/issues/30/labels{/name}","comments_url":"https://api.github.com/repos/mrakodol/Laravel-5-Bootstrap-3-Starter-Site/issues/30/comments","events_url":"https://api.github.com/repos/mrakodol/Laravel-5-Bootstrap-3-Starter-Site/issues/30/events","html_url":"https://github.com/mrakodol/Laravel-5-Bootstrap-3-Starter-Site/issues/30","id":57007299,"number":30,"title":"migration db error","user":{"login":"jianfengye","id":1316468,"avatar_url":"https://avatars.githubusercontent.com/u/1316468?v=3","gravatar_id":"","url":"https://api.github.com/users/jianfengye","html_url":"https://github.com/jianfengye","followers_url":"https://api.github.com/users/jianfengye/followers","following_url":"https://api.github.com/users/jianfengye/following{/other_user}","gists_url":"https://api.github.com/users/jianfengye/gists{/gist_id}","starred_url":"https://api.github.com/users/jianfengye/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jianfengye/subscriptions","organizations_url":"https://api.github.com/users/jianfengye/orgs","repos_url":"https://api.github.com/users/jianfengye/repos","events_url":"https://api.github.com/users/jianfengye/events{/privacy}","received_events_url":"https://api.github.com/users/jianfengye/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-02-09T09:36:15Z","updated_at":"2015-02-10T08:52:00Z","closed_at":"2015-02-10T08:51:29Z","body":"```\r\n[vagrant@localhost lstarter]$ php artisan migrate\r\nMigration table created successfully.\r\nexception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1005 Can't create table 'lstarter.#sql-60f_8' (errno: 150)' in /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Connection.php:358\r\nStack trace:\r\n#0 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Connection.php(358): PDOStatement->execute(Array)\r\n#1 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Connection.php(606): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}(Object(Illuminate\\Database\\MySqlConnection), 'alter table `as...', Array)\r\n#2 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Connection.php(570): Illuminate\\Database\\Connection->runQueryCallback('alter table `as...', Array, Object(Closure))\r\n#3 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Connection.php(359): Illuminate\\Database\\Connection->run('alter table `as...', Array, Object(Closure))\r\n#4 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(63): Illuminate\\Database\\Connection->statement('alter table `as...')\r\n#5 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(169): Illuminate\\Database\\Schema\\Blueprint->build(Object(Illuminate\\Database\\MySqlConnection), Object(Illuminate\\Database\\Schema\\Grammars\\MySqlGrammar))\r\n#6 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(112): Illuminate\\Database\\Schema\\Builder->build(Object(Illuminate\\Database\\Schema\\Blueprint))\r\n#7 /vagrant/lstarter/storage/framework/compiled.php(5223): Illuminate\\Database\\Schema\\Builder->create('assigned_roles', Object(Closure))\r\n#8 /vagrant/lstarter/database/migrations/2014_10_16_115128_entrust_setup_tables.php(34): Illuminate\\Support\\Facades\\Facade::__callStatic('create', Array)\r\n#9 /vagrant/lstarter/database/migrations/2014_10_16_115128_entrust_setup_tables.php(34): Illuminate\\Support\\Facades\\Schema::create('assigned_roles', Object(Closure))\r\n#10 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(135): EntrustSetupTables->up()\r\n#11 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(111): Illuminate\\Database\\Migrations\\Migrator->runUp('2014_10_16_1151...', 1, false)\r\n#12 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(82): Illuminate\\Database\\Migrations\\Migrator->runMigrationList(Array, false)\r\n#13 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(73): Illuminate\\Database\\Migrations\\Migrator->run('/vagrant/lstart...', false)\r\n#14 [internal function]: Illuminate\\Database\\Console\\Migrations\\MigrateCommand->fire()\r\n#15 /vagrant/lstarter/storage/framework/compiled.php(922): call_user_func_array(Array, Array)\r\n#16 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\\Container\\Container->call(Array)\r\n#17 /vagrant/lstarter/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(253): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#18 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#19 /vagrant/lstarter/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#20 /vagrant/lstarter/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#21 /vagrant/lstarter/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#22 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(91): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#23 /vagrant/lstarter/artisan(36): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#24 {main}\r\n\r\nNext exception 'Illuminate\\Database\\QueryException' with message 'SQLSTATE[HY000]: General error: 1005 Can't create table 'lstarter.#sql-60f_8' (errno: 150) (SQL: alter table `assigned_roles` add constraint assigned_roles_user_id_foreign foreign key (`user_id`) references `users` (`id`) on delete cascade)' in /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Connection.php:614\r\nStack trace:\r\n#0 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Connection.php(570): Illuminate\\Database\\Connection->runQueryCallback('alter table `as...', Array, Object(Closure))\r\n#1 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Connection.php(359): Illuminate\\Database\\Connection->run('alter table `as...', Array, Object(Closure))\r\n#2 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(63): Illuminate\\Database\\Connection->statement('alter table `as...')\r\n#3 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(169): Illuminate\\Database\\Schema\\Blueprint->build(Object(Illuminate\\Database\\MySqlConnection), Object(Illuminate\\Database\\Schema\\Grammars\\MySqlGrammar))\r\n#4 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(112): Illuminate\\Database\\Schema\\Builder->build(Object(Illuminate\\Database\\Schema\\Blueprint))\r\n#5 /vagrant/lstarter/storage/framework/compiled.php(5223): Illuminate\\Database\\Schema\\Builder->create('assigned_roles', Object(Closure))\r\n#6 /vagrant/lstarter/database/migrations/2014_10_16_115128_entrust_setup_tables.php(34): Illuminate\\Support\\Facades\\Facade::__callStatic('create', Array)\r\n#7 /vagrant/lstarter/database/migrations/2014_10_16_115128_entrust_setup_tables.php(34): Illuminate\\Support\\Facades\\Schema::create('assigned_roles', Object(Closure))\r\n#8 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(135): EntrustSetupTables->up()\r\n#9 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(111): Illuminate\\Database\\Migrations\\Migrator->runUp('2014_10_16_1151...', 1, false)\r\n#10 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(82): Illuminate\\Database\\Migrations\\Migrator->runMigrationList(Array, false)\r\n#11 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(73): Illuminate\\Database\\Migrations\\Migrator->run('/vagrant/lstart...', false)\r\n#12 [internal function]: Illuminate\\Database\\Console\\Migrations\\MigrateCommand->fire()\r\n#13 /vagrant/lstarter/storage/framework/compiled.php(922): call_user_func_array(Array, Array)\r\n#14 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\\Container\\Container->call(Array)\r\n#15 /vagrant/lstarter/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(253): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#16 /vagrant/lstarter/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#17 /vagrant/lstarter/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n#18 /vagrant/lstarter/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Database\\Console\\Migrations\\MigrateCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\r\n```"},"comment":{"url":"https://api.github.com/repos/mrakodol/Laravel-5-Bootstrap-3-Starter-Site/issues/comments/73664242","html_url":"https://github.com/mrakodol/Laravel-5-Bootstrap-3-Starter-Site/issues/30#issuecomment-73664242","issue_url":"https://api.github.com/repos/mrakodol/Laravel-5-Bootstrap-3-Starter-Site/issues/30","id":73664242,"user":{"login":"stojankukrika","id":10199584,"avatar_url":"https://avatars.githubusercontent.com/u/10199584?v=3","gravatar_id":"","url":"https://api.github.com/users/stojankukrika","html_url":"https://github.com/stojankukrika","followers_url":"https://api.github.com/users/stojankukrika/followers","following_url":"https://api.github.com/users/stojankukrika/following{/other_user}","gists_url":"https://api.github.com/users/stojankukrika/gists{/gist_id}","starred_url":"https://api.github.com/users/stojankukrika/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stojankukrika/subscriptions","organizations_url":"https://api.github.com/users/stojankukrika/orgs","repos_url":"https://api.github.com/users/stojankukrika/repos","events_url":"https://api.github.com/users/stojankukrika/events{/privacy}","received_events_url":"https://api.github.com/users/stojankukrika/received_events","type":"User","site_admin":false},"created_at":"2015-02-10T08:51:59Z","updated_at":"2015-02-10T08:51:59Z","body":"Thank you  @mclxly!"}}