invalid sql generated

[digitalkaoz]

im having the following problem, getting this bundle to work:

here is my query:

            ->createQueryBuilder('geo')
            ->select('geo, GEO_DISTANCE(:latitude, :longitude, geo.lat, geo.lng) AS HIDDEN distance')
            ->having('distance <= :radius')
            ->setParameter('latitude', $latitude)
            ->setParameter('longitude', $longitude)
            ->setParameter('radius', $radius)
            ->orderBy('distance')

and got the following error:

QueryException: [Syntax Error] line 0, col 76: Error: Expected Doctrine\ORM\Query\Lexer::T_FROM, got 'distance'

what am i doing wrong?

[craue]

I can't spot anything wrong here. Which Doctrine version are you using? Could you try removing the HIDDEN keyword?

[digitalkaoz]

removing the HIDDEN keyword did it. so whats the doctrine version that should work with it?

[craue]

It was introduced with 2.2.

[digitalkaoz]

ok, i'll recheck what version i am using

[digitalkaoz]

ok it works with doctrine 2.2.*

maybe you should set a dependency on doctrine/dbal 2.2.*

[craue]

Not sure if either this or just adding a note on not using the HIDDEN keyword with < 2.2.

Which version have you been using before? Did it work well apart from that keyword?

[digitalkaoz]

2.1.7

[craue]

Added a note. Thank you for pointing this out.