1sweetman Posted June 24, 2014 Share Posted June 24, 2014 Hi, After a barrage of brute force attacks I have decided to use the geolocation option under Preferences to block certain countries however when I go to Preferences > Geolocation and want to review the countries I wish to accept/decline each country appears multiple times. Algeria - 3 times Angola - 4 times United Kingdom - twice etc Something has obviously gone wrong somewhere - what is best solution to fix? Reset the table in db? Which table? Drop the table and import a fresh table from a test shop? Delete the .dat file? Using version 1.6.0.5 Many thanks in advance Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted June 24, 2014 Share Posted June 24, 2014 I can't answer exactly the issue with multiple countries other than to check back office-->localization-->countries for duplicates. What I want to warn you about, is that under current geo locaction, unresolved IP addresses will not be 'allowed' to shop. The accurcy of free GeoLiteCity is around 85%, this can result disallowing valid visitors from seeing our shopping on your site, depending on how you configure the behavior in geo location. My Geo Targeting Module allows you to override the default behavior of 'unresolved' IP addresses by using a selected default country as well as supporting 'black list', in that you can tell the module to block IP's. Link to comment Share on other sites More sharing options...
1sweetman Posted June 24, 2014 Author Share Posted June 24, 2014 Hi, thanks for that info I will look into it but first I'd like to resolve the issue that I seem to have with countries...... You are correct there is an issue in Localization > Countries - they are all duplicated plus there is some rather erroneous information e.g Zimbabwe (appears 3 times) ISO code ZW, Zone = Florida...... How would you/someone/anyone recommend clearing this up? Resetting a table somewhere? Or do I just have to work through Localization > Countries one at a time deleting the incorrect ones? Many thanks in advance. P.S. While asking if I block most countries does the mobile side still work or do I have to whitelist the providers IP's Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted June 24, 2014 Share Posted June 24, 2014 I would side with safe and disable the duplicates. Make sure to check that the ISO code is correct for duplicate that you leave enabled. Then check that at registration those countries are still showing. Link to comment Share on other sites More sharing options...
Recommended Posts