Posted by Frankly on 07/25/06 17:45

<laredotornado@zipmail.com> wrote in message
news:1153840770.299268.49940@b28g2000cwb.googlegroups.com...
> Hi, Using PHP 4, MySQL 4, I'm getting an error when executing an SQL
> statement:
>
> Statement failed "DELETE FROM USERS WHERE USER_ID = 17" - Cannot delete
> or update a parent row: a foreign key constraint fails
>
> How can I query the SQL database to figure out what parent row the
> statement is complaining about?
>
> Thanks,-


are both sides of the relationship indexed? from what i have read the
InnoDB engine is the first to need that rule and if you upgraded from
another engine ( if thats even possible ) perhaps it was over looked. i am
new so if anyone here corrects me i would listen to them.

Frank

• Next in forum: Re: How do I find out what foreign keys depend on this roy?
• Prev in forum: Re: How do I find out what foreign keys depend on this roy?
• Thread view: Re: How do I find out what foreign keys depend on this roy?

[Reply to this message]