Pageview and action level activities are zero

I have a very strange problem. Piwik was working just fine. But suddenly it stopped showing pageview or any other action level statistics like unique page view, outlink clicks, … but visit level statistics are just fine. What could be the reason?? in the following figure you can see pageview and unique pageview are zero while visits are not. On april 12th, I had a db issue and had to repair piwik tables that is why traffic is dropped on april 12th. But, they have been all fine after that but still no pageview is being collected.

Check your error logs? maybe some other mysql tables is broken?

There is nothing is apache http error log and all tables seems to be fine. Is there a way to turn on more verbose error logging? to file or console?

Do you run: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo

The output of this script can be saved to file which could help finding out if there is no visit.

Also check your visitor ;log, is there no visit there as well? if so check the FAQ “no data”

Here is the output of the archiver:

[2012-04-24 17:08:57] [8d1a5440] see doc at: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo
[2012-04-24 17:08:57] [8d1a5440] ---------------------------
[2012-04-24 17:08:57] [8d1a5440] INIT
[2012-04-24 17:08:57] [8d1a5440] Querying Piwik API at: http://www.XXXXXXX.com/index.php
[2012-04-24 17:08:57] [8d1a5440] Running as Super User: admin
[2012-04-24 17:08:57] [8d1a5440] Notes
[2012-04-24 17:08:57] [8d1a5440] - Reports for today will be processed at most every 600 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-04-24 17:08:57] [8d1a5440] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-04-24 17:08:57] [8d1a5440] - Archiving was last executed without error 5 days 11 hours ago
[2012-04-24 17:08:57] [8d1a5440] Will process 3 websites with new visits since 5 days 11 hours , IDs: 1, 2, 3
[2012-04-24 17:08:57] [8d1a5440] ---------------------------
[2012-04-24 17:08:57] [8d1a5440] START
[2012-04-24 17:08:57] [8d1a5440] Starting Piwik reports archiving…
[2012-04-24 17:08:57] [8d1a5440] Archived website id = 1, period = day, Time elapsed: 0.126s
[2012-04-24 17:08:57] [8d1a5440] Archived website id = 1, period = week, 56300 visits, Time elapsed: 0.122s
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 1, period = month, 72307 visits, Time elapsed: 0.132s
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 1, period = year, 72307 visits, Time elapsed: 0.142s
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 1, today = 899 visits, 4 API requests, Time elapsed: 0.522s [1/3 done]
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 2, period = day, Time elapsed: 0.092s
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 2, period = week, 24942 visits, Time elapsed: 0.122s
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 2, period = month, 30197 visits, Time elapsed: 0.132s
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 2, period = year, 30197 visits, Time elapsed: 0.132s
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 2, today = 440 visits, 4 API requests, Time elapsed: 0.479s [2/3 done]
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 3, period = day, Time elapsed: 0.088s
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 3, period = week, 21805 visits, Time elapsed: 0.122s
[2012-04-24 17:08:58] [8d1a5440] Archived website id = 3, period = month, 26144 visits, Time elapsed: 0.122s
[2012-04-24 17:08:59] [8d1a5440] Archived website id = 3, period = year, 26144 visits, Time elapsed: 0.132s
[2012-04-24 17:08:59] [8d1a5440] Archived website id = 3, today = 346 visits, 4 API requests, Time elapsed: 0.465s [3/3 done]
[2012-04-24 17:08:59] [8d1a5440] Done archiving!
[2012-04-24 17:08:59] [8d1a5440] ---------------------------
[2012-04-24 17:08:59] [8d1a5440] SUMMARY
[2012-04-24 17:08:59] [8d1a5440] Total daily visits archived: 1685
[2012-04-24 17:08:59] [8d1a5440] Archived today’s reports for 3 websites
[2012-04-24 17:08:59] [8d1a5440] Archived week/month/year for 3 websites.
[2012-04-24 17:08:59] [8d1a5440] Skipped 0 websites: no new visit since the last script execution
[2012-04-24 17:08:59] [8d1a5440] Skipped 0 websites day archiving: existing daily reports are less than 600 seconds old
[2012-04-24 17:08:59] [8d1a5440] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2012-04-24 17:08:59] [8d1a5440] Total API requests: 12
[2012-04-24 17:08:59] [8d1a5440] done: 3/3 100%, 1685 v, 3 wtoday, 3 wperiods, 12 req, 1467 ms, no error
[2012-04-24 17:08:59] [8d1a5440] Time elapsed: 1.467s
[2012-04-24 17:08:59] [8d1a5440] ---------------------------
[2012-04-24 17:08:59] [8d1a5440] SCHEDULED TASKS
[2012-04-24 17:08:59] [8d1a5440] Starting Scheduled tasks…
[2012-04-24 17:08:59] [8d1a5440] No task to run
[2012-04-24 17:08:59] [8d1a5440] done

And yes, piwik_log_visit has valid rows! that mean visits are logged, but page views are not calculated!

The archive script shows there is data being processed for id=1,2,3 - are you sure you select ther ight date in the calendar?