Using update_query with BIT(1) fields.

[nmalcolm]

Due to the way update_query (and, likely, insert_query) works, the following will always result in the field being 1 when the field is defined as datatype "Bit(1)":

$db->update_query( 'alert_settings', array( 'enabled' => 0, ), "id='{$id}'", 1 )

This is the database schema:

id int(10) code varchar(75) enabled bit(1)

This is, I believe, caused by the database class quoting the input even when it is numeric. A simple solution would be to check if input is an integer in the database method and not quote it if so.

Original report: http://dev.mybb.com/issues/2273
Reporter: Euan Torano
Status: New