@cuhkrain opened this Issue on April 20th 2015

Dear All,

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.,, the below screenshot shown)
piwik db

However, the ip address in attached Visitor Log is shown as -'' and ''(as the below screenshot shown). We cannot use them at all.
piwik ip

Please advise if this is setting issue or bug?

Thanks and regards,

@mattab commented on July 14th 2015 Owner

Hi @cuhkrain

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?

This Issue was closed on July 15th 2015
Powered by GitHub Issue Mirror