GoogleMap addon 2.0 (formerly known as JBGMAP) PP1.6 ONLY

[Dennis]

THIS VERSION IS NOT COMPATIBLE WITH JBGMAP. IT WILL HOWEVER UPDATE EVERYTHING TO REFLECT THE NEW STRUCTURE. YOU NEED TO CHANGE YOUR TEMPLATE TAGS AND YOU CAN’T GO BACK TO THE OLD ADDON!!!! READ THE MANUAL (http://www.schonhose.nl/misc/pixelpost/GoogleMapManual.html) CAREFULLY BEFORE INSTALLING!!!

THIS ADDON IS FOR PP1.6 AND HIGHER AND WILL NOT WORK ON LOWER VERSIONS (SUPPORT WILL NOT BE GIVEN FOR INSTALL AT PP1.5)

What is it?
GoogleMap is a robust Google Map Pixelpost addon that puts a great amount of control in your hands. And most importantly: It doesn’t matter if your images have embedded GPS data or not.

The GoogleMap addon is a Pixelpost addon that allows the owner to give GPS locations to their images regardless if they have GPS equipment or not. The addon was created with the casual photographer in mind, who may or may not know much about GPS or even what it stands for!

The administration side allows the owner to navigate a Google Map and manually place a marker where each picture was taken. The GPS data of this marker is stored in the Pixelpost database and processed without any sticky conversions or in-depth knowledge. Once a photo has a location, it’s ready to be shown on the main map that your viewers see.

GoogleMap is based upon the jbgMap (short for Jon Bulava’s Google Map) written by Jon Bulava. Jon has done an excellent job of providing the basic structure. Since then I made several updates to his code and decided to rename the whole project to GoogleMap starting from version 2.

Changelog

Key:
[!] Important
[+] New
[-] Fixed error

Changes
Update to version 2.0:
[!] Changed the name to GoogleMap addon, not compatible with the old jbgMap addon
[-] Fixed another item in the save settings bug.
[+] Version variable for debugging purposes.
[-] Closing of certain HTML elements Options stuff moved to the Options workspace and cleaned up
[+] New tag for template file to move all javascript in the HEAD section
[+] Latest marker is always on top of the others (e.g. added order of creation)
[+] Added a possibility to use custom markers with predefined sizes
[+] Newest thumbnail can be shown on map with different marker Removed the small marker (is now supported by the custom markers)
[+] The edit map is set to the size of the viewers map
[+] Below the map a carousel is displayed, clicking on thumbnail shows info on map
[+] Export feature to downloadable KML file, show custom markers in Google Earth (accesible through index.php?x=googlemap&action=kml
[+] Wheelmouse and doubleclick zoom support in viewers and edit map
[-] Removed postionOverview function. It seems to be doing nothing.
[+] Map now shows the Google Map scale.
[+] Markers can be grouped or not based on various settings Grouped marker can be default or custom.
[+] Grouped markers can be displayed by default or custom icon.
[+] Added tag for displaying a link to the KML file. This tag can be used on the GoogleMap template.
[+] The addon can now extract GPS data from images. There are slight issues with Picassa en Earth tagging.

As you can see I made quite a bit of changes. Thats why I still have it listed as a beta addon. While it has been rock steady and stable at my site there might be some issues which I haven't noticed yet.

sounds great: I want to have it!
Sure, download it from: My addons page (http://www.schonhose.nl/pixelpost-addons/)

Please post any issue here in this thread. I'm quite busy but I'll look into them as soon as possible (provided you're gonna find issues, but I'm sure there are a few)

Please try to read THE MANUAL (http://www.schonhose.nl/misc/pixelpost/GoogleMapManual.html), questions related to stuff in there will be answered with a gentle push to the manual.

[aptass]

Greetings schonhose

Thanks for the update. I've changed from jbgmap to your version now following the manual. Also checked settings under admin and made sure maps are showing there, which they are so I assume everything is in order.
All settings seems to have been moved over from jbgmap correctly.
The new settings introduced are empty. (which seems absolutely right)

I have probably missed something and the map isn't showing up on the templatepage. I have changed <body> to
<body onload="GoogleMapLoad()" onunload="GUnload()"> and <GOOGLEMAP_HEADER> to the header section of my googlemap_template.html

http://www.aptass.com/eyesof/index.php?x=googlemap

I also get Unknown column 'icon_type_latest' in 'field list' when trying to save in the optionspage.
(I'm guessing the db is not updated with all fields)

[Dennis]

you have something strange in the javascript function causing the function not to work.

Please send me your admin_GoogleMap.php file, I believe you have an older version.

[aptass]

Hi

I'm using what was included in the zip from your page
61212 May 17 15:25 admin_GoogleMap.php



Here it is http://www.aptass.com/admin_GoogleMap.zip

[Dennis]

Ok, when I look at your source at the page I see this somewhere along line 80


var marker = new GMarker(point, {icon:iconLatestPic,zIndexProcess<img src="./smilies/icon_eek.gif" alt="" style="border: 0;" />rderOfCreation});


I searched the admin_GoogleMap.php file for that string, but it isn't there. However, it is in the output.

Have you removed the jbgmap_addon file?


I also get Unknown column 'icon_type_latest' in 'field list' when trying to save in the optionspage.
(I'm guessing the db is not updated with all fields)



// now check if we need to update
$query = "SELECT icon_type_latest FROM {$pixelpost_db_prefix}GoogleMap LIMIT 1";
if( !mysql_query( $query ) ) {
$query = 'ALTER TABLE {$pixelpost_db_prefix}GoogleMap ADD `icon_type_latest` VARCHAR( 10 ) NOT NULL DEFAULT \'default\' AFTER `icon_type` ,'
. ' ADD `icon_size` ENUM( \'l\', \'m\', \'s\' ) NOT NULL DEFAULT \'m\' AFTER `icon_type_latest` ,'
. ' ADD `icon_size_latest` ENUM( \'l\', \'m\', \'s\' ) NOT NULL DEFAULT \'m\' AFTER `icon_size` ,'
. ' ADD `icon_size_cluster` ENUM( \'l\', \'m\', \'s\' ) NOT NULL DEFAULT \'m\' AFTER `icon_size_latest` ,'
. ' ADD `icon_custom` VARCHAR( 50 ) NOT NULL DEFAULT \'none\' AFTER `icon_size_latest` ,'
. ' ADD `icon_custom_latest` VARCHAR( 50 ) NOT NULL DEFAULT \'none\' AFTER `icon_custom` ,'
. ' ADD `icon_custom_cluster` VARCHAR( 50 ) NOT NULL DEFAULT \'none\' AFTER `icon_custom_latest` ';
mysql_query( $query );


So yeah, if you're coming from the JBGMap and this version is the first install it will update an create all fields. So you've either tested an earlier version or something else is happening.

[aptass]

Hi

Thanks for looking into this. I've found the first part thanks to your pointer for me.
It seems an old addon was messing things up.

I was running Smilies converter (smilies - version 0.1.3.0) since my first install of Pixelpost and never gave it much thought. But seeing something referring to img src="./smilies/icon_eek.gif turn the lightswitch on here. I've turned off the addon and the map shows up in the googletemplate now. :D

Yes, I have removed the jbgmap_addon from the addonsdirectory.

Regarding the other issue. Yes I'm coming from jgbmap, last version I think.
Installed it 2months ago perhaps I have not tried any older versions or any betas beside this. I'll check some more here, otherwise I could always manually add the missing fields.

thanks once again

p.s

I love the support for mousewheel in googlemap. I've been missing this.

[wcleong]

I had that same icon_type_latest error. I was upgrading to googlemap v1.6Beta at the time (now we're at 2.0), so perhaps schonhose can elaborate whether the SQL code has changed with the newer version.

Anyway, I was upgrading from one of the old versions of jbgmap and found I had to manually insert some fields. It was several days ago that I did it, but I think these were the fields I was missing.

icon_type_latest VARCHAR(10) NOT NULL default 'default',
icon_type_cluster VARCHAR(10) NOT NULL default 'default',
image_zoom INT(2) NOT NULL default '15',
show_other_locations ENUM(' checked','') NOT NULL default ' checked',
clusterMarkers ENUM(' checked','') NOT NULL default '',
SetMaxVisibleMarkers INT(3) NOT NULL default '100',
SetMinMarkersPerCluster INT(2) NOT NULL default '10',
SetMaxLinesPerInfoBox INT(2) NOT NULL default '10'

Athough I added one field at a time until I stopped getting the errors.

[Dennis]

aptass, before you do this please make a dump of the GoogleMap table structure. That way I can figure out why it isn't upgrading.

[wcleong]

Don't know if this helps, but I still have my old table structure saved, here's the SQL dump of the old jbgMap table. This is from jbgMap 1.0 running on PP1.5(as listed in the comments at the top of my versions php file)

--
-- Table structure for table `pixelpost_jbgMap`
--

CREATE TABLE `pixelpost_jbgMap` (
`id` int(1) NOT NULL default '0',
`user_api_key` varchar(100) NOT NULL default '',
`admin_api_key` varchar(100) NOT NULL default '',
`api_ver` int(3) NOT NULL default '2',
`icon_type` varchar(10) NOT NULL default 'default',
`map_type` int(1) NOT NULL default '0',
`info_thumb` enum(' checked','') NOT NULL default ' checked',
`info_headline` enum(' checked','') NOT NULL default ' checked',
`info_date` enum(' checked','') NOT NULL default ' checked',
`info_time` enum(' checked','') NOT NULL default '',
`info_categories` enum(' checked','') NOT NULL default '',
`user_zoom` int(2) NOT NULL default '3',
`user_center` varchar(50) NOT NULL default '(39, -94.4)',
`user_width` int(5) NOT NULL default '800',
`user_height` int(5) NOT NULL default '532',
`admin_zoom` int(2) NOT NULL default '3',
`admin_center` varchar(50) NOT NULL default '(39, -94.4)'
) TYPE=MyISAM;

[Dennis]

Ok let me check. I've added some features along the way.

Yeah my bad, I forgot to update like 5 variables for earlier versions. New install always went ok.

DOWNLOAD IS UPDATED!!! same location, see first post.

[aptass]

Hi

This is what Googlemap table looks like after installing addon over an jbgmap-installation.
Identical with wcleongs dump with the addition of DEFAULT CHARSET=latin1;


--
-- Table structure for table `pixelpost_GoogleMap`
--

CREATE TABLE `pixelpost_GoogleMap` (
`id` int(1) NOT NULL,
`user_api_key` varchar(100) NOT NULL default '',
`admin_api_key` varchar(100) NOT NULL default '',
`api_ver` int(3) NOT NULL default '2',
`icon_type` varchar(10) NOT NULL default 'default',
`map_type` int(1) NOT NULL default '0',
`info_thumb` enum(' checked','') NOT NULL default ' checked',
`info_headline` enum(' checked','') NOT NULL default ' checked',
`info_date` enum(' checked','') NOT NULL default ' checked',
`info_time` enum(' checked','') NOT NULL default '',
`info_categories` enum(' checked','') NOT NULL default '',
`user_zoom` int(2) NOT NULL default '3',
`user_center` varchar(50) NOT NULL default '(39, -94.4)',
`user_width` int(5) NOT NULL default '800',
`user_height` int(5) NOT NULL default '532',
`admin_zoom` int(2) NOT NULL default '3',
`admin_center` varchar(50) NOT NULL default '(39, -94.4)',
`image_zoom` int(2) NOT NULL default '15',
`show_other_locations` enum(' checked','') NOT NULL default ' checked'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


and this is my old jbgmap

-- Table structure for table `pixelpost_jbgMap`
--

CREATE TABLE `pixelpost_jbgMap` (
`id` int(1) NOT NULL,
`user_api_key` varchar(100) NOT NULL default '',
`admin_api_key` varchar(100) NOT NULL default '',
`api_ver` int(3) NOT NULL default '2',
`icon_type` varchar(10) NOT NULL default 'default',
`map_type` int(1) NOT NULL default '0',
`info_thumb` enum(' checked','') NOT NULL default ' checked',
`info_headline` enum(' checked','') NOT NULL default ' checked',
`info_date` enum(' checked','') NOT NULL default ' checked',
`info_time` enum(' checked','') NOT NULL default '',
`info_categories` enum(' checked','') NOT NULL default '',
`user_zoom` int(2) NOT NULL default '3',
`user_center` varchar(50) NOT NULL default '(39, -94.4)',
`user_width` int(5) NOT NULL default '800',
`user_height` int(5) NOT NULL default '532',
`admin_zoom` int(2) NOT NULL default '3',
`admin_center` varchar(50) NOT NULL default '(39, -94.4)',
`image_zoom` int(2) NOT NULL default '15',
`show_other_locations` enum(' checked','') NOT NULL default ' checked'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


Looks identical apart from the tablename

I've updated to your new version last night but I'm afraid I'm still not successful when saving the settings in the optionspanel,
I'm getting the same errors as posted above.
Also tried to drop the googlemaptable but it doesn't get recreated for me.
I'll check some more to see if I can find out why. I assume it should recreate itself in case it's missing when installing addon etc.

cheers :)

EDIT

It does get recreated if you look in the right table ;) But still not able to save data. The structure is like the one above still with icon_type_latest missing.

I have added the fields manually now and updating settings works.

[Dennis]

hmmm... I have to investigate this further then. Thanks for reporting!

I updated it. If it still doesn't work rename the current googlemaptable so a new one is created. Then copy the settings from the old one to the new one.

[aptass]

sorry for my slow response, I've been to busy.

I have just tried the new version and it works like a charm.

All fields are created and if I delete the table, it's recreated.

Big thanks Schonhose

[jchabalk]

Hi there - i just added this google map addon to my site - i'm coming from a version of jbgmap - and get the following error..

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ADD `icon_type_cluster` VARCHAR( 10 ) NOT NULL DEFAULT 'default' , ADD `SetMaxV' at line 1

i had just downloaded what was the latest version of the google_maps addon

[Dennis]

Could you provide the MySQL server version? Something in the SQL query is breaking stuff.

@aptass: cool it is working now.

[jchabalk]

Hi there - here's the version..

mysql Ver 14.12 Distrib 5.0.16, for pc-linux-gnu (i386) using readline 5.0

This is running at at my provider..

[Dennis]

hmm, this should work, I tested it thoroughly the last time. If you feel up to it I would like to have temporary access to the admin panel of Pixelpost.

Please PM me with the details.

[jchabalk]

thanks for the offer!

The admin panel was showing the same exact error before rendering it unusable. Fortunately i take database backups so i just restored my last known good copy - just a couple of hours old - and i'm back on my way again.

i'm going to try this out again from home tonight - i'll let you know what i find out..

-john
www.ebokeh.com

[GeoS]

@Dennis: Ive got few new ideas.

1. Support of KML files instead of making biiiig JS output with each point.
2. If there will be KML then maybe KMZ?? :P
3. Option of import/export data from KML/KMZ files.

More or less thats all for now :P

PS Check your ICQ :)

[Dennis]

@Piotr: Export feature to downloadable KML file, show custom markers in Google Earth (accessible through index.php?x=googlemap&action=kml)

[GeoS]

So Ill have to take a look on the newest solution :D

[marksweb]

Any idea why the user map only shows one location and the admin map shows all the locations which I've input for my photos.

http://www.marksweb.co.uk/pixelpost/index.php?x=googlemap

[GeoS]

Strange as in the code of page there are also other locations and only the last one is showing up.

[marksweb]

aye, I don't really know enough about the gmaps so aint really got a clue how to fix it... :S

[marksweb]

Anybody got any idea why markers wont display properly on the user map?

http://www.marksweb.co.uk/pixelpost/index.php?x=googlemap

[GeoS]

Contact with Dennis aka Schonehose who is author of this addon.

[wcleong]

It's putting the markers on the map, but it also looks like you're trying to use the image thumbnail as your marker on the map, and it can't find your thumbnail images so it's not displaying anything (but if you click on the right part of the map you can still get the image balloon to popup).

ie, your thumbnails are in http://www.marksweb.co.uk/pixelpost/thumbnails
but the code is looking in http://www.marksweb.co.uk/thumbnails

Is you site URL set correctly in your admin options -> general? I think it should be:
http://www.marksweb.co.uk/pixelpost/

[xxivxxv]

I can't figure out how to get the CSS to work.

http://www.xxivxxv.com/index.php?x=googlemap

[Dennis]

@ marksweb: wcleong is right. Please see if the site url is set up properly. If it is, please report that here so I can do some bug hunting.

@ xxivxxv: look at the documentation. All is described in great detail.

[jgarde]

Hi,
I'm really excited about this add-on and has just tried installing it.

However, I fall at the first hurdle... After copying 'admin_GoogleMap.php' to the addons folder I get the following error message when accessing my photoblog:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' ADD `icon_type_cluster` VARCHAR( 10 ) NOT NULL DEFAULT 'default' , ADD `SetMaxV' at line 1

Any idea what is wrong?

Thanks,
Jesper

[Dennis]

could you provide the MySQL version? this information is in the general info section of the admin panel.

[jgarde]

Thanks for your help.

Here's the info about SQL version:
MySQL version 4.1.21-standard-log (Pixelpost's min requirement: MySQL: 3.23.58 )

Cheers,
Jesper

[Dennis]

I'm not sure why the SQL is wrong. I've just tested it and it is fine.

[jgarde]

OK, thanks for trying.

[Dennis]

You could try to remove all 'NOT NULL' clauses from statements looking like this:

ADD `icon_type_cluster` VARCHAR( 10 ) NOT NULL DEFAULT 'default'

[Pekka]

Hi, I had the same problem with Pixelpost giving me SQL syntax errors.

Tried to remove NOT NULLs but it didn't work. But, in my opinion you have an extra comma here:


// and somehow I forgot like five variables... :(
$query = "SELECT `clusterMarkers` FROM ".$pixelpost_db_prefix."GoogleMap LIMIT 1";
if( !mysql_query( $query ) ) {
$query = 'ALTER TABLE '.$pixelpost_db_prefix.'GoogleMap '
. ' ADD `clusterMarkers` ENUM(\' checked\',\'\') NOT NULL default \'\', ,'
. ' ADD `icon_type_cluster` VARCHAR( 10 ) NOT NULL DEFAULT \'default\' ,'
. ' ADD `SetMaxVisibleMarkers` INT(3) NOT NULL default \'100\' ,'
. ' ADD `SetMinMarkersPerCluster` INT(2) NOT NULL default \'10\' ,'
. ' ADD `SetMaxLinesPerInfoBox` INT(2) NOT NULL default \'10\' ';
mysql_query( $query ) or die(mysql_error()) ;


I removed it and it started working.

[Dennis]

ok great catch, it was fixed but it seems I forgot to update the download. Anyway, the file is updated.

I'm setting this as the final version soon (tonight or tomorrow)

[griet]

Hi!

I cannot manage to cluster photos... however everything is installed fine, the option is available in my admin, but adjusting it doesn't reflect any change....

I'm a starter so I have (for the moment) only 3 photos on my blog. When I put 2 of them in the same location and I put the cluster option on, it doesn't work. How exactly should I set the options?

I put the option for clustering nearby markers on;
I chose a marker;
what are the other settings exactly for? (Maximum number of visible Markers: ... )
Is the reason why it doesn't work that I haven't got enough photos yet?

Thanks a lot for helping me out!

[Dennis]

griet: google maps is different then google search.

Read the documentation provided with the package.

As for the settings. Check the options page, right after the input field it says the following about "Maximum number of visible Markers:"

Lets you change the threshold marker count where clustering kicks in. The default is 150 markers.

It should be self-explanatory....

[griet]

I am only talking about google maps, I never mentioned anything about google search!?!?

Anyway, I read all documentation and the explanations on the option page itself, but I cannot manage to cluster photos which are related to the same place on the google map....

What I did is:
- I have 3 photos, 2 of them must be clusterd...
- I put: Maximum number of visible Markers: 2 (If I understand the explanation the googlemap should now show only 2 markers instead of 3 and there should be a cluster of the 2 pictures which are related to the same place...)
- I put: Minimum number of Markers per cluster: 2 (So if I understand this, a cluster can be made from 2 photos or more...)
- Maximum number of lines in the InfoBox: 10 (this has no impact I think)

With these settings the google map doesnt make a cluster... He keeps showing 3 markers... what did I do wrong???

[Dennis]

griet: you posted in the wrong thread, I moved your post.

Secondly, the clustering routine is not suitable for only three images. But try zooming out. That might help.

[Marek]

Dennnis-

in your google map the clustered fotos will be shown with a thumbnail.
How does it works? For me custering works but only the the image title. No thumbnail will be shown.

Marek

[Dennis]

That would be because you're seeing the current development version at my site :D

[Marek]

Cool to read, that every piece of cool software could become a little cooler ;-)

[wcleong]

Hello,
I think i've come across a small bug in reading the GPS data from EXIF, it doesn't check the 'Latitude ReferenceGPS' or 'Longitude ReferenceGPS' so that coordinates that are in the western hemisphere or the southern hemisphere don't get converted properly. I've made the following change to my code:

Original:
// try to get the GPS exif data
if (array_key_exists('LatitudeGPS', $exif_info)) {
$latitudeGPS = $exif_info['LatitudeGPS'];
$longitudeGPS = $exif_info['LongitudeGPS'];
} else {
$latitudeGPS = NULL;
$longitudeGPS = NULL;
}


Updated:
// try to get the GPS exif data
if (array_key_exists('LatitudeGPS', $exif_info)) {
if (substr($exif_info['Latitude ReferenceGPS'],0,1)=='S'){
$latitudeGPS = -$exif_info['LatitudeGPS'];
} else {
$latitudeGPS = $exif_info['LatitudeGPS'];
}
if (substr($exif_info['Longitude ReferenceGPS'],0,1)=='W'){
$longitudeGPS = -$exif_info['LongitudeGPS'];
} else {
$longitudeGPS = $exif_info['LongitudeGPS'];
}
} else {
$latitudeGPS = NULL;
$longitudeGPS = NULL;
}


This works with my GPS coded files, perhaps it would make sense to make the string comparisons case insensitive as well?

[Dennis]

Thanks, I was already aware of this bug. I actually fixed it but failed to mention it here.

So it will be fixed in the upcoming 2.5 version which will be PP1.7 compatible only.

[mounte]

I just have to give you a sincere Swedish "tack" or "thank you".
Simple, easy to use, plugin that "just works"
If I modify it or come up with something cool/usefull I will post it as soon as I can.

[Ariel]

I've noticed a few issues develop over time:

1) As you add more and more images, it gets really slow to load. Currently I have over 700 images tagged w/ GPS coordinates and it takes a while for everything to load.

2) My map has stopped working altogether. I'm not sure why... I've doublechecked all the HTML and MySQL info to make sure the information is there, but the map doesn't seem to ever load.
http://www.arielbravy.com/photoblog/index.php?x=googlemap

Any ideas?

[libeco]

I'm using jbgmap and have quite some pictures in it. Now I tried updating jbgmap to google map locally to test it, but it doesn't work.

In the manual it says I have to copy the files to addons en includes dir and than check the addons page, when I do so at the bottom of the page i says: Table 'pixelpost_googlemap' already exists

It says the same when viewing my photoblog. Man I'm happy I'm first testing this locally. But how can I make google map work? When I delete the files added to those dir, everything goes back to normal.

[Dennis]

Ariel, I'm investigating this issue.

libeco: have you tried googlemap once before? and then reinstalled the jbgmap addon?

[libeco]

No, this is the first time I tried it...

[Dennis]

please make a dump of your tableview in PHPMyAdmin and the variable list in the table googlemap.

You're the first with these problems.

[libeco]

Don't exactly know what you mean, but here is the sql I exported from that table.

-- phpMyAdmin SQL Dump
-- version 2.6.0-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 24 Oct 2007 om 21:18
-- Server versie: 4.0.20
-- PHP Versie: 4.3.8
--
-- Database: `pixelpost`
--

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `pixelpost_googlemap`
--

CREATE TABLE `pixelpost_googlemap` (
`id` int(1) NOT NULL default '0',
`user_api_key` varchar(100) NOT NULL default '',
`admin_api_key` varchar(100) NOT NULL default '',
`api_ver` int(3) NOT NULL default '2',
`icon_type` varchar(10) NOT NULL default 'default',
`map_type` int(1) NOT NULL default '0',
`info_thumb` enum(' checked','') NOT NULL default ' checked',
`info_headline` enum(' checked','') NOT NULL default ' checked',
`info_date` enum(' checked','') NOT NULL default ' checked',
`info_time` enum(' checked','') NOT NULL default '',
`info_categories` enum(' checked','') NOT NULL default '',
`user_zoom` int(2) NOT NULL default '3',
`user_center` varchar(50) NOT NULL default '(39, -94.4)',
`user_width` int(5) NOT NULL default '800',
`user_height` int(5) NOT NULL default '532',
`admin_zoom` int(2) NOT NULL default '3',
`admin_center` varchar(50) NOT NULL default '(39, -94.4)',
`image_zoom` int(2) NOT NULL default '15',
`show_other_locations` enum(' checked','') NOT NULL default ' checked',
`icon_type_latest` varchar(10) NOT NULL default 'default',
`icon_size` enum('l','m','s') NOT NULL default 'm',
`icon_size_latest` enum('l','m','s') NOT NULL default 'm',
`icon_size_cluster` enum('l','m','s') NOT NULL default 'm',
`icon_custom` varchar(50) NOT NULL default 'none',
`icon_custom_latest` varchar(50) NOT NULL default 'none',
`icon_custom_cluster` varchar(50) NOT NULL default 'none',
`clusterMarkers` enum(' checked','') NOT NULL default '',
`icon_type_cluster` varchar(10) NOT NULL default 'default',
`SetMaxVisibleMarkers` int(3) NOT NULL default '100',
`SetMinMarkersPerCluster` int(2) NOT NULL default '10',
`SetMaxLinesPerInfoBox` int(2) NOT NULL default '10'
) TYPE=MyISAM;

... some more stuff and API-key

[Dennis]

right. Doest the jbgmap table still exists?

[libeco]

Yes:

- phpMyAdmin SQL Dump
-- version 2.6.0-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 25 Oct 2007 om 09:05
-- Server versie: 4.0.20
-- PHP Versie: 4.3.8
--
-- Database: `pixelpost`
--

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `pixelpost_jbgmap`
--

CREATE TABLE `pixelpost_jbgmap` (
`id` int(1) NOT NULL default '0',
`user_api_key` varchar(100) NOT NULL default '',
`admin_api_key` varchar(100) NOT NULL default '',
`api_ver` int(3) NOT NULL default '2',
`icon_type` varchar(10) NOT NULL default 'default',
`map_type` int(1) NOT NULL default '0',
`info_thumb` enum(' checked','') NOT NULL default ' checked',
`info_headline` enum(' checked','') NOT NULL default ' checked',
`info_date` enum(' checked','') NOT NULL default ' checked',
`info_time` enum(' checked','') NOT NULL default '',
`info_categories` enum(' checked','') NOT NULL default '',
`user_zoom` int(2) NOT NULL default '3',
`user_center` varchar(50) NOT NULL default '(39, -94.4)',
`user_width` int(5) NOT NULL default '800',
`user_height` int(5) NOT NULL default '532',
`admin_zoom` int(2) NOT NULL default '3',
`admin_center` varchar(50) NOT NULL default '(39, -94.4)',
`image_zoom` int(2) NOT NULL default '15',
`show_other_locations` enum(' checked','') NOT NULL default ' checked'
) TYPE=MyISAM;

--
-- Gegevens worden uitgevoerd voor tabel `pixelpost_jbgmap`
--
Some more +API-keys

[Dennis]

ok, that should not be happening.

Did you remove the jbgmap addon file from the folder? or was it still there and is it active as an addon?

If so, please remove the PHP file admin_jbgmap (or something like that) because they can't co-exists.

Googlemap renames the jbgmap table, which is then happily created again by the JBGMap addon. So Googlemap tries renaming again and fails.

You have to check which table is current and you need to drop one. Please check the settings like api-key. if they are the same I suggest you drop the jbgmap table.

Don't forget to remove the addon file for jbgmap as well!

[libeco]

OK, that worked. Now i'll see if everything is intact and woking. THNX!

[libeco]

Works perfectly now, bedankt ;)!

There's one thing though:

If you look here for instance: http://www.libeco.nl/index.php?x=googlemap&showimage=297
At the bottom of the map there's that copyright line, which is too long and simply goes on beyond the size of the map. I don' really need that small map next to it, could I autocollapse that?

[Dennis]

simple: no. :p

Which markers do you use? They should not have that white box.

[libeco]

I left them at the default google markers for now. This white background only happens in firefox, not in Maxthon (IE7), is it in the css somewhere?

Here's my CSS for the googlemap:
div#viewMap {
border: 1px solid #000;
}

div#GoogleMapInfoWindow {
width: 250px;
height: 75px;
font: 0.8em/0.8em "Century Gothic", verdana, sans-serif;
color: #003c6e;
text-align: left;
color: #333333;
}
img#GoogleMapThumb {
border: 0;
margin: 0px 5px 0px 0px;
}

span#GoogleMapHeadline {
font: 1.2em/0.8em "Century Gothic", verdana, sans-serif;
color: #003c6e;
text-align: left;
margin: 0; padding: 0; border: 0;
}

And for the div it is in:

div#wrapper div#layout_container div#main div#img {
width: 768px;
margin: 17px auto 0 auto; padding: 0; border: 0;
}
div#wrapper div#layout_container div#main div#img img {
display: block;
width: 768px;
margin: 0; padding: 0; border: 0;
}

[Dennis]

Hmm strange. Ah well...

[libeco]

It used to be this way already wth jpgmap. How far does googlemap inherit in css from its parents?

[Dennis]

that is a CSS question which depends on the page in question. Nevertheless, this is an issue with your page as all was tested and worked well.

Try selecting one of the markers from the package.

[libeco]

That displays correctly. I'll just use one of those for the time being than. Bedankt voor de hulp!

[Dennis]

Geen probleem ;)

[Mythrill]

I just started using PP and i really like it. Combined with the googlemap it's almost exactly what im looking for.

The Admin side is running as it should now but I'm running in some/a problem on the userside (googlemap_template).
My map just doesn't seem to load and since im a bit of a webdevelopment noob i have no idea what is causing the problem. Also the page turns out into a mess but thats for later concern.

What i did:
- Stripped image_template of all code that i thought would not be needed.
- Add the googlemap tags
- compare with other sites using this addon and/or template

I'm already trying to get it right now the whole afternoon/evening but the map just doesn't load.

Anyone got an idea what might cause it?

my (not working)googlemap page:
http://www.mythrill.nl/index.php?x=googlemap

Alvast bedankt

[Dennis]

Please read the manual and pay attention to step 3 of [3] Installation - user side.

[libeco]

Not a pro myself, but shouldn't

