Object of class Doctrine\ORM\PersistentCollection could not be converted to string

Question

I made a web application with Symfony2, in which a User has an array correlation ManytoMany with the entity Mission. The User can upload the entity $product through a form, and one of the data passed by the form is the mission associated to the user.

When I try to upload the data, appears the error:

ContextErrorException: Catchable Fatal Error: Object of class   
Doctrine\ORM\PersistentCollection could not be converted to string in     
C:\BitNami\wampstack-5.4.23- 
0\frameworks\symfony\vendor\doctrine\dbal\lib\Doctrine\DBAL\Statement.php line 103

It's clear that Doctrine don't know how to save the value of the mission.

How can I manage it?

I didn't know neither how to declare the mission object in my product entity. Now is simply like this:

/**
 * @var string
 *
 * @ORM\Column(name="mission", type="string", length=255)
 */
protected $mission;

UPDATE ---

My controller now is:

       $form = $this->createFormBuilder($product)
           ->add('name', 'text')
           ->add('mission', 'entity', array('required' => true, 'multiple' => false, 'class' => 'AcmeManagementBundle:Mission', 'query_builder' => function($repository) { return $repository->createQueryBuilder('c')->orderBy('c.id', 'ASC'); },))              
      //...
           ->add('save', 'submit')
           ->getForm(); 

UPDATE ---

Now works, but I have a problem. When appears the form to upload the $product object, appears also the ->add('mission', 'entity'... In this field I can see all the mission stored, and not only the ones associated with the user. How should I change my controller? I tried to change my controller like this:

       $product = new Product();
       $product->setMission($this->getUser()->getMission());

Solution

For manage a ManyToMany relation between User and Mission

in User.php:

/**
 * @var \Doctrine\Common\Collections\ArrayCollection
 * 
 * @ORM\ManyToMany(targetEntity="Your\SuperBundle\Entity\Mission", inversedBy="users", orphanRemoval=true)
 * @ORM\JoinTable(name="user_mission")
 */
private $missions;

in Mission.php:

/**
 * @var \Doctrine\Common\Collections\ArrayCollection
 *
 * @ORM\ManyToMany(targetEntity="Your\SuperBundle\Entity\User", mappedBy="missions", cascade={"all"}, orphanRemoval=true)
 */
private $users;

then for your form:

http://symfony.com/doc/current/reference/forms/types/collection.html for manage collection of Mission in your User form.

take a look at "type" and "allow_add"

Comments

[Gianni Alessandro]

Now works, but I have a problem. When appears the form to upload the $product object, appears also the ->add('mission', 'entity'... In this field I can see all the mission stored, and not only the ones associated with the user. How should I change my controller? I tried with ->add('mission','collection' .. but appears error.

[Vincent Barrault]

you want to create a new mission, or choose one already created ?

[Admin]

I have a similar problem here, Did it match for your problem? Thank you to help if you can.