Installed the latest dev this morning and getting the following error:
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'false' for column 'is_crawler' at row 1: UPDATE {browscap_statistics} SET counter=counter + 1, is_crawler=:db_update_placeholder_0 WHERE ( (parent = :db_condition_placeholder_0) ); Array ( [:db_update_placeholder_0] => false [:db_condition_placeholder_0] => Safari 5.0 ) in browscap_exit() (line 117 of /var/www/html/wiki/sites/all/modules/browscap/browscap.module).

CommentFileSizeAuthor
#5 browscap-fixError-1440512-5.patch573 bytesalbertski
#1 browscap-incorrect-int-value.patch480 bytesjzornig

Comments

jzornig’s picture

jzornig commented
StatusFileSize
new browscap-incorrect-int-value.patch480 bytes

patch to fix it

devin carlson’s picture

devin carlson commented
Status: Active » Closed (duplicate)

Thank you for the patch.

This issue is actually a duplicate of #664424: Values returned as bool with PHP < 5.3 should also be bool with PHP >= 5.3 as the error only occurs if you are using PHP 5.3 (due to the way Browscap currently parses browscap data under PHP >= 5.3).

I should have this fixed in a few hours, at which point I will do some testing and roll new stable releases of Browscap for Drupal 6 and 7.

rivimey’s picture

rivimey
she/her
commented

Still a problem for me: just updated

Browscap 7.x-1.3+0-dev 7.x-1.3 Up to date

and started seeing this error.

rivimey’s picture

rivimey
she/her
commented

Applying the patch above by hand to record.inc line 39 makes the error go away: I then disabled the module.

albertski’s picture

albertski commented
StatusFileSize
new browscap-fixError-1440512-5.patch573 bytes

I was able to reproduce this error locally only. Here is the 7.x-1.3 patch to fix this.