Verify SQL Entry of LAT/LON for users

Hansi
Topic Author
Offline
New Member

3 years 6 months ago #44904 by Hansi

Verify SQL Entry of LAT/LON for users was created by Hansi

Hello Nordmograph,
I could not see any markers on my map. Therefore I wanted to check, where the coordinates (LAT/LON) are entered at the MySQL Database.

Sadly I could not find respective fields at EasySocial and wondered if you could provide a hint for me so I can check?

Thank you,

Please Log in or Create an account to join the conversation.

nordmograph
Offline
Moderator

3 years 6 months ago #44905 by nordmograph

Replied by nordmograph on topic Verify SQL Entry of LAT/LON for users

Hello,

It's in #__social_fields_data some datakey hold latitude and longitude values.
Hope it helps.
Let me know.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

Hansi
Topic Author
Offline
New Member

3 years 6 months ago #44906 by Hansi

Replied by Hansi on topic Verify SQL Entry of LAT/LON for users

Hello,
Thank you. I've found it.

It seems like there are multiple "Address" fields per user but non of them was filled in. Most of them are empty (see attached).

Do you know why?
Regards,

Attachments:

Please Log in or Create an account to join the conversation.

nordmograph
Offline
Moderator

3 years 6 months ago #44908 by nordmograph

Replied by nordmograph on topic Verify SQL Entry of LAT/LON for users

Not sure, this is an issue with EasySocial settings.
Thes latitude and longitde fields need to be populated correctly to be read by Geommunity.

Please Log in or Create an account to join the conversation.

Hansi
Topic Author
Offline
New Member

3 years 6 months ago #44911 by Hansi

Replied by Hansi on topic Verify SQL Entry of LAT/LON for users

Wow, what a successful mornin'.. I've got the registration map to work.

The only missing part was, to add the Geocoding API from the API Library at the Google API console.

After that, all LAT/LON data has been entered correctly.

Thanks again.

Please Log in or Create an account to join the conversation.

Time to create page: 0.324 seconds

Featured Apps

Shop Account

Misc.

Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.

Verify SQL Entry of LAT/LON for users

Featured Apps

Shop Account

Misc.

Follow Us