[BUG] An error occurred while loading the query explanation.

[mehranhadidi]

I think there must be a bug on query explanation doctrine.

Doctrine ^1.6
Symfony 4.1.1

I have a simple find query with doctrine. When I run my code everything works just fine. But when I try to run query explain on profiler there is the error:

An error occurred while loading the query explanation.

I have googled it and a lot of people have the same issue. But there is no fix. Any solution?

[Ocramius]

Closing here - please open a new issue with more detailed information, examples, as well as what has been attempted so far, including tests that were written to uncover the issue.

[mehranhadidi]

@Ocramius This is just a simple find query. Its also working well but the issue is related to query explanation

Does it really needs to tests??

[Ocramius]

Well, it surely needs more debugging and searching for a root cause before reporting an issue 👍

[mehranhadidi]

Its a fresh Symfony project without any specific dependency that runs a simple select by 1 query. That's all.

[Ocramius]

Yes: as I said, report a bug after:

1. having identified a way to reproduce it precisely (steps that someone reading the issue can follow)
2. what is expected
3. what happens instead
4. what has been attempted to fix the problem
5. a test case that reproduces the bug, once identified

[mehranhadidi]

It looks like you just don't want to even try to listen. It's not something new problem if you google it (a lot of people are having the same issue without any fix). It also is easy to reproduce the issue, because it is occurring by default for every single query you run.

Testcase scenario:

1. Create a table with id, name
2. Run a simple query with params using doctrine like SELECT * FROM tablename where name=fieldname LIMIT 1;
3. Run your page and go profiler query tab.
4. Click on query explanation
   5:
   

Do you want me to share my code as a GitHub repository?
I am not your enemy and of course, I don't want to waste your time and community.
I found this error. I googled it and a lot of people are having the same issue. It might be related to doctrine version and Symfony.

Thanks :)

[Ocramius]

It looks like you just don't want to even try to listen

Mostly just struggling with all the issues being juggled, hence the request for more details, as well as isolated scenarios. No malice intended, just be aware that I answer a dozen of these a day, and only get to look at anything ince it's already well distilled.

Do you want me to share my code as a GitHub repository?

If you think sharing a repository would be the easiest reproducer, sure. The ideal case would be a setup from the first clone of the exact distribution and version of symfony you are using, and what you did from then on (line-by-line).

[mehranhadidi]

All right. I will try my best to reproduce the issue step by step with detailed information.

[yceruto]

FYI this was fixed in #802, merged but not released yet.