Symfony form with doctrine table other than getTable()->find() is not working

Question

I get a really anoying error when I try to edit an entry from a table, in tutorial they always use getTable()->find(), but I need to verify that the person logged in is the owner of that entry here what I did:

In the action:

  public function executeEdit(sfWebRequest $request)
  {
 $id = $request->getParameter('id');
 $userid = $this->getUser()->getGuardUser()->getId();
 $ad = Doctrine_Core::getTable('BambinbazarArticles')->getMyAd($id, $userid);
  $this->forward404Unless($ad, sprintf('Object bambinbazar_articles does not exist (%s).', $request->getParameter('id')));
  $this->form = new BambinbazarArticlesForm($ad);
 }

In the model:

 public function getMyAd($id, $userid)
 {
    $q = $this->createQuery('c')
      ->where('c.id = ? ', $id)
       ->addWhere('c.userid = ? ', $userid);

    return $q->execute();
}

I tried it with and without the ->execute(), did doctrine clean, cleared cache, rebuilded model,

Always get the same error 'The "%s" form only accepts a "%s" object. If I use the Doctrine_Core::getTable('BambinbazarArticles')->find() it work, but of course, i need more than that..

I am becoming crazy over this.

What happens if you try `return $q->execute()->getFirst();`? — Matt Gibson, Jan 11 '11 at 14:14

score 5 · Accepted Answer · answered Jan 11 '11 at 14:28

5

execute() can return multiple rows; effectively you're getting a recordset back, rather than the individual object that your form is expecting. Try fetching a single object, using, e.g.:

return $q->execute()->getFirst();

or

return $q->fetchOne();

answered Jan 11 '11 at 14:28

Matt Gibson

37,886
9
99
128

1

+1 because you commented before i answered, and we are most likely correct :-) – prodigitalson Jan 11 '11 at 14:32

score 3 · Answer 2 · answered Jan 11 '11 at 14:27

3

Its probably because your query is returning a Doctrine_Collection, not the actual Doctrine_Record youre expecting. Instead of execute use fetchOne.

public function getMyAd($id, $userid)
 {
    $q = $this->createQuery('c')
      ->where('c.id = ? ', $id)
      ->addWhere('c.userid = ? ', $userid)
      ->limit(1);

    return $q->fetchOne();
}

answered Jan 11 '11 at 14:27

prodigitalson

60,050
10
100
114

And +1 for getting to fetchOne() before I'd finished re-reading the documentation to find out what the function I was thinking of instead of getFirst() was called :) – Matt Gibson Jan 11 '11 at 16:02

Symfony form with doctrine table other than getTable()->find() is not working

2 Answers2