Re: Foreign Key Constraint Fails on Insert During Transaction

[Sukhwinder Singh]

I also faced the same problem.

I was using three tables.

start transaction

Insert into category table - get newly inserted id (auto increment) as category_id
Insert into product table - get newly inserted id (auto_increment) as product_id

Insert into product_category (product_id, category_id) (foreign key constraints referring to product.id and category.id) - And it FAILED.

I finally found out that I had renamed the category table to category_old and foreign key in product was still referring to category_old table and not new category table.



Edited 1 time(s). Last edit at 08/07/2008 05:08PM by Sukhwinder Singh.