Hi, I’ve been handed an existing Piwik installation that has been running happily for years with no intervention.
I’m completely new to Piwik, and have only started educating myself on webserver maintenance.
From what I can tell, Piwik stopped gathering stats on March 6, 2018. MySQL is running, various MySQL files seem to be getting modified as shown by file modified dates at the OS level.
Reports for date ranges after March show “no data to report”. Earlier date ranges give reasonable results.
I don’t know of any significant changes made to our webserver.
This is the version we are currently showing, from piwik.php:
@version $Id: piwik.php 7286 2012-10-23 09:22:19Z matt $
The web control panel shows an update is available, what would be the hazards of applying that?
updating Matomo is probably a good idea, but I’d solve the no-data-issue first.
You can check the php error_log to check if there is any kind of server-side error.
And you can check the integration into your website by opening it, checking the console in the browsers developer tools for errors, checking the piwik.php and piwik.js request in the network tab and enabling debugging
I’m beginning to think it’s more a php issue than a piwik issue.
The log is full of errors like this:
[06-Mar-2018 20:06:51] PHP Warning: PHP Startup: Unable to load dynamic library ‘C:\Program Files (x86)\PHP\ext\php_wincache.dll’ - The specified module could not be found.
in Unknown on line 0
[03-May-2018 13:17:30] PHP Warning: PHP Startup: Unable to load dynamic library ‘C:\Program Files (x86)\PHP\ext\php_wincache.dll’ - The specified module could not be found.
in Unknown on line 0
Those are the last two lines! Nothing written between Mar 6 and May 3?
Then, the last reference to piwik was this (I cannot account for the Mar 7 date):
[07-Mar-2018 03:32:23] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 35 bytes) in D:\inetpub\wwwroot\piwik\core\DataTable.php on line 1059
The log file was 625MB. I’ve renamed it out of the way, to start a new, more easily digestible file.
Ok, found one issue, the scheduled task (Windows analog to cron) was failing to launch. Fixed that issue.
On the dashboard, there is now a non-flat graph for visits over time for the range 4/1/2018 to 4/30/2018, but the frequency overview is still showing zeros.
Will those get updated as the archive process proceeds? (MySqlD seems quite busy, averaging 20-30% of CPU.
Ok, making good progress. Now getting populated reports for recent months, except for March. The summary graph shows activity, but the frequency overview is all 0’s. February, April and May all show activity.