error in migration on db postgres

[jrgonzalez3]

Creating migration table ...................................... 14.61ms DONE

INFO Running migrations.

2014_10_12_000000_create_users_table ........................... 9.03ms DONE
2014_10_12_100000_create_password_reset_tokens_table ........... 4.88ms DONE
2019_08_19_000000_create_failed_jobs_table ..................... 6.40ms DONE
2019_12_14_000001_create_personal_access_tokens_table .......... 7.22ms DONE
2022_12_14_083707_create_settings_table ........................ 5.73ms DONE
2024_02_18_011728_create_notifications_table ................... 5.93ms DONE
2024_02_18_024959_create_banner_categories_table ............... 6.87ms FAIL

Illuminate\Database\QueryException

SQLSTATE[42830]: Invalid foreign key: 7 ERROR: there is no unique constraint matching given keys for referenced table "banner_categories" (Connection: pgsql, SQL: alter table "banner_categories" add constraint "banner_categories_parent_id_foreign" foreign key ("parent_id") references "banner_categories" ("id") on delete cascade)

2024_02_18_024959_create_banner_categories_table ............... 9.99ms FAIL

Illuminate\Database\QueryException

SQLSTATE[42830]: Invalid foreign key: 7 ERROR: there is no unique constraint matching given keys for referenced table "banner_categories" (Connection: pgsql, SQL: alter table "banner_categories" add constraint "banner_categories_parent_id_foreign" foreign key ("parent_id") references "banner_categories" ("id") on delete cascade)

justo@saastech superduper-filament-starter-kit % php artisan db:seed

INFO Seeding database.

Database\Seeders\RolesAndPermissionsSeeder ......................... RUNNING

Illuminate\Database\QueryException

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "permissions" does not exist
LINE 1: select * from "permissions"
^ (Connection: pgsql, SQL: select * from "permissions")

[zebulun78]

Same

[hackdan]

I did this at the end of up(), and removed the line 17:
// Add foreign key constraint after table creation using ALTER TABLE
DB::statement('ALTER TABLE banner_categories ADD CONSTRAINT banner_categories_parent_id_foreign FOREIGN KEY (parent_id) REFERENCES banner_categories(id) ON DELETE CASCADE');

[hackdan]

Hi in my postgres 16.2, seems like a Spatie Roles looks for UUID instead is getting a BigInt type.
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type uuid: "1"
CONTEXT: unnamed portal parameter $5 = '...' (Connection: pgsql, SQL: insert into "activity_log" ("log_name", "properties", "batch_uuid", "event", "subject_id", "subject_type", "description", "updated_at", "created_at") values (Resource, {"guard_name":"web","name":"super_admin","created_at":"2025-05-15 20:38:27","updated_at":"2025-05-15 20:38:27","id":1}, ?, Created, 1, Spatie\Permission\Models\Role, Role Created, 2025-05-15 20:38:27, 2025-05-15 20:38:27) returning "id")