php-schulung.de

Sonata Admin Filter: Invalid parameter number: Doctrine Entities

Solution: A solution has been posted to stack overflow: http://stackoverflow.com/questions/23527519/

Exception: Sonata Admin Filter: Invalid parameter number: number of bound variables does not match number of tokens

src/WF/ReviewBundle/Entity/Review.php

<?php

namespace WF\ReviewBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * Review
 *
 * @ORM\Table(name="review")
 * @ORM\Entity
 */
class Review
{
    /**
     * @var integer
     *
     * @ORM\Column(name="id", type="integer", nullable=false)
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(name="title", type="string", length=100, nullable=true)
     */
    private $title;

    /**
     * @var string
     *
     * @ORM\Column(name="comment", type="text", nullable=true)
     */
    private $comment;

    /**
     * @var \DateTime
     *
     * @ORM\Column(name="created_at", type="datetime", nullable=true)
     */
    private $createdAt;

    /**
     * @var \DateTime
     *
     * @ORM\Column(name="modified_on", type="datetime", nullable=true)
     */
    private $modifiedOn;

    /**
     * @var \Doctrine\Common\Collections\Collection
     *
     * @ORM\ManyToMany(targetEntity="WF\FocusBundle\Entity\Focus", inversedBy="review")
     * @ORM\JoinTable(name="review_has_focus",
     *   joinColumns={
     *     @ORM\JoinColumn(name="review_id", referencedColumnName="id")
     *   },
     *   inverseJoinColumns={
     *     @ORM\JoinColumn(name="focus_id", referencedColumnName="id")
     *   }
     * )
     */
    
    private $focus;

    /**
     * @var \StatusReview
     *
     * @ORM\ManyToOne(targetEntity="StatusReview")
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="status", referencedColumnName="status")
     * })
     */
    private $status;
    
    
    /**
     * @var string
     *
     * @ORM\Column(name="activation_code", type="string", length=100, nullable=true)
     */
    private $activationCode;
  
    // ...
}  


src/WF/ConsultantBundle/Entity/ConsultantHasReview.php

<?php

namespace WF\ConsultantBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * ConsultantHasReview
 *
 * @ORM\Table(name="consultant_has_review")
 * @ORM\Entity
 */
class ConsultantHasReview
{
    /**
     * @var \Consultant
     * @ORM\Id
     * @ORM\Column(name="id", type="integer", nullable=false)
     * @ORM\GeneratedValue(strategy="IDENTITY")
    */
    private $id;
    
    /**
     * @var \Consultant

     * @ORM\ManyToOne(targetEntity="\WF\ConsultantBillableBundle\Entity\Consultant")
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="consultant_id", referencedColumnName="id")
     * })
     */
    private $consultant;

    /**
     * @var \Review
     *

     * @ORM\OneToOne(targetEntity="\WF\ReviewBundle\Entity\Review")
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="review_id", referencedColumnName="id")
     * })
     */
    private $review;

    // ...
}



src/WF/InstituteBundle/Entity/OfficeHasInstitute.php

<?php

namespace WF\InstituteBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * OfficeHasInstitute
 *
 * @ORM\Table(name="office_has_institute")
 * @ORM\Entity
 */
class OfficeHasInstitute
{
    /**
     * @var \Office
     *
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="NONE")
     * @ORM\OneToOne(targetEntity="Office")
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="office_id", referencedColumnName="id")
     * })
     */
    private $office;

    /**
     * @var \Institute
     *
     * @ORM\ManyToOne(targetEntity="Institute")
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="institute_id", referencedColumnName="id")
     * })
     */
    private $institute;

    // ...   
}