Incorrect City Return

[msnyc]

Hi, I just downloaded the City Complete and ran my ip

68.174.151.53

which returns NY NY correctly in your API (and others)

It does not however exist in the db and when I use the query you provided it doesn't even give NY as an optionm until I ramp the Limit up to 100.

Is there a newer version of the DB i.e. one that reflects the one used by the api?

Thanks!

[marchost]

Hi, how many rows do you have in the DB you imported locally? I've seen some people having problem when the database was imported partially (eg with phpmyadmin).

The API is using the same DB as the one offered for download

Thanks
Marc

[msnyc]

I have 3,947,743 records (loaded through an import program called Navicat which has worked pretty error free.

[marchost]

Hi, I'm getting new-york with the following query :

SELECT *
FROM `ip_group_city`
WHERE `ip_start` <= INET_ATON( '68.174.151.53' )
ORDER BY ip_start DESC
LIMIT 1

[msnyc]

I copied and pasted that code and got;

999999344 | AU | New South Wales | Sydney

[msnyc]

Also checked the db and that ip is not in it anywhere...

[TheKiller]

i just Queryd that IP and it gives

Country Code : US
Country : United States
Region Code : 36
Region Name : New York
City : New York
Zip Code : N/A
Latitude : 40.7619
Longitude : -73.9763
Metro Code : 501

see for yourself
http://wheresmyip.net/TEST/index.php?ip=68.174.151.53

How did you imported the sql file into your database?

Do as Marc said and re check your database ;)