Using Piwik 2.16.1 with PHP 7.0 (PHP 7.0.8-2+deb.sury.org~xenial+1 (cli)) on Ubuntu 16
I have the geoip pecl module installed and set for FPM and CLI.
The pecl module is working fine in piwik
When I try to update the database with geoip lookups for older visits it doesn’t seem to work. We are only seeing the country displayed for those older visits.
php ./console usercountry:attribute 2016-06-01,2016-06-28
100% processed. Time elapsed: 0.041s
Completed. Time elapsed: 0.041s
Is there a way we can get the results of the city lookups as well?
Hi there,
is the city lookup working for normal new visits? if it is working, then it should also set the city+region when using ./console usercountry:attribute
root@iZ2370mbj5hZ:/data/web# sudo php ./console usercountry:attribute 2015-01-01,2016-12-01
Re-attribution for date range: 2015-01-01 to 2016-12-01. 1567404 visits to process with provider “default”.
5% processed. Time elapsed: 1.417s
10% processed. Time elapsed: 2.873s
15% processed. Time elapsed: 4.317s
20% processed. Time elapsed: 5.732s
25% processed. Time elapsed: 7.183s
30% processed. Time elapsed: 8.718s
35% processed. Time elapsed: 10.298s
40% processed. Time elapsed: 11.987s
45% processed. Time elapsed: 13.744s
50% processed. Time elapsed: 15.520s
55% processed. Time elapsed: 17.259s
60% processed. Time elapsed: 18.932s
65% processed. Time elapsed: 20.580s
70% processed. Time elapsed: 22.241s
75% processed. Time elapsed: 23.857s
80% processed. Time elapsed: 25.464s
85% processed. Time elapsed: 27.141s
90% processed. Time elapsed: 28.806s
95% processed. Time elapsed: 30.442s
100% processed. Time elapsed: 32.070s
Completed. Time elapsed: 32.616s
I did this, but location_city is still empty in database for the old visitors. Why??