• Resolved tommp81

    (@tommp81)


    Hello, I help administer a woocommerce site that’s based in Europe. We use a few plugins to offer fixed prices in a few countries, and default to Euro elsewhere.

    The issue we’re running into that sometimes (just sometimes) prices are shown in Euros to customers in Norway. We do have prices in Norwegian kroners set for all our products.

    The fact that it’s intermitted and hard to reproduce on demand makes it hard to debug… We do have four plugins that each use the MaxMind GeoDB — I suspect that there is a conflict between them, namespace collision that causes one plugin to use another’s libraries. Those plugins are:

    ./plugins/wc-aelia-foundation-classes/src/vendor/maxmind-db/reader/src/MaxMind/Db/Reader.php
    ./plugins/woocommerce/vendor/maxmind-db/reader/src/MaxMind/Db/Reader.php
    ./plugins/wordfence/vendor/maxmind-db/reader/src/MaxMind/Db/Reader.php
    ./plugins/geoip-detect/vendor/maxmind-db/reader/src/MaxMind/Db/Reader.php
    
    I read the various posts on conflicts between WordFence and GeoIP Detect... but the "ip test" section in the GeoIP-Detect plugin shows no errors and returns the correct answer.
    
    I could reproduce the problem this morning by getting into our site over VPN from Norway, and saw the prices in Euros.  I wrote a simple PHP code to lookup that IP address in the various databases I have, and they all say "Norway".  I'm not really sure how to further debug this... but it's a big issue for us.
    
    using database: .../wp-content/wflogs/GeoLite2-Country.mmdb
    ip 45.12.223.38 has isoCode --> NO
    ip 46.246.122.70 has isoCode --> NO
    
    using database: .../wp-content/plugins/wordfence/lib/GeoLite2-Country.mmdb
    ip 45.12.223.38 has isoCode --> NO
    ip 46.246.122.70 has isoCode --> NO
    
    using database: .../wp-content/uploads/woocommerce_uploads/WVg2eo3ulmQ9aO6NNSbhYP0OZVYC9RkS-GeoLite2-Country.mmdb
    ip 45.12.223.38 has isoCode --> NO
    ip 46.246.122.70 has isoCode --> NO
    
    using database: .../wp-content/uploads/woocommerce_uploads/Lf7jwRMZWZlypHFIjtR3QIn5ajp8p9fU-GeoLite2-Country.mmdb
    ip 45.12.223.38 has isoCode --> NO
    ip 46.246.122.70 has isoCode --> NO
    
    using database: .../wp-content/uploads/GeoLite2-City.mmdb
    ip 45.12.223.38 has isoCode --> NO
    ip 46.246.122.70 has isoCode --> NO

    Any suggestions on how to debug this further? Thank you,

    tom.

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘How to debug MaxMind db issues?’ is closed to new replies.