Error: Class ... has no field or association named

Question

I'm having this issue when I upload the files to the server.

Error: Class Prizes\PrizesBundle\Entity\Category has no field or association named order_cat

My Category Class:

    <?php

namespace Prizes\PrizesBundle\Entity;
use Doctrine\ORM\Mapping as ORM;
use Gedmo\Mapping\Annotation as Gedmo;

/**
 * @ORM\Entity 
 * @ORM\Table(name="category")
 */
class Category
{
  /**
   * @ORM\Id
   * @ORM\Column(type="integer")
   * @ORM\GeneratedValue(strategy="AUTO")
   */
  private $id;

  /**
   * @Gedmo\Translatable
   * @ORM\Column(type="string", length=45, nullable=false)
   */
  private $name;

  /**
   * @Gedmo\Translatable
   * @ORM\Column(type="string", length=45, nullable=false)
   */
  private $description;

  /**
   * @ORM\Column(type="string", length=255, nullable=false)
   */
  private $thumb;

  /**
   * @ORM\Column(type="string", length=255, nullable=false)
   */
  private $img;

  /**
   * @ORM\ManyToOne(targetEntity="Optime\AppStatusBundle\Entity\Status")
   * @ORM\JoinColumn(name="status", referencedColumnName="id")
   */
  private $status;

  /**
   * @Gedmo\Timestampable(on="create")
   * @ORM\Column(type="datetime")
   */
  private $created;

  /**
   * @Gedmo\Timestampable(on="update")
   * @ORM\Column(type="datetime")
   */
  private $modified;

  /**
   * @ORM\ManyToMany(targetEntity="Prize")
   * @ORM\JoinTable(name="prize_has_category",
   *      joinColumns={@ORM\JoinColumn(name="category", referencedColumnName="id")},
   *      inverseJoinColumns={@ORM\JoinColumn(name="prize", referencedColumnName="id")}
   *      )
   */
  private $prizes;

  /**
   * @Gedmo\Locale
   * Used locale to override Translation listener`s locale
   * this is not a mapped field of entity metadata, just a simple property
   */
  private $locale;
  /**
   * @Gedmo\Translatable
   * @ORM\Column(type="string", length=45, nullable=false)
   */
  private $order_cat;
  //    /**
  //     * @Gedmo\TreeLeft
  //     * @ORM\Column(name="lft", type="integer")
  //     */
  //    private $lft;

  //    /**
  //     * @Gedmo\TreeLevel
  //     * @ORM\Column(name="lvl", type="integer")
  //     */
  //    private $lvl;

  //    /**
  //     * @Gedmo\TreeRight
  //     * @ORM\Column(name="rgt", type="integer")
  //     */
  //    private $rgt;

  //    /**
  //     * @Gedmo\TreeRoot
  //     * @ORM\Column(name="root", type="integer", nullable=true)
  //     */
  //    private $root;

  //    /**
  //     * @Gedmo\TreeParent
  //     * @ORM\ManyToOne(targetEntity="Category", inversedBy="children")
  //     * @ORM\JoinColumn(name="parent_id", referencedColumnName="id", onDelete="SET NULL")
  //     */
  //    private $parent;

  //    /**
  //     * @ORM\OneToMany(targetEntity="Category", mappedBy="parent")
  //     * @ORM\OrderBy({"lft" = "ASC"})
  //     */
  //    private $children;

  public function __construct( )
  {
    $this->prizes = new \Doctrine\Common\Collections\ArrayCollection( );
  }

  public function getId( )
  {
    return $this->id;
  }

  public function setName( $name )
  {
    $this->name = $name;
  }

  public function getName( )
  {
    return $this->name;
  }

  public function setDescription( $description )
  {
    $this->description = $description;
  }

  public function getDescription( )
  {
    return $this->description;
  }

  public function setThumb( $thumb )
  {
    $this->thumb = $thumb;
  }

  public function getThumb( )
  {
    return $this->thumb;
  }

  public function setImg( $img )
  {
    $this->img = $img;
  }

  public function getImg( )
  {
    return $this->img;
  }

  public function setStatus( \Optime\AppStatusBundle\Entity\Status $status )
  {
    $this->status = $status;
  }

  public function getStatus( )
  {
    return $this->status;
  }

  public function getCreated( )
  {
    return $this->created;
  }

  public function getModified( )
  {
    return $this->modified;
  }

  public function getPrizes( )
  {
    return $this->prizes;
  }

  public function getOrderCat(){
      return $this->order_cat;
  }

  public function setOrderCat($order_cat){
      $this->order_cat = $order_cat;
  }

  static public function getListDQL( )
  {
    return "SELECT cat FROM " . Category::getFQCN( ) . " cat
                        WHERE cat.status = 1";
  }

  static public function getFQCN( )
  {
    return 'Prizes\PrizesBundle\Entity\Category';
  }
}

This is how I'm building the form

public function buildForm( FormBuilder $builder, array $options )
{
    $query = new QueryBuilder( $this->em);
    $query->addSelect( 's' )->from( Status::getFQCN( ), 's' )->join( 's.status_entity', 'se' )->where( "se.name = 'Prize'" );
    $builder->add( 'status', 'entity', array ( 'class' => 'AppStatusBundle:Status', 'property' => 'name', 'query_builder' => $query, "required" => false, 'empty_value' => ' - SELECT - ') );
    $builder->add( 'name', 'text', array ( "required" => false) );
    $builder->add( 'country', 'entity',array ('class' => 'CSCBundle:SystemCountry', 'property' => 'country.name', "required" => false, 'empty_value' => ' - SELECT - ') );
    $builder->add( 'category', 'entity', array ('class' => 'PrizesBundle:Category', 'property' => 'name', "required" => false, 'empty_value' => ' - SELECT - ', 'query_builder' => 
                function(EntityRepository $er) {
                        return $er->createQueryBuilder('c')->join( 'c.status', 's' )->where( "s.name = 'Alive'")
                            ->orderBy('c.order_cat', 'ASC');
                },) );
    $builder->add('brand', 'entity', array ( 'class' => 'PrizesBundle:Brand', 'property' => 'name', "required" => false, 'empty_value' => ' - SELECT - ') );
}

I used to have

return "SELECT cat FROM " . Category::getFQCN( ) . " cat
                        WHERE cat.status = 1 ORDER BY cat.order_cat"

instead of this

SELECT cat FROM " . Category::getFQCN( ) . " cat
                        WHERE cat.status = 1

but when I try that, I get [Semantical Error] line 0, col 108 near 'order_cat AS': Error: Class Prizes\PrizesBundle\Entity\Category has no field or association named order_cat

What am I doing wrong? How can I fix this? I already deleted the cache and verified the files.

EDIT: I need an answer to both errors.

Answer 1

You code looks ok. You could try this:

Field named order_cat is private so it might be that due to reflection's limitation this field cannot be accessed directly but only via getters/setters.

Have you tried ORDER BY cat.orderCat instead?