Rephrasing my post. I have upgraded our test server OJS to 3.2.1.1 and the usage statistics is not working correctly. I have looked at the db table metrics and it is not collecting all of the info that we needed. The country_id column is all NULL.
I have downloaded GeoLiteCity.dat from GeoIP Legacy Databases and moved it to plugins/generic/usageStats/ . I am not sure which geoip database PKP OJS recommends. But, I have downloaded and I tested about 5 of them and no success. Can someone point to me the correct database to use? Do we buy the commercial version?
I have also moved the log files from …/usageStats/archive into …/usagestats/stage and ran:
php tools/runScheduledTasks.php lib/pkp/plugins/generic/usageStats/scheduledTasks.xml
The “Generate custom report” do not generate reports with “Country” when I choose County and select range by “month”.
Is there any way to fix this?
Obi