<body>

be replaced by

<body onload="GoogleMapLoad()" onunload="GUnload()">

[Mythrill]

ok, I go and stand in the shame corner now. I'm sure I added that code earlier on the day and it still didn't work, but I restarted editing the code a few times and then I probably forgot, anyway now it does work so time to get the layout right.
Thank you for pointing me at my stupidity :P

[Mythrill]

I got it all working, its really great! But I have a question with grouping markers. If you set the value of it really low, for example 5 markers. Will that give problems later if there are many markers in a small area? Is there like a recomended minimum?

[doeni188]

Hi,
really n1 work!
But I have a question:
Is it possible to display the EXIF date and time in the speechbubble of the GoogleMap instead of the date when the pic was published?

What I have to change to make it possible?

Thx for your help.
greetz Dennis (german ;) )

[Dennis]

Ok that shouldn't be so hard. Please remind me in a few days if I haven't answered yet.

[doeni188]

Hi your automatic reminder is talking...
You have to help some noobs with their problems ^^


Just kidding ;)

[Giuseppe]

Ciao Dennis+,
i've installed your google map addon in PP1.7 and all work good, but i want to redirect 301 jbgmap to googlemap can you please help me?

thanks

[Dennis]

Guiseppe, you might want to look to a .htaccess solution.

