Can't get custom repositories working

Question

I'm following the Symfony2 tutorial (chapter 4), but I am having trouble retrieving the getLatestBlogs method from my custom repository.

I'm using Symfony 2.2 with Phar on Linux Mint.

I created the repository myself, but I am stumped. I get this error:

Undefined method 'getLatestBlogs'. The method name must start with either findBy or findOneBy! - BadMethodCallException

I have googled other similar questions but to no avail. Can anybody spot the error in my code?

Additional Info

My composer.json reads as follows :

"require": {
    "php": ">=5.3.3",
    "symfony/symfony": "2.2.0", ** NOTE : Originally read 2.2.* but I changed and successfully ran a composer update **
    "doctrine/orm": ">=2.2.3,<2.4-dev",
    "doctrine/doctrine-bundle": "1.2.*",
    "twig/extensions": "1.0.*",
    "symfony/assetic-bundle": "2.1.*",
    "symfony/swiftmailer-bundle": "2.2.*",
    "symfony/monolog-bundle": "2.2.*",
    "sensio/distribution-bundle": "2.2.*",
    "sensio/framework-extra-bundle": "2.2.*",
    "sensio/generator-bundle": "2.2.*",
    "jms/security-extra-bundle": "1.4.*",
    "jms/di-extra-bundle": "1.3.*",
    "doctrine/doctrine-fixtures-bundle": "dev-master",
    "doctrine/data-fixtures" : "dev-master"        
},

My src/Blogger/BlogBundle/Controller/PageController.php:

namespace Blogger\BlogBundle\Controller;

use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Blogger\BlogBundle\Entity\Enquiry;
use Blogger\BlogBundle\Form\EnquiryType;

class PageController extends Controller
{
    public function indexAction()
    {
        $em = $this->getDoctrine()
               ->getManager();

        $blogs = $em->getRepository('BloggerBlogBundle:Blog')->getLatestBlogs();

        return $this->render('BloggerBlogBundle:Page:index.html.twig', array(
            'blogs' => $blogs
        ));
    }

originally the lie and my src/Blogger/BlogBundle/Entity/Blog.php:

namespace Blogger\BlogBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Table(name="blog")
 * @ORM\Entity(repositoryClass="Blogger\BlogBundle\Repository\BlogRepository")
 * @ORM\HasLifecycleCallbacks()
 */
class Blog
{

and finally my src/Blogger/BlogBundle/Repository/BlogRepository.php:

namespace Blogger\BlogBundle\Repository;

use Doctrine\ORM\EntityRepository;

/**
 * BlogRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class BlogRepository extends EntityRepository
{

    public function getLatestBlogs($limit = null)
    {
        $qb = $this->createQueryBuilder('b')
                   ->select('b')
                   ->addOrderBy('b.created', 'DESC');

        if (false === is_null($limit))
            $qb->setMaxResults($limit);

        return $qb->getQuery()
                  ->getResult();
    }

}

well, you said you created the repository yourself, but your code shows the comment that the Doctrine command generate it?? — Wouter J, Mar 09 '13 at 19:08
It clearly states the method name is not following the convention. Try rename it to findByDate where Date is a column name of the entity. — Bart, Mar 09 '13 at 20:02
-Bart, I think that merely refers to magic methods :( @Bram, I deleted the contents of my cache folder but no luck. — prime, Mar 09 '13 at 20:28
Are you sure you have annotation mappings configured (not xml, yaml)? — Bram Gerritsen, Mar 09 '13 at 20:31
@BramGerritsen - Thankyou! Yes I had created a yaml file earlier on. Many thanks for your help, greatly appreciated. — prime, Mar 09 '13 at 20:43
@prime, you're welcome! I have posted an answer with a checklist. Also to help others who have a similar problem in the future. — Bram Gerritsen, Mar 09 '13 at 20:57

score 22 · Accepted Answer · answered Mar 09 '13 at 20:56

22

You can check the following to resolve this problem:

Make sure your FQCN in your annotation matches your classname of the repository file and you have set the right namespace.
Clear all metadata cache if you have this active or temporarily disable Doctrine caching.

app/console doctrine:cache:clear-metadata
Check if your mapping type is set to annotation in your configuration. i.e. if you have yml you have to define your repositoryClass in the yml file.

answered Mar 09 '13 at 20:56

Bram Gerritsen

7,178
4
35
45

Good call. I always use the entity generator with annotations, so I never thought about yml. You should have been a detective. :p – keyboardSmasher Mar 10 '13 at 15:02
For me #2 worked, had tried everything even restarting my vm! – Don Omondi Dec 02 '15 at 07:56

score 4 · Answer 2 · answered Oct 04 '14 at 13:00

4

My problem was the fact that the generated xml files kept overriding the annotations. I have read that annotations and other type of configuration cannot reside together, but forgot that mine was still present.

Make sure you have no entity definitions (i.e. SomeEntity.orm.xml) in src/xxxx/xxxBundle/Resources/config/doctrine

answered Oct 04 '14 at 13:00

Cornelius Parkin

331
2
6

Thanks, it was a useful tip. Doy you know how to avoid xml generation? – manuelbcd Feb 08 '16 at 08:01
I generated data from db do sf entity, first to xml and later I made conversion from xml to annotation and I was wondering why it doesn't want to work. Thanks to your answer I deleted all xml files and it started to work. – user3383675 Feb 19 '16 at 07:28

score 3 · Answer 3 · answered Jun 03 '15 at 13:42

3

My solution was to change the order of Entity annotations:

/**
* Comments
* 
* @ORM\Entity(repositoryClass="CmsBundle\Entity\CommentsRepository")
* @ORM\Table()
* @ORM\Entity    
*/

didn't work, but

/**
* Comments
* 
* @ORM\Table()
* @ORM\Entity
* @ORM\Entity(repositoryClass="CmsBundle\Entity\CommentsRepository")
*/

did work :)

answered Jun 03 '15 at 13:42

Fleskalebas

71
1
7

1

The second `@ORM\Entity` will override the first, you don't need the one that doesn't define the `repositoryClass`. – DanielM Jun 05 '15 at 13:59
Oh yeah...that's why the first ordering went wrong, because the (second) empty Entity was 'resetting' the first one...seems logical! – Fleskalebas Jun 06 '15 at 16:06

score -1 · Answer 4 · answered Mar 09 '13 at 20:00

-1

Try adding use Blogger\BlogBundle\Entity\Blog; to your controller.

answered Mar 09 '13 at 20:00

keyboardSmasher

2,661
18
20

Tried that but to no avail :( – prime Mar 09 '13 at 20:28

Can't get custom repositories working

4 Answers4

Linked