Agiles Arbeiten mit Scrum, Kanban usw. bildet seit Jahren meinen beruflichen Schwerpunkt. In diesem kurzen Blogpost können Sie mehr darüber erfahren.

Die übrigen Inhalte dienen als Museum (leider ohne die frühere schicke Optik).

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;

    // ...   
}