Twig and Symfony2 - Entity was not found Twig and Symfony2 - Entity was not found symfony symfony

Twig and Symfony2 - Entity was not found


Problem

Doctrine throws this Exception when it doesn't find the related entity. It seems redundant to say this, but in fact this is important.
It means it could find an ID related to it, but the request doctrine made didn't match any result.

My guess is that your database table (link table actually) submission.authors contains IDs of 0 instead of NULL.
With such, Doctrine thinks there IS an author with ID of 0, and therefor, cannot find it.

What happens

submission.authors always exists. It is an Uninitialized Doctrine Proxy.

var_dump($submission->getAuthors());

Would show you what contains exactly submission.authors
At this point, no queries are made. It simply returns a PersistentCollection with a flag isInitialized to false.

The exception occurs when you're trying to get a property out of it

foreach ($submission->getAuthors() as $author) {}

When doing this doctrine will check if getAuthors is initialized. If not, it will run the following query

SELECT <stuffs> FROM authors WHERE id = 0;

Which returns no match and will throw an EntityNotFound Exception

Fix

You must set your id row's default to NULL and make a query to update all 0's to NULL.
With this, you can easily test submission.authors with is not null

Doctrine will not run any query if it finds a NULL


How to debug to find which related entity was not found?

Exception message improved in repository https://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/Proxy/ProxyFactory.php#L160 but if you use older version you can do the following debugging.

If you use older version

Put following code to ProxyFactory class before throw new EntityNotFoundException(); line vendor/doctrine/orm/lib/Doctrine/ORM/Proxy/ProxyFactory.php:177

$entity = $classMetadata->getReflectionClass()->getShortName();$id = $classMetadata->getIdentifierValues($proxy)['id'];var_dump("$entity WHERE id = $id NOT FOUND.");exit;throw new EntityNotFoundException();


In your entity you can made something like this:

public function getSubmission(){    if($this->Submission->getId()==0) return null;    return $this->Submission;}