[3.2][3.3][RC] Usermap for phpBB

[Mike-on-Tour]

Hm, that is weird, the line numbers don't match with my original file 'main_listener.php'.
What did you do before this error occurred? And did it happen only once?
All other functions do work properly?

[Mike-on-Tour]

I have just tried this request in my browser, it seems that you haven't enabled your account for the free web service, please refer to the explanation for the Geonames user in the ACP.

[Jorup16]

Hm, that is weird, the line numbers don't match with my original file 'main_listener.php'.
What did you do before this error occurred? And did it happen only once?
All other functions do work properly?

Well I didn't actually do anything, I just activated the extension and registered on the page as the instructions indicate.

I have just tried this request in my browser, it seems that you haven't enabled your account for the free web service, please refer to the explanation for the Geonames user in the ACP.

Apparently if I'm registered, my username appears in the corner. In addition, a user validation email arrived.



EDIT:
It was a problem in user activation. It is assumed that I had already activated my user through the email I received, but it was not.

So I had to click on this link for the free service to be activated.

https://www.geonames.org/enablefreewebservice

[Jorup16]

Is there a problem with Ecuador's postal codes? I have some Ecuadorian users and they cannot see the map.

I thought it was a problem with my site, so I changed my zip code in your test forum but it didn't work.


Zip Code 010107 - Ecuador

[Dr.Death]

Take a look here:

https://www.geonames.org/postal-codes/

If the country is not listed, it will not work.


Maybe the Extension Author should remove the not listet countries.

[Mike-on-Tour]

Either removing them from the list or mark them as unservicable sounds like a good idea. I will look into this.
I have to admit that I haven't thought about this possibility.

[Jorup16]

Take a look here:

https://www.geonames.org/postal-codes/

If the country is not listed, it will not work.


Maybe the Extension Author should remove the not listet countries.

Indeed, Ecuador does not appear in that list.

[3Di]

An User Map can only work with Geo Location (GPS coordinates) IMHO.

Postal codes are not the way to go,
I do not know if there is a service which provides all of the world-wide postal codes but I do not think so, at least for free.

[Jorup16]

Spanish Translation:

https://www.solidfiles.com/v/LwnpD3KAXLDkA

[Mike-on-Tour]

Spanish Translation:

https://www.solidfiles.com/v/LwnpD3KAXLDkA

Thanks a lot, Jorge (Thumb up!)

[Mike-on-Tour]

An User Map can only work with Geo Location (GPS coordinates) IMHO.

Postal codes are not the way to go,
I do not know if there is a service which provides all of the world-wide postal codes but I do not think so, at least for free.

Geonames.org provides the coordinates for the country code / postal code combination, sadly not for every country in the world.
The basic idea is that everybody knows the country and the postal code of the location he lives in; coordinates are something different and judging by some of the questions you get here in this forum I have my doubts that everybody can give proper coordinates for the place he lives.

I'm looking for a solution.

[3Di]

There are the GPS coordinates for each city/village etc AFAIK, a generic one.

Example
https://www.latlong.net/place/berlin-germany-9966.html -
https://www.google.com/maps/place/52%C2 ... d13.404954

So ideally the logic should be:

1 - user input just the City/Country
2 - code searchs the GPS coordinates
3 - code places the location on the Map

here we need a library. Don't know if exists.

[3Di]

Maybe it is worth to explore https://developers.google.com/maps/docu ... ding/start

Geocoding is the process of converting addresses (like a street address) into geographic coordinates (like latitude and longitude), which you can use to place markers on a map, or position the map.

[thecaretaker1]

Thought I'd give the Usermap extension a try. All registered and activated with Geonames.

When I try to add my post code and country in the user control panel (Profile) I am getting the following error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'pf.pf_phpbb_location' in 'field list' [1054]

SQL

SELECT u.user_id, u.username, u.user_colour, pf.pf_phpbb_location, pf.pf_mot_zip, pf.pf_mot_land FROM phpbb_profile_fields_data AS pf INNER JOIN phpbb_users AS u ON pf.user_id = u.user_id WHERE u.user_id = 2

BACKTRACE

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

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/mot/usermap/event/main_listener.php
LINE: 391
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/mot/usermap/event/main_listener.php
LINE: 259
CALL: mot\usermap\event\main_listener->process_user_profile_data()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 214
CALL: mot\usermap\event\main_listener->ucp_profile_info_modify_sql_ary()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 44
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/includes/ucp/ucp_profile.php
LINE: 399
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: ucp_profile->main()

FILE: [ROOT]/ucp.php
LINE: 407
CALL: p_master->load_active()

I already have 2 custom profiles on my forum. Could this be the issue?

[Mike-on-Tour]

The extension is missing the predefined profile field 'location' which is by default part of phpbb. Did you by any chance remove it from your profile fields list?
The profile should look something like this (of course there can be more fields):