Foreign key constraint fail issue

[maxlethal]

I got this error while trying to import .sql file in PhpMyadmin.

Now when i try to delete anything related from my website portal i get this error.

My .sql database :
https://pastebin.com/NjXKf3YY

Help me fix this issue thank you

[r937]

@maxlethal

Now when i try to delete anything

ON DELETE RESTRICT is the default

gotta delete the studentquestion before you can delete the question

[maxlethal]

Sorry can you be more specific? i didn’t get you exactly.

What should i do to avoid “Sql query” error while importing .sql file into phpmyadmin?

[r937]

the error did not occur when you imported the .sql file

the error did not occur when you executed the .sql file

the error occurred when you tried to delete a question, while it still had a related studentquestion child row

[maxlethal]

@r937

the error did not occur when you imported the .sql file

Yes sql query error occured while importing.(Database imported successfully with this error shown in phpmyadmin)

[r937]

i’m sorry, i was looking at this part of your original post –

@maxlethal

Now when i try to delete anything related from my website portal i get this error.

[r937]

okay, here’s your problem…

the sql script loads some rows into only two tables – adminlogin and studentquestion

then it attempts to define the FK from studentquestion to question

this fails because there are no rows in the question table that correspond to the rows in studentquestion

solution? don’t load any data until all the keys are defined

[maxlethal]

@r937

don’t load any data until all the keys are defined

tq. I’ll try your suggestion.

[maxlethal]

@maxlethal

don’t load any data until all the keys are defined

This fixed my issue tq.

@r937

ON DELETE RESTRICT is the default

gotta delete the studentquestion before you can delete the question

And this helped me fix “why i can’t delete questions”.

Thank you.