Skip to content

Instantly share code, notes, and snippets.

@abbood
Created November 24, 2017 07:34
Show Gist options
  • Select an option

  • Save abbood/eb559045a42eff99abf35274f2b915cb to your computer and use it in GitHub Desktop.

Select an option

Save abbood/eb559045a42eff99abf35274f2b915cb to your computer and use it in GitHub Desktop.
verbose migration error
[Illuminate\Database\QueryException (23502)]
SQLSTATE[23502]: Not null violation: 7 ERROR: column "building_id" contains null values (SQL: ALTER TABLE addresses ALTER COLUMN building_id SET NOT NULL)
Exception trace:
() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Connection.php:770
Illuminate\Database\Connection->runQueryCallback() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Connection.php:726
Illuminate\Database\Connection->run() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Connection.php:481
Illuminate\Database\Connection->statement() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:317
Illuminate\Database\DatabaseManager->__call() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:237
Illuminate\Support\Facades\Facade::__callStatic() at /home/forge/default/database/migrations/2016_02_28_220744_allow_nullable_building_address.php:29
AllowNullableBuildingAddress->{closure}() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:69
Illuminate\Database\Schema\Blueprint->__construct() at /home/forge/default/vendor/phaza/laravel-postgis/src/Schema/Builder.php:16
Phaza\LaravelPostgis\Schema\Builder->createBlueprint() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:130
Illuminate\Database\Schema\Builder->table() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:237
Illuminate\Support\Facades\Facade::__callStatic() at /home/forge/default/database/migrations/2016_02_28_220744_allow_nullable_building_address.php:31
AllowNullableBuildingAddress->down() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:373
Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Connection.php:570
Illuminate\Database\Connection->transaction() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:379
Illuminate\Database\Migrations\Migrator->runMigration() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:282
Illuminate\Database\Migrations\Migrator->runDown() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:254
Illuminate\Database\Migrations\Migrator->reset() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/ResetCommand.php:68
Illuminate\Database\Console\Migrations\ResetCommand->fire() at n/a:n/a
call_user_func_array() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Container/Container.php:508
Illuminate\Container\Container->call() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Console/Command.php:169
Illuminate\Console\Command->execute() at /home/forge/default/vendor/symfony/console/Command/Command.php:261
Symfony\Component\Console\Command\Command->run() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Console/Command.php:155
Illuminate\Console\Command->run() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Console/Command.php:185
Illuminate\Console\Command->call() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/RefreshCommand.php:55
Illuminate\Database\Console\Migrations\RefreshCommand->fire() at n/a:n/a
call_user_func_array() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Container/Container.php:508
Illuminate\Container\Container->call() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Console/Command.php:169
Illuminate\Console\Command->execute() at /home/forge/default/vendor/symfony/console/Command/Command.php:261
Symfony\Component\Console\Command\Command->run() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Console/Command.php:155
Illuminate\Console\Command->run() at /home/forge/default/vendor/symfony/console/Application.php:817
Symfony\Component\Console\Application->doRunCommand() at /home/forge/default/vendor/symfony/console/Application.php:185
Symfony\Component\Console\Application->doRun() at /home/forge/default/vendor/symfony/console/Application.php:116
Symfony\Component\Console\Application->run() at /home/forge/default/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:121
Illuminate\Foundation\Console\Kernel->handle() at /home/forge/default/artisan:35
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment