Page 1 of 1

When cities turn up unknown but they are in the DB

PostPosted: Fri Oct 21, 2005 2:05 am
by impactorange
I am playing around with a copy of the db on my own server. I noticed that both on my server and on hostip.info, an IP address associated with Hamilton, ON turns up "unknown" even though it is in the cities list. I imagine this would happen with other cities too.

URL:
http://www.hostip.info/api/get.html?ip= ... ition=true

This returns an unknown city.

Upon further investigation, somehow $info["city"] (in /lib/iplookup.php) becomes 0 instead of the actual city number. When I print the $sql string out, it's totally fine. If I take this exact string into sql, it returns results.

Any idea why the city would become 0 instead of using the value from mysql?

Thanks for your help!

PostPosted: Mon Oct 24, 2005 11:57 pm
by Teo
Hostip geo data is a building project.

Here you can see than 45% of datas are wrong or missing

Image

bug

PostPosted: Mon Nov 07, 2005 1:38 pm
by Zyron
I have a local working copy, updated october.

It detects this ip:
84.174.222.89 as Giessen, GERMANY

but report unknown at hostip.info :roll:

PostPosted: Fri Nov 11, 2005 11:27 pm
by Guest
Avoid to ask quality in a communoty project where everybody take without to give.

use all datas but no update, no correction is the BIG word.