Laravel Migration to Neon Error

When I try to migrate my laravel database to Neon's server, I keep getting this error:

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: alter table "provinces" add constraint "provinces_country_id_foreign" foreign key ("country_id") references "countries" ("id") on delete cascade)

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: alter table "provinces" add constraint "provinces_country_id_foreign" foreign key ("country_id") references "countries" ("id") on delete cascade)

for context:

I have 2 tables; countries and provinces, to which provinces references countries via country_id like so:

        Schema::create('countries', function (Blueprint $table) {
            $table->id();
        });

        Schema::create('countries', function (Blueprint $table) {
            $table->id();
        });

        Schema::create('provinces', function (Blueprint $table) {
            $table->id();

            // $table->unsignedBigInteger('country_id');

            $table->foreignId('country_id')->default(1)->constrained('countries')->cascadeOnDelete();

            // $table->foreign('country_id')->references('id')->on('countries')->cascadeOnDelete();

            // $table->foreignId('country_id')->references('id')->on('countries');
        });

        Schema::create('provinces', function (Blueprint $table) {
            $table->id();

            // $table->unsignedBigInteger('country_id');

            $table->foreignId('country_id')->default(1)->constrained('countries')->cascadeOnDelete();

            // $table->foreign('country_id')->references('id')->on('countries')->cascadeOnDelete();

            // $table->foreignId('country_id')->references('id')->on('countries');
        });

The commented code are the attempts at restructuring the foreignId in hopes that it would work. But the thing is, there are other files in my migrations that have foreignId's set like the ones above and they're working fine, here's an example:

Schema::create('users', function (Blueprint $table) {
            $table->id();

            $table->foreignId('user_role_id')->default(1)->constraint('user_roles')->cascadeOnDelete();
            $table->foreignId('user_status_id')->default(1)->constraint('user_statuses')->cascadeOnDelete();
});

Schema::create('users', function (Blueprint $table) {
            $table->id();

            $table->foreignId('user_role_id')->default(1)->constraint('user_roles')->cascadeOnDelete();
            $table->foreignId('user_status_id')->default(1)->constraint('user_statuses')->cascadeOnDelete();
});

        Schema::create('user_roles', function (Blueprint $table) {
            $table->id();

        Schema::create('user_roles', function (Blueprint $table) {
            $table->id();

 Schema::create('user_permissions', function (Blueprint $table) {
            $table->id();

 Schema::create('user_permissions', function (Blueprint $table) {
            $table->id();

All that I'm doing for this error to appear is using the

php artisan migrate:fresh

php artisan migrate:fresh

command in my terminal, or migrating the specific file individually.

yes, the countries migration is running before the provinces.

Any answer is appreciated!

Laravel Migration to Neon Error

When I try to migrate my laravel database to Neon's server, I keep getting this error:

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: alter table "provinces" add constraint "provinces_country_id_foreign" foreign key ("country_id") references "countries" ("id") on delete cascade)

SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: alter table "provinces" add constraint "provinces_country_id_foreign" foreign key ("country_id") references "countries" ("id") on delete cascade)

for context:

I have 2 tables; countries and provinces, to which provinces references countries via country_id like so:

        Schema::create('countries', function (Blueprint $table) {
            $table->id();
        });

        Schema::create('countries', function (Blueprint $table) {
            $table->id();
        });

        Schema::create('provinces', function (Blueprint $table) {
            $table->id();

            // $table->unsignedBigInteger('country_id');

            $table->foreignId('country_id')->default(1)->constrained('countries')->cascadeOnDelete();

            // $table->foreign('country_id')->references('id')->on('countries')->cascadeOnDelete();

            // $table->foreignId('country_id')->references('id')->on('countries');
        });

        Schema::create('provinces', function (Blueprint $table) {
            $table->id();

            // $table->unsignedBigInteger('country_id');

            $table->foreignId('country_id')->default(1)->constrained('countries')->cascadeOnDelete();

            // $table->foreign('country_id')->references('id')->on('countries')->cascadeOnDelete();

            // $table->foreignId('country_id')->references('id')->on('countries');
        });

Schema::create('users', function (Blueprint $table) {
            $table->id();

            $table->foreignId('user_role_id')->default(1)->constraint('user_roles')->cascadeOnDelete();
            $table->foreignId('user_status_id')->default(1)->constraint('user_statuses')->cascadeOnDelete();
});

Schema::create('users', function (Blueprint $table) {
            $table->id();

            $table->foreignId('user_role_id')->default(1)->constraint('user_roles')->cascadeOnDelete();
            $table->foreignId('user_status_id')->default(1)->constraint('user_statuses')->cascadeOnDelete();
});

        Schema::create('user_roles', function (Blueprint $table) {
            $table->id();

        Schema::create('user_roles', function (Blueprint $table) {
            $table->id();

 Schema::create('user_permissions', function (Blueprint $table) {
            $table->id();

 Schema::create('user_permissions', function (Blueprint $table) {
            $table->id();

All that I'm doing for this error to appear is using the

php artisan migrate:fresh

php artisan migrate:fresh

command in my terminal, or migrating the specific file individually.

yes, the countries migration is running before the provinces.

Any answer is appreciated!

Laravel Migration to Neon Error

Laravel Migration to Neon Error

Similar Threads

Similar Threads

Similar Threads