Hi there I have a problem with doctrine in symfony.
I have the following entities:
/**
* FourTeachersSchuldruckBundle:Product
*
* @ORM\Entity
* @ORM\Table(name="product")
* @ORM\InheritanceType("JOINED")
* @ORM\DiscriminatorColumn(name="type", type="string")
* @ORM\DiscriminatorMap({"heft" = "ModuleProduct"})
* @ORM\HasLifecycleCallbacks
*/
abstract class Product {
// ....
}
/**
* @ORM\Entity
* @ORM\Table(name="product_module")
*/
class ModuleProduct extends Product {
/**
* @var \Doctrine\Common\Collections\Collection
* *@ORM\OneToMany(targetEntity="Module", mappedBy="product",
cascade={"all"}, orphanRemoval=true)*
* @ORM\OrderBy({"orderId" = "ASC"})
*/
private $modules;
}
/**
* @ORM\Entity
* @ORM\Table(name="module")
* @ORM\InheritanceType("JOINED")
* @ORM\DiscriminatorColumn(name="type", type="string")
*/
abstract class Module {
/**
* @var \FourTeachers\SchuldruckBundle\Entity\ModuleProduct
* @ORM\ManyToOne(targetEntity="ModuleProduct", inversedBy="modules")
* @ORM\JoinColumn(name="product_id", nullable=true)
*/
private $product;
}
Now when I try to delete a certain ModuleProduct entity, I get the
following error:
\DBALException: An exception occurred while executing 'DELETE FROM product
WHERE id = ?' with params [9]: SQLSTATE[23000]: Integrity constraint
violation: 1451 Cannot delete or update a parent row: a foreign key
constraint fails (`schuldruck`.`module`, CONSTRAINT `FK_C2426284584665A`
FOREIGN KEY (`product_id`) REFERENCES `product_module` (`id`))
Adding some debug messages to my DoctrineEventSubscriber and viewing the
logs I got the following result:
[2014-06-11 21:21:04] doctrine.DEBUG: SELECT t0.id AS id1, t0.message AS
message2, t0.param1 AS param13, t0.param2 AS param24, t0.module_id AS
module_id5 FROM module_error t0 WHERE t0.module_id = ? [51] []
[2014-06-11 21:21:04] doctrine.DEBUG: SELECT t0.text AS text1,
t0.product_id AS product_id2, t0.placeholder_id AS placeholder_id3 FROM
template_variable t0 WHERE t0.product_id = ? [51] []
*[2014-06-11 21:21:04] app.INFO: Deleting module 51 ["doctrine"] []*
[2014-06-11 21:21:04] doctrine.DEBUG: SELECT t0.id AS id1, t0.message AS
message2, t0.param1 AS param13, t0.param2 AS param24, t0.module_id AS
module_id5 FROM module_error t0 WHERE t0.module_id = ? [52] []
[2014-06-11 21:21:04] doctrine.DEBUG: SELECT t0.text AS text1,
t0.product_id AS product_id2, t0.placeholder_id AS placeholder_id3 FROM
template_variable t0 WHERE t0.product_id = ? [52] []
*[2014-06-11 21:21:04] app.INFO: Deleting module 52 ["doctrine"] []*
[2014-06-11 21:21:04] doctrine.DEBUG: SELECT t0.id AS id1, t0.message AS
message2, t0.param1 AS param13, t0.param2 AS param24, t0.module_id AS
module_id5 FROM module_error t0 WHERE t0.module_id = ? [54] []
[2014-06-11 21:21:04] doctrine.DEBUG: SELECT t0.id AS id1, t0.name AS
name2, t0.listed_calendar AS listed_calendar3 FROM calendar t0 WHERE t0.id
= ? ["42"] []
[2014-06-11 21:21:04] doctrine.DEBUG: SELECT t0.id AS id1, t0.start_date AS
start_date2, t0.end_date AS end_date3, t0.name AS name4, t0.overlay AS
overlay5, t0.calendar_id AS calendar_id6 FROM calendar_event t0 WHERE
t0.calendar_id = ? ORDER BY t0.start_date ASC [42] []
*[2014-06-11 21:21:04] app.INFO: Deleting module 54 ["doctrine"] []*
[2014-06-11 21:21:04] doctrine.DEBUG: SELECT t0.id AS id1, t0.message AS
message2, t0.param1 AS param13, t0.param2 AS param24, t0.module_id AS
module_id5 FROM module_error t0 WHERE t0.module_id = ? [53] []
[2014-06-11 21:21:04] doctrine.DEBUG: SELECT t0.text AS text1,
t0.product_id AS product_id2, t0.placeholder_id AS placeholder_id3 FROM
template_variable t0 WHERE t0.product_id = ? [53] []
*[2014-06-11 21:21:04] app.INFO: Deleting module 53 ["doctrine"]
[][2014-06-11 21:21:04] app.INFO: Deleting product... ["doctrine"] []*
[2014-06-11 21:21:04] doctrine.DEBUG: "START TRANSACTION" [] []
[2014-06-11 21:21:04] doctrine.DEBUG: DELETE FROM product_error WHERE id =
? [235] []
[2014-06-11 21:21:04] doctrine.DEBUG: DELETE FROM module_error WHERE id = ?
[428] []
*[2014-06-11 21:21:04] doctrine.DEBUG: DELETE FROM module WHERE id = ? [54]
[][2014-06-11 21:21:04] doctrine.DEBUG: DELETE FROM product WHERE id = ?
[9] []*
[2014-06-11 21:21:04] doctrine.DEBUG: "ROLLBACK" [] []
The "Deleting module..." and "Deleting product..." log-messages have been
logged in the preRemove listener.
This shows that modules 51, 52 and 53 were deleted *before* deletion of the
product.
But in spite of that just module 54 actually gets deleted before the
product, resulting in a constraint violation.
PLEASE HELP ME !
I don't know where to look for a solution any more.
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
