matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.63k stars 2.62k forks source link

Incorrect usage data for Malaysian states on Visitors Map widget + clicking on Malaysia shows different states #19411

Closed avimaymon closed 1 year ago

avimaymon commented 2 years ago

Expected Behavior

  1. The states of Pulau Pinang and Perlis under Malaysia should show correct usage data
  2. Clicking on Malaysia should show the state of Malaysia

Current Behavior

  1. No usage data for these two states while on the Cities view but on Regions view we can see that there is usage from cities of these two states
  2. Clicking on Malaysia shows other states e.g. China and Russia, to see Malaysia the user needs to click on Australia

Steps to Reproduce (for Bugs)

The bugs are clearly depicted here https://www.screencast.com/t/LKiBvqIe2D

Your Environment

peterhashair commented 2 years ago

@avimaymon Thank you for reporting this, our team is looking for a map and IP updates, once that's updated should fix it.

avimaymon commented 2 years ago

@peterhashair Thanks for your reply, I have to ask if there is a rough estimate to when it will be fixed so I can inform my clients that are having a hard time with this issue? perhaps some workaround? thanks

sgiehl commented 2 years ago

@avimaymon I've created https://github.com/matomo-org/matomo/pull/19415, which should address the second issue. So clicking on Malaysia will no longer show the asia map, but the oceania one. Which is also displayed when clicking on australia. This fix should be included in Matomo 4.12.

Regarding the incorrect region data: Which geo location database are you using? Are those regions listed in the region report at all, or are they only not shown on the map?

avimaymon commented 2 years ago

@peterhashair Your help is much appreciated, thanks Regarding the geo location database - we're using DBIP/GeoIP (Php) which was last update less than a week ago

sgiehl commented 2 years ago

@avimaymon Is it the free or the paid DBIP database? The free database make some problems with detecting the regions correctly. See #19329 for more details.

avimaymon commented 1 year ago

@sgiehl The second issue was fixed after updating to 4.12 but the first one remains, we do use the free DBIP database, but I'm not sure it's a DBIP issue because we do get that data on the Cities view

This is how it looks on the Cities view 1 1

and this is how it looks on the Regions view 1 1

There are different names for the first area in the two different view modes but there are adjacent so I'm not sure it's an issue 1

Could it be that really small counts do not appear in the regions view?

would love your help, thanks!

sgiehl commented 1 year ago

I would assume it's a similar issue like https://github.com/matomo-org/matomo/issues/19329 Or the iso region code of malaysia might have changed, and we can't map them correctly. Should be something to have a look at when implementing #11929

avimaymon commented 1 year ago

@sgiehl Thanks for the quick reply, if possible, I would love getting an update regarding this issue because it really bothers some clients, thanks!

sgiehl commented 1 year ago

closing in favor of https://github.com/matomo-org/matomo/issues/20527