http://www.tamingthebeast.net/articles3/spiders-301-redirect.htm

Read the section on .htaccess redirect on the website above.

[Giuseppe]

Naturally i tried via .htacces before posting here but i've 500 server error when put the .htaccess file in the fotoblog directory:

Redirect 301
/fotoblog/index.php?x=jbgmap http://www.soveratonews.com/fotoblog/index.php?x=googlemap

also tried with RewriteEngine On and the code above and have always 500 server error

what goes wrong?

thanks

p.s put it also in the .htaccess at root level and the problem is the same.

[Giuseppe]

Ok i found the solution starting from scottishphotobloggers (http://scottishphotobloggers.com/general-chat/feedburner-question.html)

RewriteEngine on
RewriteCond %{QUERY_STRING} ^x=jbgmap$
RewriteRule ^index.php http://www.YOURDOMAIN.com/PPDIRECTORY/index.php?x=googlemap [R=301,L]

put this .htaccess file in /PPDIRECTORY/

ciao

[vandrende]

Hi,
I have just installed this nice addon. Everything works fine except for one thing: The link to the thumbnail image in the google map is not correct:
The addon picks up the following link for the thumbnail:
"http://htdocs/pixelpost/thumbnails/thumb_dsc_4035-edit.jpg"
while it should be:
"http://www.p-chaton.net//htdocs/pixelpost/thumbnails/thumb_dsc_4035-edit.jpg"
Any idea what could cause this problem?
Thanks

My google map page is here: http://www.p-chaton.net//htdocs/pixelpost/index.php?x=googlemap

[Dennis]

vandrende: your the first I see with this problem. Please contact your hoster about a misconfiguration.

The folder htdocs normally should not be part of the URL you have to type in to access your page.

[Kr15]

hello i've got a question,
how do i do to group markers for neaby photos,
how can i set the distance between photos taken,
because in the admin it's checked, and it doesn't work.

thanks

[Dennis]

Kr15: grouping in this version is rather peculiar, based upon the viewport and such. Grouping is also not based upon distance but on the number of markers.

I'm working on another solution as we speak.

[marc]

I just would like to say thanks for the new version and especially for the clustering feature. I think that's a very neat feature.

oh and btw i noticed that with the JBGMAP addon running I get style problems of the addon page (green background color of titles is missing) in 1.7. but after the update to googlemap addon everything works fine again. nice :)

[Dennis]

Good to hear it is working for you.

[Dennis]

Today I updated my blog with the new 3.0 version of the googlemap addon.

For more information read:
http://www.schonhose.nl/2008/02/01/pixelpost-addon-googlemap/
http://www.schonhose.nl/2008/02/03/googlemap-addon-goes-live/

[Omar1000]

Hi, great addon,

but I can't find the version3.

[Dennis]

http://www.schonhose.nl/2008/02/26/googlemaps-update/

[Hector]

Does it read the gps coordinates from the exif? or you have to put the coordinates manually for each picture?

this addon looks great. I'm using the easymap addon that reads the coordinates from exif but doesn't have a map of all pictures .. or I think so..

what lack of support do you mean? donations? or feedback?

[Dennis]

I'm not sure if the 2.0 version can read coordinates from exif. I suggest you give it a try.

[Hector]

I'm not sure if the 2.0 version can read coordinates from exif. I suggest you give it a try.

I am giving it a try.. :)
first.. no picture was shown on the map... so I went to edit one picture.. and there was no coordinates in the coordinates textbox... so.. I pressed Use EXIF tags.. and the coordinates appear.. and save.. ok. I have one picture now on the map.... so... Do I have to do the same for all the pictures? Is there a way to let it use exif coordinates from all the pictures without editing each one ?

But I went and edited some more... and I have now 5 images on the map... BUT ! some coordiantes are ok but some others are misplaced... I dont know why... I did the same .. pressing the use exif tag and save.....