[RC] phpBB Geo Topics 1.4.3 - AJAX maps OSM GOOGLE BING

[Lucan]

When i try to delete a position, I often get this error:

Code: Select all

SQL ERROR [ mysqli ]

BIGINT UNSIGNED value is out of range in '(`d01a7f1d`.`phpbb_ymsm_tags`.`tag_count` - 1)' [1690]

SQL

UPDATE phpbb_ymsm_tags SET tag_count = tag_count - 1 WHERE tag_id IN (SELECT tag_id FROM phpbb_ymsm_tag_obj WHERE obj_id = 13)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 189
CALL: dbal->sql_error()

FILE: [ROOT]/includes/ymsm/tagging.php
LINE: 83
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/geotopics.php
LINE: 306
CALL: phpbb_ymsm_tagging::delete_obj_tags()

How to fix it?
Thanks!

[entonox]

Nice mod,

i made a Dutch translation for this. I'll send it to the author to make it available for everyone.

[ostridm]

entonox

Thank you again!

Download link http://geo.krasnogorie.net/geo/viewtopic.php?p=195#p195

[entonox]

Youre welcome!

Another quick fix i did:

If the Google Maps tools look distorted, please add

Code: Select all

.gm-style img { max-width: none; }

to the /styles/prosilver/template/ymsm/header_inset.html file. This will solve it.

[ostridm]

ok

[entonox]

Quick question; on our forum all users require to fill in there location when registering on the forum. Is it possible to display the location of all the forum users on the map? So the user doesn`t need to manually fill in their location again.

[ostridm]

Hi

Have you enabled GeoIPCity database integration? If you do mod will try to resolve location from IP database uploaded to server or an admin will be able to process previously registered users to resolve their Location from registration IP and in case of failure for registration IP also from recent post IP. The ACP resolve will not override user location if it was specified manually by the user.

You can adjust number of simultaneously displayed markers via ACP at Functions section. I should warn you that software uses client based clustering method so the huge number of markers will cause browser to stop working.

[ostridm]

Duplicate

[entonox]

This geo ip city mod is continuesly updating the location or do you have to update it manually every time?

[ostridm]

- GeoIPCity option tries to resolve IP to location once at registration
- Admin is able to re-process the board users locations any time

Mod understands if the user location was set manually by the user from UCP. These 'manually specified' location will not be overwritten by board user location re-processing task.


update:
both these options depend on GeoIPCity integration - by default it switched OFF because it requires database (about 30M) which is not provided with mod package

[entonox]

Thanks, i integrated the mod! Works fine. How do i enable both functions? i downloaded and uploaded the database

[ostridm]

You need to upload ipdatabase integration files (*.php | *.inc) from contrib directory of the package.
To understand location of the target directory for these files please look trough mod install instructions

(sorry do not remember the place exactly )

Than enable it at ACP

[entonox]

I integrated the GeoIPcity with success, most of the users are placed on the map now!

But one strange thing i noticed is that when i click on 'show user on user map' in theire profile page I get the user map but the position point is always in the top left corner. The balloon is showed with the avatar and information, but is always placed in the top left. i only use google maps. EDIT: this only happens when the point is not visible but hidden below the cluster point. With the visible point it is function good.

Any ideas what the problem can be?

[ostridm]

I'am afraid for now it cannot be fixed for google map. Try bing or any other

append url with

&pr=1
&pr=3
&pr=4

and see the result

[Tobias Claren]

It seems this Mod is unique.
Is this right, or is there another comparable Mod or extension from another author?

Will there be a new version of this Mod as an extension?
On either side of this thread, the word "Extension" is not used...

It would be a pity if it ends herewith.
Especially tragic when it remains the only mod of this type.


Is there a website that uses this mod?
Where I can practically see, this mod in action.




Do I understand correctly the mod?:
Every visitor of a site can freely place a pin at a world map, and write a comment for this place?

Other users can do the same, or write a comment under this Topic?

All phpBB Mods and or Extensions for board topics can used simultaneously?