Problem with geography - cities-regions

heurteph-ei · February 1, 2023, 10:40am

Is it the same problem as:

github.com/matomo-org/matomo

Geolocation: German State/ Province huge "Unknown" entries because of wrong languages (db-ip.com)

opened 03:18PM - 09 Jun 22 UTC

closed 12:50PM - 28 Mar 23 UTC

utrautmann

Bug duplicate

The Region widget for State/Province shows a lot of unknown entries, although ci…ty entries could be localized. The free database is used: https://download.db-ip.com/free/dbip-city-lite-2022-06.mmdb.gz The screenshots show the big difference between localized visitors for Regions and for Cities. ![grafik](https://user-images.githubusercontent.com/25771066/172879865-41f855f5-3228-4554-97ff-3a23fba8ebb1.png) ![grafik](https://user-images.githubusercontent.com/25771066/172879878-aea52e9c-3c6a-4dd9-b827-8923349786a0.png) ## Current Behavior I have checked this database resp. the CSV file from db-ip.com with the entries for State/Province. The State/Province entry is sometimes for German regions in German language (Baden-Württemberg) or sometimes in English language (Lower Saxony, Hesse, Bavaria). It seems to be that whenever the German provinces are in English language in the db-ip.com-Database, there will be an Region entry "Unknown" for the visitor in Matomo . That might be a content related error at dp-ip.com, but my question is: how does Matomo work here? What does Matomo need and are there any workarounds? Needs Matomo the provinces in the language of the city? * Matomo Version: 4.10.1

Or else

Also viewed in topic