I'm getting this error using the 7.x-2.0 version of Browscap with patch 1713570-schema-change applied.

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'false' for column 'alpha' at row 1: INSERT INTO {browscap} (useragent, data, comment, browser, version, majorver, minorver, platform, platform_version, alpha, beta, win16, win32, win64, frames, iframes, tables, cookies, backgroundsounds, javascript, vbscript, javaapplets, activexcontrols, ismobiledevice, issyndicationreader, crawler, cssversion, aolversion) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27); Array ( [:db_insert_placeholder_0] => DefaultProperties [:db_insert_placeholder_1] => a:26:{s:7:"comment";s:17:"DefaultProperties";s:7:"browser";s:17:"DefaultProperties";s:7:"version";s:3:"0.0";s:8:"majorver";s:1:"0";s:8:"minorver";s:1:"0";s:8:"platform";s:7:"unknown";s:16:"platform_version";s:7:"unknown";s:5:"alpha";s:5:"false";s:4:"beta";s:5:"false";s:5:"win16";s:5:"false";s:5:"win32";s:5:"false";s:5:"win64";s:5:"false";s:6:"frames";s:5:"false";s:7:"iframes";s:5:"false";s:6:"tables";s:5:"false";s:7:"cookies";s:5:"false";s:16:"backgroundsounds";s:5:"false";s:10:"javascript";s:5:"false";s:8:"vbscript";s:5:"false";s:11:"javaapplets";s:5:"false";s:15:"activexcontrols";s:5:"false";s:14:"ismobiledevice";s:5:"false";s:19:"issyndicationreader";s:5:"false";s:7:"crawler";s:5:"false";s:10:"cssversion";s:1:"0";s:10:"aolversion";s:1:"0";} [:db_insert_placeholder_2] => DefaultProperties [:db_insert_placeholder_3] => DefaultProperties [:db_insert_placeholder_4] => 0.0 [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => unknown [:db_insert_placeholder_8] => unknown [:db_insert_placeholder_9] => false [:db_insert_placeholder_10] => false [:db_insert_placeholder_11] => false [:db_insert_placeholder_12] => false [:db_insert_placeholder_13] => false [:db_insert_placeholder_14] => false [:db_insert_placeholder_15] => false [:db_insert_placeholder_16] => false [:db_insert_placeholder_17] => false [:db_insert_placeholder_18] => false [:db_insert_placeholder_19] => false [:db_insert_placeholder_20] => false [:db_insert_placeholder_21] => false [:db_insert_placeholder_22] => false [:db_insert_placeholder_23] => false [:db_insert_placeholder_24] => false [:db_insert_placeholder_25] => false [:db_insert_placeholder_26] => 0 [:db_insert_placeholder_27] => 0 ) in _browscap_import() (line 137 of /home/zerocarb/public_html/sites/all/modules/browscap/import.inc).

Comments

mondrake’s picture

greggles’s picture

Status: Active » Fixed

Further, that is about the database schema in #1713570: Change Browscap database schema to match the columns defined in the default XML schema from the browscap data which is not officially supported yet.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.