Question No members displayed on Map

Status
Not open for further replies.
There's a few possible explanations:
  • Somewhere in your permissions hierarchy, the permission is overridden. Could you please double-check using the permission analysis tool in XF to make sure the permission is indeed Yes for your user?

  • The lookup hasn't finished yet. It runs in batches, and if you have a very large member base, it can take a very long time for lookup to finish. Check the xf_user_option table, the dbtech_membermap_lat and dbtech_membermap_lng columns must both be not 0.

  • If you have the "minimum posts" setting enabled, this can also block someone from being shown.

  • Bear in mind that even with "All users" ticked, it will still exclude users who do not show up as "recently active", which is anyone with activity within 180 days.
This is the query that runs on my test board, you can try running it manually and tinker with it to find out where it's excluding your users:
SQL:
SELECT `xf_user`.*, `xf_user_option_Option_1`.*
FROM `xf_user`
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0)
    AND (`xf_user`.`user_state` = 'valid')
    AND (`xf_user`.`last_activity` > 1588941989)
    AND (`xf_user_option_Option_1`.`dbtech_membermap_lat` != 0)
    AND (`xf_user_option_Option_1`.`dbtech_membermap_lng` != 0)
    AND (
            (
                FIND_IN_SET(1, `xf_user`.`secondary_group_ids`)
                OR FIND_IN_SET(2, `xf_user`.`secondary_group_ids`)
                OR FIND_IN_SET(3, `xf_user`.`secondary_group_ids`)
                OR FIND_IN_SET(6, `xf_user`.`secondary_group_ids`)
            ) OR (
                `xf_user`.`user_group_id` = 1
                OR `xf_user`.`user_group_id` = 2
                OR `xf_user`.`user_group_id` = 3
                OR `xf_user`.`user_group_id` = 6
            )
    )
 
Hello @Mouth,

We hope your ticket regarding DragonByte Member Map has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.
 
Hello @Mouth,

As we have not heard back from you, your ticket regarding DragonByte Member Map has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.
 
Status
Not open for further replies.

DragonByte Member Map

XenForo 1.5.3+ XenForo 2.0.x XenForo 2.1.x XenForo 2.2.x XenForo 2.3.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,906
Customer rating
5.00 star(s) 1 ratings
Back
Top