Doctrine 1
  1. Doctrine 1
  2. DC-1054

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.title' in 'field list'

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      window vista

      Description

      this is the my table creation .

      CREATE TABLE billboard(id BIGINT AUTO_INCREMENT,title VARCHAR (255),country_id BIGINT,zone_id BIGINT,place VARCHAR(255),occassion VARCHAR(255),itinerary VARCHAR(255),created_at DATETIME NOT NULL,description TEXT NOT NULL,PRIMARY KEY(id)) ENGINE=INNODB;

      public static function getInstance()

      { return Doctrine_Core::getTable('Billboard'); }

      this is the my Doctrine Table

      // public function getBillboardsForAUser($userId, $limit, $offset=0)
      public function getBillboardsForAUser($userId,$limit,$offset=0)
      {
      $query = $this->createQuery('b')
      ->where('b.title=?',$title);
      // ->where('b.owner_id = ?', $userId);
      $followings = Doctrine::getTable('Follow')->getAllFollowing($userId);
      foreach($followings as $following)

      { $query->orWhere('b.owner_id = ? ',$following->getOwnerId()); $query->orWhere('b.poster_id = ? ',$following->getOwnerId()); }

      $query->orderBy('b.created_at DESC')
      ->limit($limit)
      ->offset($offset);
      return $query->execute();

      }

      plz help me what is the problem.

        Activity

        suriyakala created issue -
        Benjamin Eberlei made changes -
        Field Original Value New Value
        Project Doctrine 2 - ORM [ 10032 ] Doctrine 1 [ 10031 ]
        Key DDC-1744 DC-1054
        Issue Type Documentation [ 6 ] Bug [ 1 ]
        Security All [ 10000 ]
        Component/s DQL [ 10014 ]

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            suriyakala
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: