Change: The copyright URL has been changed to match DBTech's new XF2 URLs
Fix: Bugfix roll-up since previous version
Update highlights
This release fixes an issue with the web service GeoIP API utilised in parts of this mod. The previous API shut down, so a replacement was put in place.
Complete Change Log
Fix: Updated the endpoint for the GeoIP "Web service" API
What is happening?
On the 11th of July 2018, XenForo published their Resource Guidelines aimed at ensuring performance & stability of XenForo modifications. At the moment, this product does not meet these standards, due to the fact that this product has been engineered to allow the core code to run on both XenForo 1 and XenForo 2.
As a result, I am beginning work on re-engineering this product to become a "native"...
Update highlights
This release marks the first version of the re-engineered XenForo 2 version, fully in line with the XenForo 2 Resource Guidelines.
The XF2 version has also received back-end updates to improve the stability & reliability of the GeoIP lookups. You will need to wait for the cron job to run through all users again, though, or run it manually.
The XF1 version has not been updated.
Complete Change Log
Feature: Users can change their...
LogicException: Unknown relation Option accessed on xf_session_activity in src/XF/Mvc/Entity/Finder.php at line 651
- XF\Mvc\Entity\Finder->join() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->resolveFieldToTableAndColumn() in src/XF/Mvc/Entity/Finder.php at line 539
- XF\Mvc\Entity\Finder->columnSqlName() in src/XF/Mvc/Entity/Finder.php at line 222
- XF\Mvc\Entity\Finder->buildCondition() in src/XF/Mvc/Entity/Finder.php at line 120
- XF\Mvc\Entity\Finder->where() in src/addons/DBTech/MemberMap/Pub/Controller/Map.php at line 147
- DBTech\MemberMap\Pub\Controller\Map->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'dbtech_membermap_manual' in 'field list' in src/XF/Db/AbstractStatement.php at line 212
- XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
- XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
- XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 244
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1394
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1121
- XF\Mvc\Entity\Entity->save() in src/addons/DBTech/MemberMap/Pub/Controller/Map.php at line 217
- DBTech\MemberMap\Pub\Controller\Map->actionLocation() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
Hello,
Thanks for this addon!
Facing two issues/bug with it after setting up on latest XF2 :
When unticking "Show all" to display all registered user position i get this error on front page :
(nb : no error when ticking the option to only display connected members)
When trying to drag the marker to update position, i get this error :
Thank you for your time and support.
Regards
You mean all connected members only ?you can tick the box to show all members on the map
SELECT `xf_user`.*, `xf_sv_rating_cache_User_RatingData_1`.*, `xf_user_option_Option_2`.*
FROM `xf_user`
LEFT JOIN `xf_sv_rating_cache_User` AS `xf_sv_rating_cache_User_RatingData_1` ON (`xf_sv_rating_cache_User_RatingData_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND (`xf_user`.`last_activity` > 1515928861) AND (`xf_user_option_Option_2`.`dbtech_membermap_lastupdate` <= 1531394461) AND (`xf_user_option_Option_2`.`dbtech_membermap_manual` = 0) AND ((FIND_IN_SET(3, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(4, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(2, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(5, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(1, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(0, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(9, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(8, `xf_user`.`secondary_group_ids`)) OR (`xf_user`.`user_group_id` = 3 OR `xf_user`.`user_group_id` = 4 OR `xf_user`.`user_group_id` = 2 OR `xf_user`.`user_group_id` = 5 OR `xf_user`.`user_group_id` = 1 OR `xf_user`.`user_group_id` = 0 OR `xf_user`.`user_group_id` = 9 OR `xf_user`.`user_group_id` = 8))
LIMIT 100
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Mvc/Entity/Finder.php(1163): XF\Db\AbstractAdapter->query('\r\n\t\t\tSELECT `xf...')
#5 src/addons/DBTech/MemberMap/Repository/GeoIp.php(67): XF\Mvc\Entity\Finder->fetch()
#6 src/addons/DBTech/MemberMap/Cron/GeoLocate.php(21): DBTech\MemberMap\Repository\GeoIp->scanUsers()
#7 [internal function]: DBTech\MemberMap\Cron\GeoLocate::scanIps(Object(XF\Entity\CronEntry))
#8 src/XF/Job/Cron.php(35): call_user_func(Array, Object(XF\Entity\CronEntry))
#9 src/XF/Job/Manager.php(241): XF\Job\Cron->run(7.9999978542328)
#10 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 7.9999978542328)
#11 src/XF/Job/Manager.php(76): XF\Job\Manager->runJobEntry(Array, 7.9999978542328)
#12 job.php(15): XF\Job\Manager->runQueue(false, 8)
#13 {main}
As per the release notes, you have to wait for either the cron job to run a few times, or run it manually. It only processes 100 members per run by default, and it runs every 10 minutes.You mean all connected members only ?
I have ticked the option but it only show MY postion. Other members do not appear despite correct permission set for Members
24h later, i am still the only member displayed on the map despite the presence of connected users.As per the release notes, you have to wait for either the cron job to run a few times, or run it manually. It only processes 100 members per run by default, and it runs every 10 minutes.
Stack trace
SELECT `xf_user`.*, `xf_sv_rating_cache_User_RatingData_1`.*, `xf_user_option_Option_2`.*
FROM `xf_user`
LEFT JOIN `xf_sv_rating_cache_User` AS `xf_sv_rating_cache_User_RatingData_1` ON (`xf_sv_rating_cache_User_RatingData_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND (`xf_user`.`last_activity` > 1516005776) AND (`xf_user_option_Option_2`.`dbtech_membermap_lastupdate` <= 1531471376) AND (`xf_user_option_Option_2`.`dbtech_membermap_manual` = 0) AND ((FIND_IN_SET(3, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(4, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(2, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(5, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(1, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(0, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(9, `xf_user`.`secondary_group_ids`) OR FIND_IN_SET(8, `xf_user`.`secondary_group_ids`)) OR (`xf_user`.`user_group_id` = 3 OR `xf_user`.`user_group_id` = 4 OR `xf_user`.`user_group_id` = 2 OR `xf_user`.`user_group_id` = 5 OR `xf_user`.`user_group_id` = 1 OR `xf_user`.`user_group_id` = 0 OR `xf_user`.`user_group_id` = 9 OR `xf_user`.`user_group_id` = 8))
LIMIT 100
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Mvc/Entity/Finder.php(1163): XF\Db\AbstractAdapter->query('\r\n\t\t\tSELECT `xf...')
#5 src/addons/DBTech/MemberMap/Repository/GeoIp.php(67): XF\Mvc\Entity\Finder->fetch()
#6 src/addons/DBTech/MemberMap/Cron/GeoLocate.php(21): DBTech\MemberMap\Repository\GeoIp->scanUsers()
#7 [internal function]: DBTech\MemberMap\Cron\GeoLocate::scanIps(Object(XF\Entity\CronEntry))
#8 src/XF/Job/Cron.php(35): call_user_func(Array, Object(XF\Entity\CronEntry))
#9 src/XF/Job/Manager.php(241): XF\Job\Cron->run(7.9999980926514)
#10 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 7.9999980926514)
#11 src/XF/Job/Manager.php(76): XF\Job\Manager->runJobEntry(Array, 7.9999980926514)
#12 job.php(15): XF\Job\Manager->runQueue(false, 8)
#13 {main}
You only posted a stack trace, not an error message.
- XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xf_user_option_Option_2.dbtech_membermap_lastupdate' in 'where clause'
- src/XF/Db/AbstractStatement.php:212
php cmd.php xf-addon:upgrade-step DBTech/MemberMap 2010070 2
I will try this. thanks.For some reason, that step didn't run for you when you upgraded the mod.
Ohhh, yeah I see the issue. Running that code will fix it, I'll release Beta 2 with the fixed installer as wellI will try this. thanks.
note that this is not an Upgrade but a first Install.
Update highlights
This release fixes a couple issues with the initial Beta version.
Complete Change Log
Fix: Only showing online users on the map should now work as intended
Fix: The installer was missing two new columns introduced in Beta 1
You can run the cron manually via the relevant AdminCP page.Thanks for the update.
Issue is fixed : all users are displayed.. and counting.. waiting for the cron
Is that normal that Connected users are not displayed (still alone) : do i have to wait the end of the cron run ?
We use essential cookies to make this site work, and optional cookies to enhance your experience.