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

[yassineMessaoud9]

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

[greg0ire]

Just like performing an UPDATE statement in SQL requires a SET clause, doing it in DQL also requires it.

To change the field, you will need to do

$qb = $this->getEntityManager()
             ->createQueryBuilder()
             ->update(Utilisateur::class,'u')
             ->set('u.motpasse', ':password')
             ->where($qb->expr()->eq('u.email',':email'))
             ->setParameter('password',$password)
             ->setParameter('email',$email);