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…

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