[Syntax Error] line 0, col 32: Error: Expected Doctrine\ORM\Query\Lexer::T_SET, got 'WHERE' #6958

New Issue

admin · 2026-01-22T15:42:09+01:00

admin commented

2026-01-22 15:42:09 +01:00

Originally created by @yassineMessaoud9 on GitHub (Apr 10, 2022).

I am using a Symfony 4 project, and I want to change the user password, so I created a method in my repository and called it to the controller, but this error it diplay to me,

[Syntax Error] line 0, col 32: Error: Expected Doctrine\ORM\Query\Lexer::T_SET, got 'WHERE'

Repository Method

` public function updateU($password,$email): ?Utilisateur
{
$qb = $this->getEntityManager()
->createQueryBuilder()
->update(Utilisateur::class,'u');
$qb
->where($qb->expr()->eq('u.motpasse',':password'))
->andWhere($qb->expr()->eq('u.email',':email'))
->setParameter('password',$password)
->setParameter('email',$email);

return $qb->getQuery()->getResult();

}
`

Controller Method
`/**

@Route("/Reset", name="Reset")
Method({"GET"})
*/
public function New(
Request $request,
UtilisateurRepository $URe,
UserPasswordEncoderInterface $userPasswordEncoder,
EntityManagerInterface $entityManager,
MailerInterface $mailer
) {
$o = '';
$Varmail = $_GET['email'];

$user = new Utilisateur($o);
$form = $this->createFormBuilder($user)
->add('password', PasswordType::class)
->getForm();
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid()) {
$to = $Varmail;
$sujet = 'Password Changed';
$Message = "Bonjour $Varmail Votre password est changé !";
$pass = $user->setPassword(
$userPasswordEncoder->encodePassword(
$user,
$form->get('password')->getData()
)
);
```
 $URe->updateU($pass, $Varmail);

 $Mai = new MailerController();
 $Mai->sendEmail($mailer, $to, $sujet, $Message);
```
}
return $this->render('modifier_mdp/index.html.twig', [
'form' => $form->createView(),
]);
}
`

How can i solve it , And Thanks

Originally created by @yassineMessaoud9 on GitHub (Apr 10, 2022). I am using a Symfony 4 project, and I want to change the user password, so I created a method in my repository and called it to the controller, but this error it diplay to me, `[Syntax Error] line 0, col 32: Error: Expected Doctrine\ORM\Query\Lexer::T_SET, got 'WHERE' ` **Repository Method** ` public function updateU($password,$email): ?Utilisateur { $qb = $this->getEntityManager() ->createQueryBuilder() ->update(Utilisateur::class,'u'); $qb ->where($qb->expr()->eq('u.motpasse',':password')) ->andWhere($qb->expr()->eq('u.email',':email')) ->setParameter('password',$password) ->setParameter('email',$email); return $qb->getQuery()->getResult(); } ` **Controller Method** `/** * @Route("/Reset", name="Reset") * Method({"GET"}) */ public function New( Request $request, UtilisateurRepository $URe, UserPasswordEncoderInterface $userPasswordEncoder, EntityManagerInterface $entityManager, MailerInterface $mailer ) { $o = ''; $Varmail = $_GET['email']; $user = new Utilisateur($o); $form = $this->createFormBuilder($user) ->add('password', PasswordType::class) ->getForm(); $form->handleRequest($request); if ($form->isSubmitted() && $form->isValid()) { $to = $Varmail; $sujet = 'Password Changed'; $Message = "Bonjour $Varmail Votre password est changé !"; $pass = $user->setPassword( $userPasswordEncoder->encodePassword( $user, $form->get('password')->getData() ) ); $URe->updateU($pass, $Varmail); $Mai = new MailerController(); $Mai->sendEmail($mailer, $to, $sujet, $Message); } return $this->render('modifier_mdp/index.html.twig', [ 'form' => $form->createView(), ]); } ` **How can i solve it , And Thanks**

admin closed this issue

2026-01-22 15:42:10 +01:00

admin referenced this issue

2026-01-22 16:06:55 +01:00

[PR #6958] Remove impossible-to-hit condition #10242

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#6958