Many to One Unidirectional relation in symfony2 has "No Association error"

421 views Asked by At

I am trying to create a many to one unidirectional relationship between two tables. dateTime and availibilityList are two entities, one list may have multiple date and time.

I added the annotations likewise in the entity dateTime but it is showing me this error:

{ code: 500 message: "[Semantical Error] line 0, col 84 near 'd WHERE d.offerAvailibilityId': Error: Class StreetBumb\ApiBundle\Entity\availibilityList has no association named dateTime" }

I updated my schema from the terminal by using this:

sudo php app/console doctrine:schema:update --force

It says : your database is already in sync with the current entity metadata.

dateTime Entity:

<?php

 namespace StreetBumb\ApiBundle\Entity;

 use Doctrine\ORM\Mapping as ORM;

/**
 * dateTime
 *
 * @ORM\Table()
 *   @ORM\Entity(repositoryClass="StreetBumb\ApiBundle\Entity\dateTimeRepository")
 */
  class dateTime
  {
  /**
   * @var integer
   *
   * @ORM\Column(name="id", type="integer")
   * @ORM\Id
   * @ORM\GeneratedValue(strategy="AUTO")
   */
  private $id;

  /**
 * @var \DateTime
 *
 * @ORM\Column(name="startDate", type="date")
 */
private $startDate;

/**
 * @var \DateTime
 *
 * @ORM\Column(name="endDate", type="date")
 */
private $endDate;

/**
 * @var \DateTime
 *
 * @ORM\Column(name="startTime", type="time")
 */
private $startTime;

/**
 * @var \DateTime
 *
 * @ORM\Column(name="endTime", type="time")
 */
private $endTime;

/**
 * @var string
 *
 * @ORM\Column(name="type", type="string", length=55)
 */
private $type;

/**
 * @var DateTime $offerAvailibilityId
 *
 * @ORM\ManyToOne(targetEntity="AvailibilityList")     
 * @ORM\JoinColumn(name="offerAvailibilityId", referencedColumnName="id")
 */
private $offerAvailibilityId;


/**
 * Get id
 *
 * @return integer 
 */
public function getId()
{
    return $this->id;
}

/**
 * Set startDate
 *
 * @param \DateTime $startDate
 * @return dateTime
 */
public function setStartDate($startDate)
{
    $this->startDate = $startDate;

    return $this;
}

/**
 * Get startDate
 *
 * @return \DateTime
 */
public function getStartDate()
{
    return $this->startDate;
}

/**
 * Set endDate
 *
 * @param \DateTime $endDate
 * @return dateTime
 */
public function setEndDate($endDate)
{
    $this->endDate = $endDate;

    return $this;
}

/**
 * Get endDate
 *
 * @return \DateTime 
 */
public function getEndDate()
{
    return $this->endDate;
}

/**
 * Set startTime
 *
 * @param \DateTime $startTime
 * @return dateTime
 */
public function setStartTime($startTime)
{
    $this->startTime = $startTime;

    return $this;
}

/**
 * Get startTime
 *
 * @return \DateTime 
 */
public function getStartTime()
{
    return $this->startTime;
}

/**
 * Set endTime
 *
 * @param \DateTime $endTime
 * @return dateTime
 */
public function setEndTime($endTime)
{
    $this->endTime = $endTime;

    return $this;
}

/**
 * Get endTime
 *
 * @return \DateTime 
 */
public function getEndTime()
{
    return $this->endTime;
}

/**
 * Set type
 *
 * @param string $type
 * @return dateTime
 */
public function setType($type)
{
    $this->type = $type;

    return $this;
}

/**
 * Get type
 *
 * @return string 
 */
public function getType()
{
    return $this->type;
}

/**
 * Set offerAvailibilityId
 *
 * @param integer $offerAvailibilityId
 * @return dateTime
 */
public function setOfferAvailibilityId($offerAvailibilityId)
{
    $this->offerAvailibilityId = $offerAvailibilityId;

    return $this;
}

/**
 * Get offerAvailibilityId
 *
 * @return integer 
 */
public function getOfferAvailibilityId()
{
    return $this->offerAvailibilityId;
}
}

The function in repository i am calling in controller.

    public function findOpeningDetailById($id)
{
    $qb = $this->getEntityManager()->createQueryBuilder()
        ->select('list')
        ->from('StreetBumbApiBundle:availibilityList', 'list')
        ->innerJoin('list.dateTime', 'd')
        ->where('d.offerAvailibilityId = :id')->setParameter('id', $id) //This line is showing error
        ->getQuery()->getResult();
    return $qb;
}

Is there any problem in my join query or the relation i made(Many to one) is incorrect? Please guide.. Thank you

0

There are 0 answers