Problem adding extended Goolge Map AdoDB error

Permalink Browser Info Environment
( ! ) Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1366: Incorrect integer value: '' for column 'infowindow' in D:\WWW\Klanten\stoxwear\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78 ( ! ) ADODB_Exception: mysql error: [1366: Incorrect integer value: '' for column 'infowindow' at row 1] in EXECUTE("INSERT INTO btExtendedGoogleMapLocations (bID, title, location, lon, lat, address, zipcode, city, country, iconID, infowindow, content) VALUES ('106', 'STOX Elsloo', '1', '', '', 'Stationsstraat 84', '6181 AK', 'Elsloo', 'Netherlands', '0', '', '')") in D:\WWW\Klanten\stoxwear\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78 Call Stack #TimeMemoryFunctionLocation 10.0006688072{main}( )..\index.php:0 20.0022810952require( 'D:\WWW\Klanten\stoxwear\concrete\dispatcher.php' )..\index.php:2 30.116217605920require( 'D:\WWW\Klanten\stoxwear\concrete\startup\process.php' )..\dispatcher.php:249 40.120518004768Collection->addBlock( )..\process.php:731 50.120518004816BlockType->add( )..\collection.php:696 60.138918238272ExtendedGoogleMapBlockController->save( )..\block_types.php:719 70.139718242520Database->query( )..\controller.php:204 80.139718242856Database->__call( )..\database.php:0 90.139718242904ADOConnection->Query( )..\database.php:75 100.139718242952ADOConnection->Execute( )..\adodb.inc.php:761 110.139718243000ADOConnection->_Execute( )..\adodb.inc.php:1012 120.140018243256adodb_throw( )..\adodb.inc.php:1037

Type: Discussion
Status: New
shenn
View Replies:
DeWebmakers replied on at Permalink Reply
DeWebmakers
Hi,

Sorry for the late reply! I was on a very nice holiday....

It seems that the addon is wrong installed.
Looks like a database problem.

Could you try to install the addon again.
Or refresh the database.

Best,

Corretje
shenn replied on at Permalink Reply
shenn
I did reinstall it, and refreshed databases. even on a fresh concrete5 installation I get this error.

tested in C5 version 5.4.2.1 and 5.4.2.2
shenn replied on at Permalink Reply
shenn
When I made 'infowindow' column a Varchar instead of a INT it works.

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.