How to fix, Invalid text representation: 7 ERROR: invalid input syntax for type boolean?

Question

PHP

I got all the records from the database, I immediately write them back (update .. )
an error appears:
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type boolean: ""' in
I can’t understand what the error is, strange that such error not with all records, and with some. And I can't figure out what's wrong. help me please

Answer 1

Apparently, you are trying to cram a string or character into a boolean column. Check your query and check the table structure.