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 { // ..... }
Activity
Roman S. Borschel
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 2.0-BETA4 [ 10072 ] | |
| Fix Version/s | 2.0-BETA2 [ 10050 ] |
victor Velkov
made changes -
| Attachment | testDoc.sql [ 10729 ] | |
| Attachment | DDC732Test.php [ 10730 ] |
victor Velkov
made changes -
| Affects Version/s | 2.0-BETA3 [ 10060 ] | |
| Affects Version/s | 2.0-BETA2 [ 10050 ] |
Benjamin Eberlei
made changes -
| Priority | Critical [ 2 ] | Minor [ 4 ] |
| Fix Version/s | 2.0-RC1 [ 10091 ] | |
| Fix Version/s | 2.0-BETA4 [ 10072 ] |
Benjamin Eberlei
made changes -
| Status | Open [ 1 ] | Resolved [ 5 ] |
| Resolution | Cannot Reproduce [ 5 ] |
victor Velkov
made changes -
| Resolution | Cannot Reproduce [ 5 ] | |
| Status | Resolved [ 5 ] | Reopened [ 4 ] |
Benjamin Eberlei
made changes -
| Status | Reopened [ 4 ] | Resolved [ 5 ] |
| Assignee | Roman S. Borschel [ romanb ] | Benjamin Eberlei [ beberlei ] |
| Resolution | Fixed [ 1 ] |
Benjamin Eberlei
made changes -
| Workflow | jira [ 11730 ] | jira-feedback [ 14526 ] |
Benjamin Eberlei
made changes -
| Workflow | jira-feedback [ 14526 ] | jira-feedback2 [ 16390 ] |
Benjamin Eberlei
made changes -
| Workflow | jira-feedback2 [ 16390 ] | jira-feedback3 [ 18643 ] |