I find the ip address in the Visitor log is quite strange for our users(the system is for internal use).
When i run the sql-SELECT inet_ntoa(conv(hex(location_ip), 16, 10)) as ip, conv(hex(idvisitor), 16, 10) as visitorId FROM piwik_log_visit;
The correct IP address shown in DB, e.g. 126.96.36.199, 188.8.131.52, 184.108.40.206...(as the below screenshot shown)
However, the ip address in attached Visitor Log is shown as -'220.127.116.11' and '18.104.22.168'(as the below screenshot shown). We cannot use them at all.
Please advise if this is setting issue or bug?
Thanks and regards, Rain
Maybe you are looking at different visitors and the IP address is actually correct in the Visitor log? can you show more of your DB columns so we can be sure you are showing the same visitors?