GROUP_CONCAT + concat about doctrine-extensions HOT 6 CLOSED

Hi. Need to test

from doctrine-extensions.

It looks that it will need some alterations on lexer... :( don't know if it's viable.

from doctrine-extensions.

ah, after some debate with other people of them, it turns that I don't needed the concat inside group concat. But I'm having another issue right now. When running the code in production, I got this:

[2015-02-04 12:34:33] request.CRITICAL: Uncaught PHP Exception Doctrine\ORM\Query\QueryException: "[Syntax Error] line 0, col 337: Error: Expected known function, got 'GROUP_CONCAT'" at /Users/waltercruz/devel/dialogos-setoriais/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 52 {"exception":"[object](Doctrine\ORM\Query\QueryException%28code: 0%29: [Syntax Error] line 0, col 337: Error: Expected known function, got 'GROUP_CONCAT' at /Users/waltercruz/devel/dialogos-setoriais/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:52, Doctrine\ORM\Query\QueryException%28code: 0): SELECT convocation.name as convocation_name,\n a.id,\n dialog.name as dialog_name, \n a.name,\n a.code,\n a.status,\n a.type,\n a.pathAgreement as path_agreement,\n a.pathGreenlight as path_greenlight, \n a.pathNonObjection as path_non_objection, GROUP_CONCAT( DISTINCT institutionslocais.abbreviation SEPARATOR '/') as locais, GROUP_CONCAT( DISTINCT institutionsexternals.abbreviation SEPARATOR '/') as externals FROM Dialog\ActionBundle\Entity\Action a INNER JOIN a.institutions institutionslocais INNER JOIN a.institutions institutionsexternals INNER JOIN a.dialog dialog INNER JOIN a.convocation convocation WHERE institutionslocais.institutionType = 1 AND institutionsexternals.institutionType = 2 AND a.type = :type GROUP BY a.id,dialog.name,a.name, a.code, convocation_name, a.status, a.type, a.pathAgreement, a.pathGreenlight, a.pathNonObjection at /Users/waltercruz/devel/dialogos-setoriais/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41)"} []

there's some another conf to register the dql function on prod environment?

from doctrine-extensions.

Seems that GROUP_CONCAT does not added. There are no differences between dev and prod. Please, make sure you have added doctrine configuration to convig.yml and config_dev.yml includes it

from doctrine-extensions.

hum... it works with:

$kernel = new AppKernel('prod', true);

but don't

$kernel = new AppKernel('prod', false);

from doctrine-extensions.

ok, just a cache warmup :)

from doctrine-extensions.