"No result was found for query although at least one row was expected." Query should display records though in Symfony

Question

I'm trying to retrieve content using two items in the URL. Here is the php/symfony code that should do it:

    $em = $this->getDoctrine()->getEntityManager();

    $repository = $this->getDoctrine()
        ->getRepository('ShoutMainBundle:Content');

    $query = $repository->createQueryBuilder('p')
        ->where('p.slug > :slug')
        ->andWhere('p.subtocontentid > :parent')
        ->setParameters(array(
                    'slug' => $slug,
                    'parent'  => $page
                ))
        ->getQuery();

    $content = $query->getSingleResult();

However, when this code is executed it returns the following error:

No result was found for query although at least one row was expected.

I have done some tests, and the data held in the $slug and $page variables hold the correct information. I have also tested the MySQL query and the query brings up the desired result, which confuses me further.

Have I missed something?

score 8 · Answer 1 · edited May 23 '17 at 12:00

As it was answered here

You are getting this error because you are using the getSingleResult() method. it generates an Exception if it can't find even a single result. you can use the getOneOrNullResult() instead to get a NULL if there isn't any result from the query.

Query#getSingleResult(): Retrieves a single object. If the result contains more than one object, an NonUniqueResultException is thrown. If the result contains no objects, an NoResultException is thrown. The pure/mixed distinction does not apply.

score 4 · Answer 2 · answered Jul 30 '14 at 13:33

No result was found for query although at least one row was expected.

Another reason could be:

You did this

$query = $this->getEntityManager()
            ->createQuery('
                SELECT u FROM MyBundle:User u
                WHERE u.email = :email')
            ->setParameter('email', $email);

return $query->getSingleResult();

Instead of this

$query = $this->getEntityManager()
            ->createQuery('
                SELECT u FROM MyBundle:User u
                WHERE u.email = :email')
            ->setParameter('email', $email);

$query->setMaxResults(1);

return $query->getResult();

score 3 · Accepted Answer · answered Aug 19 '11 at 15:42

3

Don't you want to use "=" instead of ">" ?

answered Aug 19 '11 at 15:42

futurecat

858
7
14

I didn't even notice that! There is a head shape dent in the wall now. Thank you for that! – mickburkejnr Aug 19 '11 at 15:47

score 2 · Answer 4 · edited Apr 07 '19 at 07:48

2

If you've got this message because used

$content = $query->getSingleResult();

you can just replace it with the row below

$content = $query->getOneOrNullResult(AbstractQuery::HYDRATE_SINGLE_SCALAR) ?? 0;

edited Apr 07 '19 at 07:48

David

5,882
3
33
44

answered Apr 07 '19 at 07:25

muinh

535
6
14

No, actually I meant SingleScalarResult as a partial case of this problem. I wrote this because I got this page as a result in google search – muinh Apr 08 '19 at 08:23

"No result was found for query although at least one row was expected." Query should display records though in Symfony

4 Answers4