StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSelecting random DB entry in Symfony2 - Getting an error
text
Body
copied!<p>I have been trying to pull out a random row, I have used this: </p> <p>This is the example code I found which did not really help ( I found here: <a href="https://gist.github.com/pierroweb/1518601" rel="nofollow">https://gist.github.com/pierroweb/1518601</a>)</p> <pre><code>class QuestionRepository extends EntityRepository { public function findOneRandom() { $em = $this->getEntityManager(); $max = $em->createQuery(' SELECT MAX(q.id) FROM EnzimQuestionBundle:Question q ') ->getSingleScalarResult(); return $em->createQuery(' SELECT q FROM EnzimQuestionBundle:Question q WHERE q.id >= :rand ORDER BY q.id ASC ') ->setParameter('rand',rand(0,$max)) ->setMaxResults(1) ->getSingleResult(); } } </code></pre> <p>Now I have something like this:</p> <pre><code> $em = $this->getEntityManager(); $max = $em->createQuery('SELECT MAX(p.id) FROM GreenMonkeyDevGlassShopBundle:Product p')->getSingleScalarResult(); return $em->createQuery('SELECT p FROM GreenMonkeyDevGlassShopBundle:Product p INNER JOIN (SELECT p2.categories. FROM GreenMonkeyDevGlassShopBundle:Product p.categories WHERE :cid IN(pc) p.id >= :rand ORDER BY p.id ASC') ->setParameter('cid', $category_id) ->setParameter('rand',rand(0,$max)) ->setMaxResults(intval($limit)) ->getSingleResult(); </code></pre> <p>I keep getting this error though: <code>FatalErrorException: Error: Call to undefined method Doctrine\ORM\Query\ResultSetMapping::addRootEntityFromClassMetadata() in /var/www/gmd-milkywayglass/src/GreenMonkeyDev/GlassShopBundle/Entity/CategoryRepository.php line 42</code></p> <p>Any thoughts on what I can be doing wrong? I know that Doctrine does not have a get random method. Maybe there is some simple solution? Thank you!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload