[Plugin: Geotag] upgrade to v2

@bobs
is there anyway (i got mysql admin) to find out quickly wich are the ones that dont have coordinates set?

@bobs

Well now I’ve got a lot of error messages.

See here: https://moltocreative.se/gatukonsten/kartan/

Whats happening?

@roddan

sorry for previous post cause i was hoping to help…
saw it better

just deactivate geotag and see if it gets normal to test

@herrpedro:
Yes, open the ‘postmeta’ table of your WordPress database. Now check for ‘_geotag_lat’ and ‘_geotag_lon’ in the ‘meta_key’ row…

@roddan:
This is great. Actually all of the messages are no errors but only notices, but I think I gut a clue. Is it possible that the map on the page appears if you switch of the automap feature?

@roddan:
btw – I saved the messages to my disk, so you can disable the debug mode again as it screws up the hole design ??

here it goes…. posts without lat
hope it helps some1

select * fromyourdb.wp_posts`
where id not in (
SELECT post_id FROM yourdb.wp_postmeta
where meta_key like ‘%_geotag%’)
and post_status in (‘publish’,’future’)`

@roddan:
I could reproduce the error and found the bug which causes the <div> container to disappear…but it will take some more time. I think I can finish that tomorrow evening.

@herrpedro:
Thanks. I will check on that tomorrow, too.

I’ve got something a little different. From a fresh install of 2.0 I have been able to get a map to show with a post marker and also a GPX track. I can’t seem to get the EXIF data from the built-in gallery photos to be plotted though.

Is the GEO EXIF data supposed to be added to the attachment meta or read on the fly? I’ve got no GEO data in the attachment meta, but its definately still in the images when they’re re-downloaded from wordpress to check. I do get other EXIF data in the meta though so I seems to have all the right PHP extensions enabled.

@roddan:
I think the bug might be fixed now. Please try to download the version 2.0 once again and replace the geotag.php file with the new one – I’m curious ??

@oppylock:
The exif is always read from the original jpg or tiff files. Maybe you can give me a link to a sample post and I will have a look…

@herrpedro:
Well, I think I might need a liitle bit help on that. So you mean that coordinates are missing execpt for posts with status ‘publish’ and ‘future’? In other words coordinates are missing for all ‘auto-draft’ posts?

@bobs1982

Houston! THe problem is fixed.

Thanks! I’ll vote for the plugin now ??

@all
it was just a SQL example for some1 to use
i dont have drafts and i dont care about “trashed” ??

coordinates were missing from almost a entire island (close to each other) but i guess you dont care about that in yout plugin or make some sort of update to other posts
so…
some posts were missing ??

@bobs – I’m sure it’ll be something silly I’m doing (it always is).

https://wp.me/p11PI4-57 is as good an example as any.
The photos on that post should show up in Rushworth, just south of the marker at the top.
I’ve tried this with just a simple post/page with only a single photo on it to simplify the issue, but the outcome is the same.