Doctrine - orphan removal detection about sonataadminbundle HOT 6 CLOSED

Looks like its still an issue.

I have entity Comment and Comments Thread

class CommentsThread
{
    /**
     * @var integer $id
     *
     * @ORM\Column(name="id", type="integer", nullable=false)
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     */
    protected $id;
    /**
     * @var integer $commentsCounter
     *
     * @ORM\Column(name="comments_counter", type="integer", nullable=false)
     */
    protected $commentsCounter = 0;
    /**
     * @var boolean $isCommentsEnabled
     *
     * @ORM\Column(name="is_comments_enabled", type="boolean", nullable=false)
     */
    protected $isCommentsEnabled = true;
    /**
     * @ORM\OneToMany(targetEntity="ACME\BUNDLE\Entity\Comment", mappedBy="commentsThread", cascade={"all"},orphanRemoval=true)
     */
    public $comments;

I show related comments in commentsThread admin with code like

class CommentsThreadAdmin extends Admin
{
    protected function configureFormFields(FormMapper $formMapper)
    {
        $formMapper
            ->with('GeneralSection')
                
                ->add('comments','sonata_type_collection', array('by_reference' => false), array('edit' => 'inline','inline' => 'table','targetEntity'=>'Vido\CoreBundle\Entity\Comment'))
                ->add('isCommentsEnabled','checkbox',array('required'=>false))
            ->end()
        ;
    }

and related commentAdmin

class CommentAdmin extends Admin
{
    protected function configureFormFields(FormMapper $formMapper)
    {
        $formMapper
            ->with('GeneralSection')
                ->add("createdUser")
                ->add("createdAt")
                ->add('body',null, array('required'=>true))
            ->end()
        ;
    }

Update function works great :)
But when I select checkbox near some comment I got error

[1/2] PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`articles`, CONSTRAINT `FK_BFDD3168A16B7634` FOREIGN KEY (`comments_thread_id`) REFERENCES `comments_threads` (`id`)) 

    at PDOStatement ->execute (array('2'))
    in \vendor\doctrine-dbal\lib\Doctrine\DBAL\Connection.php at line 709  
    at Connection ->executeUpdate ('DELETE FROM comments_threads WHERE id = ?', array('2'))
    in \vendor\doctrine-dbal\lib\Doctrine\DBAL\Connection.php at line 432  -+

So its actually try to delete commentThread itself instead of checked for deletion comment :(

from sonataadminbundle.

This issue can be solve by using the related entity manager to delete/save/update the related object

from sonataadminbundle.

thanks for suggestion, but I dont get you though :(

Lets say, I have
Article with sonata_type_admin item of CommentsThread which have sonata_type_collection with Comments.
Near each comment there are checkbox for comments deletion.
When I check checkbox near comment entity - CommentsThread delete query created, which is wrong.
It seems to be a bug.

from sonataadminbundle.

The comment is about how to implement the fix in the AdminBundle.

from sonataadminbundle.

maybe Zhil has solved his issue but for those that are wondering:

      /**
      * {@inheritdoc}
      */
     public function setGalleryHasMedias($galleryHasMedias)
     {
          foreach ($galleryHasMedias as $galleryHasMedia) {
              $galleryHasMedia->setGallery($this);
          }

          $this->galleryHasMedias = $galleryHasMedias;
     }

this is the snippet you need. You must implement the setRelated in your parent Entity like this and it starts working.

from sonataadminbundle.

@rande Can you check this old issue?

from sonataadminbundle.