How to see the query and find the sql syntax error - Symfony2

Question

I'm using Symfony2 and I get an error:

[Syntax Error] line 0, col 70: Error: Expected =, <, <=, <>, >, >=, !=, got 'AND'

when I click on the button in the toolbar to see the queries it says that they are 4, but I see only 3 of them and there is nothing containing 'AND'. My question is where I can find this line 0, col 70 and how can I see the wrong query in order to be able to fix it?

Cyprian · Accepted Answer · 2012-09-12 07:09:22Z

1

You should be able to figure out the place where error happens basing on symfony exception backtrace.

For see what sql has been executed just after you create your query, you can use getSQL() method on Query object.

For query builder:

$sqlString = $qb->methodsToCreateQuery()
   ->getQuery()
   ->getSQL;

or for DQL:

$sqlString = $em->createQuery("some DQL query")->getSQL();

answered Sep 12, 2012 at 7:09

Cyprian

11.4k1 gold badge52 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to see the query and find the sql syntax error - Symfony2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related