Piwik was working for me but I had to move to a new VPS (digitalocean). Presently running on Ubuntu 16.04, nginx and php7.0 fpm. piwik is 3.0.3. When I moved providers, I did a mysqldump and replayed that into my new mysql instance and upgraded piwik. I believe piwik was able to do a schema update but it’s been a few months and I don’t remember the details.
I’ve confirmed the correct tracking code is in my wordpress installation. I’ve enabled both the js and img tracking.
In my logs, I see lots of tracking hits from the various visitors to my side. They are all getting a 200 and there are no PHP errors or Mysql errors. But I don’t see any entries in piwik_log_visit after the date of my VPS move when I use this query:
select * from piwik_log_visit order by visit_last_action_time desc limit 5;
I turned on query logging in mysqld and did a manual GET of the img tracking link and piwik does not even perform a mysql query. It does perform mysql queries when I go to the piwik dashboard so I know that the mysql configuration information is correct.
So I’m at a loss for how to proceed. If the query is getting a 200 from nginx but not getting to mysql, the problem would seem to be inside of piwik somewhere.