Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax

Question

Hello everyone I try to update to boolean in my table, so I had Error PDOException and I don't Why :

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax

My line code sql is this :

public function updateSignal(Comments $comment)
{
    $req = 'UPDATE Comments SET signal = TRUE WHERE idComments = :comment';
    $result = $this->getBdd()->prepare($req);
    $result->bindValue(':comment', $comment->getIdComments());

    return $result->execute();
}

I don't find where is my error syntax, Please need help Thanks

What is the return type of $comment->getIdComments() the "s" on comments makes it sound like a plural so it could return an array. Also can you confirm that $this->getBdd() is using the PDO class and not a library? — Zack
– Zack, Commented Dec 23, 2020 at 9:16

Tangentially Perpendicular · Accepted Answer · 2020-12-23 09:53:44Z

1

SIGNAL is a reserved word. It's best to avoid it, but you can use it if you wrap it in backticks.

$req = 'UPDATE Comments SET `signal` = TRUE WHERE idComments = :comment';

(MySQL reserved words)

answered Dec 23, 2020 at 9:53

Tangentially Perpendicular

5,4364 gold badges15 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tangentially Perpendicular Over a year ago

@AlprodGrm You're most welcome. Please remember to accept an answer by clicking the check mark

Collectives™ on Stack Overflow

Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related