partkeepr/PartKeepr — Issue #129: Unable to add parts to the project: FK constraint violation
Author: apex-
Created: 2012-01-07 11:11:27+00:00
State: open

When trying to add a part to the project I get the following SQL Exception

SQLSTATE[23503]: Foreign key violation: 7 ERROR: insert or update on table "projectpart" violates foreign key constraint "fk_b0b19336166d1f9c" DETAIL: Key (project_id)=(3) is not present in table "part".

Why is he trying to find the the project_id in table part?

This issue appies to nightly-20120106 and does NOT happen on a newly created database. Can't tell how to reproduce this right now.