General error: 1366 Incorrect integer value: 'on' for column

I have a checkbox in a form named Relocate. In my MySQL table I have a field named Relocate type Boolean (tinyint(1)). I am getting this PDO Exception on an php execute statement containing

Code:

"Relocate => $Relocate


.
Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘on’ for column ‘Relocate’ at row 1′
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘on’ for column…

Read the entire article at the source link…

#codango #developer #development #coder #coding

We're happy to share this resource that we found. The content displayed on this page is property of it's original author and/or their organization.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*