SQLSTATE[42000]: Syntax error or access violation

[manjava]

Hello,

I do this Script the Doctrine on zend Framework 2

$qb = $entityManager->createQueryBuilder ();
            $qb->select ( 'g' )->from ( 'Synchro\Entity\Group', 'g' )->where ( 'g.namegroup = :namegroup' )->setParameter ('namegroup', $nameGroup );
            $query = $qb->getQuery ();
            try {
                $checkgroup = $query->getResult();
 
                if(!empty($checkgroup)){
 
                    return $checkgroup[0]->getIdgroup();
                }
            } catch (\Doctrine\ORM\NoResultException $e) {
                return null;
            }

I have this Error :

SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe près de 'group g0_ WHERE g0_.nameGroup = 'GroupPOUR TOUTE INFORMATION'' à la ligne 1
How can i resolve This Issue ? Thanks In advance

[Dormilich]

group is part of the GROUP BY keyword and as such not a valid table name (unless you quote it correctly, but I don’t know how to tell Doctrine to do that).

tl;dr "group" is a very bad choice for a table name