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;
// ...
}