With a fresh install of beta 4 you get the following error when creating a new location

Unknown column `latlng` in `field list` query: INSERT INTO gmap_blocks_locations (address, city, state, country, marker, use_icon, icon_path, info, format, directions, latlng) VALUES (`1 George St`, `Brisbane`, `QLD`, `Australia`, 1, 0, ``, ``, 2, 0, ``)
CommentFileSizeAuthor
#1 gmap_blocks.573374.patch717 bytessutharsan
gmap_blocks.install.patch414 bytesmstrelan

Comments

sutharsan’s picture

sutharsan commented
Status: Active » Reviewed & tested by the community
StatusFileSize
new gmap_blocks.573374.patch717 bytes

Slightly revised patch attached which adds a description to the field.

skilip’s picture

skilip commented
Status: Reviewed & tested by the community » Fixed

Committed as well. Thanks!

Status: Fixed » Closed (fixed)

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

afdiaz’s picture

afdiaz commented

I've applied both patches without success! However, maybe I've patched it in the wrong way?:

[sites/all/modules/gmap_blocks]# patch < gmap_blocks.install.patch 
patching file gmap_blocks.install
Hunk #1 succeeded at 135 with fuzz 2 (offset 6 lines).
[sites/all/modules/gmap_blocks]#

I'm getting the same error:

user warning: Unknown column 'latlng' in 'field list' query: INSERT INTO gmap_blocks_locations (address, city, state, country, marker, use_icon, icon_path, info, format, directions, latlng) VALUES ('1, Grandplace', 'Brussels', '', 'Belgium', 1, 0, '', '', 2, 0, 'a:2:{s:3:\"lng\";d:4.419752700000000089630702859722077846527099609375;s:3:\"lat\";d:50.83690550000000030195224098861217498779296875;}') in /var/www/html/Mydomain/public/sites/all/modules/gmap_blocks/gmap_blocks.module on line 332.
mstrelan’s picture

mstrelan commented

@afdiaz - You need to patch it before installing the module. Disable the module, then uninstall it. Then patch it and install it again.

nd_macias’s picture

nd_macias commented

For those, who have some problems with installing patch. You can also add manually 'latlng' field in 'gmap_blocks_location' setting it just as in patch (varchar, 255, not null) in drupal database. Works fine for me, as I couldn't manage to install patch properly. :)