I have implemented Piwik in a couple sites and haven’t looked at it for some months (what a shame). Since my last update from Piwik 1.2.x to 1.5 nothing is logged in the database anymore.
First thing I do, is to upgrade to 1.8.2 of course (after taking a backup) but I also want to find out what happened at my last upgrade and why nothing is being stored in MySQL anymore. I have no idea yet, but will put some prints in a copy of piwik.php to debug it.
Fortunately I found the logfiles which call the piwik.php with the correct parameters. I mean the apache logfiles where piwik is running, not the logfiles from the calling sites of course. So far, I haven’t seen any tool to import those, but I can write a small program which calls those logged accesses again. Would such a tool help the community or is it just a single problem that occured to me? Another solution would be to convert to piwik access-logfile to a regular access logfile, but then I would lose some javascript information (like resolution and so on). I appreciate any hints.
I don’t know what the matter was with your first upgrade, but if it still doesn’t log after the upgrade to 1.8.X (not too obvious for me atm, thus just writing this) you will need to adjust the privileges of the MySQL user, he needs the additional ‘Lock Tables’ privilege.
Maybe something similar was the case during 1.2.x to 1.5?
Let’s see how the upgrade goes. I didn’t change anything to the MySQL configuration. Users, Privileges, etc are all the same.
It’s funny that I noticed it at all. I installed the Piwik Mobile App a while ago and thought it was outdated and couldn’t read the old statistics. I sill have to think about how to read the old logfiles. I might alter the piwik.php and add the fields that are not passed (IP, Browser, Referer) or just read the file, parse it on my own and call the API.
I really love the Piwik code. It’s so nice to read. I will also take the opportunity and replace Google Analytics for all sites I have access to.
Hi, I want to report back. The upgrade to 1.8.2 went well, still no tracking. I finally found the error. It was in the GeoIP-Plugin which changed the database structure between versions. There was a missing field in piwik_log_visit. I corrected everything and Piwik is working again.
I can’t use the import feature, since I don’t have access to the log files of the initiating site. But what I do have is the logfile from my server. Here is on example line:
If you look closely, after the HTTP_ERROR_CODE (200) there is the 1x1 image pixel site, which should be 43. It was 897, since it contained also the error messages but never threw an error.
How should I go along? Write a module for the importer or parse and call the API?
I would parse the piwik.php logs and then replay them on piwik, with the same URL but adding the parameter “cdt” to specify the time and date, and also add “cip” to specify the IP. See: http://piwik.org/docs/tracking-api/reference/
Thanks matt, the suggested import process worked fine.
I wrote a small java program which parsed my log files for the relevant entries, added the cdt and cip parameters (as well es the token) wrote everything out to a file, ran curl with --referer and --user-agent options, truncated all archive_* tables, ran archive.php and done
There was no issue with piwik, as I said it was the GeoIP Plugin where the last upgrade did not work so well.
i have installed piwik on my websites but it only seems to track 2-3 sites although i have added it on 90+ websites.
can you check the error logs?[/quote]
yes i have but there are not errors in there except for these:
except for these:
