Details
Description
This is the error that i get when i try to create new entity Employee
$newEmployee = new Users_Entity_Model_Employee; //here i set the data ..... $em->persist($newEmployee); $em->flush();
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`crm/Employees`, CONSTRAINT `employee_person` FOREIGN KEY (`contactID`) REFERENCES `Persons` (`contactID`) ON DELETE NO ACTION ON UPDATE NO ACTION)
/** * * @Entity * @InheritanceType("JOINED") * @Table(name="Contacts") * @DiscriminatorColumn(name="contactType", type="string") * @DiscriminatorMap({"PERSON" = "Users_Model_Entity_Person", "COMPANY" = "Users_Model_Entity_Company", "EMPLOYEE" = "Users_Model_Entity_Employee", "FIRM" = "Users_Model_Entity_Firm"}) */ class Users_Model_Entity_Contacts { /** * @Id @Column(name="contactID", type="integer") * @GeneratedValue(strategy="AUTO") * */ protected $contactID; // ... } /** * * @Table(name="Persons") * @entity(repositoryClass="Users_Model_PersonRepo") */ class Users_Model_Entity_Person extends Users_Model_Entity_Contacts { // ... } /** * * @Table(name="Employees") * @entity */ class Users_Model_Entity_Employee extends Users_Model_Entity_Person { // ..... }