Error on migrate:fresh

[pabloblazquez]

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (Connection: mysql, SQL: alter table orders add constraint orders_address_id_foreign foreign key (address_id) references locations (id) on delete cascade)

I think maybe it's all about some inconsistency in the order of launching migrations between your different plugins.

[3x1io]

hi @pabloblazquez thanks for your report, yes it was a problem on filament-locations and it's fixed now you can try it

[YonkoSam]

[YonkoSam]

im having a similer problem its fresh install laravel with filment

[3x1io]

what is your database driver?

[YonkoSam]

sqllite

[3x1io]

it's fine now i fix the seeder for SQLite

[YonkoSam]

yes the first problem is fixed but now there is a another one

[3x1io]

use this and than migrate

php artisan vendor:publish --provider="Spatie\LaravelSettings\LaravelSettingsServiceProvider" --tag="migrations"

I add it to docs

[YonkoSam]

thank you it worked

[pabloblazquez]

I still have problems launching a "migrate fresh". Now the problem is with "base_tomato_ecommerce.settings'"

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'base_tomato_ecommerce.settings' doesn't exist (Connection: mysql, SQL: select exists(select * from settings where group = ordering and name = ordering_web_branch) as exists)

[3x1io]

if you check the docs

php artisan vendor:publish --provider="Spatie\LaravelSettings\LaravelSettingsServiceProvider" --tag="migrations"
php artisan filament-settings-hub:install

[pabloblazquez]

You're right, sorry, my bad. It went well this time.

I will try your development, good job!