DB function failed

Just installed plugin and entered map location page but when clicking UPDATE LOCATION on map it goes to blank page with this error.


DB function failed with error number 1054
Unknown column 'latitude' in 'field list' SQL=UPDATE jos_community_users SET latitude='52.482780222078205',longitude='-1.7578125' WHERE userid='62'
SQL = UPDATE jos_community_users SET latitude='52.482780222078205',longitude='-1.7578125' WHERE userid='62'


Also the Module Map shows an error message,

Warning: Invalid argument supplied for foreach() in /home/xxxxxxx/public_html/modules/mod_geommunity/tmpl/default.php on line 266

Please advise.

Hello
What is your Jomsocial version? Seems it's missing latitude and longitude columns.

Module shows a warning because no Jomsocial user is found.

I started with Joomla 1.5.22 when I got the error messages, then I updated Joomla to 1.5.25 and still received the same errors.
jomsocial was 1.6 but then I went back to ver 1.5.286 as a test and still the same error messages.

Jomsocial 1.8 is required to have Geommunity Locator working from scratch. (Jomsocial is currently 2.4)
If you want to use Geomunity on older version, you need to create manually using phpmyadmin 2 colums in the jos_community_users table:
- latitude
type: float
null: non
default:255
- longitude
type: float
null: non
default:255


And geommunity will work as expected.

Btw, we recommend you update to latest Jomsocial so you could eventually experience Jomsocial events and media on Geommunity map also.

All working fine now

Thank you very much for your support.

Well done!
Hope you'll enjoy Geommunity!