F
Filament•3mo ago
gigiloouu

Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint

i have this error. i know that there i have somewhere foreign key but, is it any way to fix it in code ? or in db?
No description
3 Replies
Sdeev
Sdeev•3mo ago
you can use ondeletecascade on your migration or try to delete them using Observer or by adding the >actions() method to the deleteAction
gigiloouu
gigiloouu•3mo ago
can u give me a example? when i try to add deleteAction i have error Method Filament\Actions\DeleteAction::table does not exist. i add ondeltecascade on migration and when i try to run migrations i have erorr SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'purchases_company_id_foreign'; check that column/key exists (Connection: mysql, SQL: alter table purchases drop foreign key purchases_company_id_foreign)
toeknee
toeknee•3mo ago
because purchases do not exist
Want results from more Discord servers?
Add your server
More Posts
Conditional Rendering in filament formsI have a form and I want when a use selects sponsorChild I show the children dropdown , when i selecadd label in layout table splitHi i try to use split on my table so it can be responsive. But it missing the column title, is anythHow can I automatically launch a function when user enters a Resource list page?I need to update some data before users access the mediaResource list page (table). What would be aValidate and save before opening modalI have an edit page with a header action that opens a modal. I need to save (and validate) the currRefresh child selectsHello, when I have several nested selects in the filter. How do I make it so that when I choose the How to add an avatar as a result of a user search in the topbar?Hello. How to add an avatar as a result of a user search in the topbar?How to move the search field to the left side of the topbar?Hello How to move the search field to the left side of the topbar? I know there are hooks https://validationMessages not working for regex``` TextInput::make('discount_amount') ->regex('/^[0-9]+(\.[0-9]{2})$/i') text input field update based on another text inputI can't seem to get this working. I want to have one TextInput that's updated when another one is chwrite name using idin there i have company_id and i want using that write company_name how ican do it ? ``` TextColu