Empty reports - Fresh Install

Hi I installed Piwik this morning. I can see from the live traffic that the traffic tag is working.
The cron for processing I have not done yet, but I have triggered it manually a few times to check for errors and that is all working fine.

The reports are all empty though, so I am suspecting that the logs are not being processed, can somebody point me where to start looking? (I have disabled in the mysql FILE load option.)

START
Starting Piwik reports archiving…

  • tracking data found for website id 1 since 2016-07-06 22:00:00 UTC (since midnight)
    Will pre-process for website id = 1, period = day, date = last3
  • pre-processing all visits
    Archived website id = 1, period = day, 0 segments, 0 visits in last 3 days, 0 visits today, Time elapsed: 13.139s
    Will pre-process for website id = 1, period = week, date = last3
  • pre-processing all visits
    Archived website id = 1, period = week, 0 segments, 1104 visits in last 3 weeks, 1104 visits this week, Time elapsed: 10.586s
    Will pre-process for website id = 1, period = month, date = last3
  • pre-processing all visits
    Archived website id = 1, period = month, 0 segments, 1104 visits in last 3 months, 1104 visits this month, Time elapsed: 8.570s
    Will pre-process for website id = 1, period = year, date = last3
  • pre-processing all visits
    Archived website id = 1, period = year, 0 segments, 1104 visits in last 3 years, 1104 visits this year, Time elapsed: 16.300s
    Archived website id = 1, 4 API requests, Time elapsed: 48.652s [1/1 done]
    Done archiving!

SUMMARY
Total visits for today across archived websites: 1104
Archived today’s reports for 1 websites
Archived week/month/year for 1 websites
Skipped 0 websites

  • 0 skipped because no new visit since the last script execution
  • 0 skipped because existing daily reports are less than 1800 seconds old
  • 0 skipped because existing week/month/year periods reports are less than 3600 seconds old
    Total API requests: 4
    done: 1/1 100%, 1104 vtoday, 1 wtoday, 1 wperiods, 4 req, 48779 ms, no error
    INFO [2016-07-07 11:45:59] Time elapsed: 48.779s

Just another copy of latest run of the console command, reports still empty.
I had a look and the database tables are also mostly empty, except there are archive tables now, so if I understand the system correctly it is processing the logs and archiving them, but somehow the data is not inserted into the correct tables, but no errors anywhere.

INFO [2016-07-07 14:16:35] SUMMARY
INFO [2016-07-07 14:16:35] Total visits for today across archived websites: 3026
INFO [2016-07-07 14:16:35] Archived today’s reports for 1 websites
INFO [2016-07-07 14:16:35] Archived week/month/year for 1 websites
INFO [2016-07-07 14:16:35] Skipped 0 websites
INFO [2016-07-07 14:16:35] - 0 skipped because no new visit since the last script execution
INFO [2016-07-07 14:16:35] - 0 skipped because existing daily reports are less than 60 seconds old
INFO [2016-07-07 14:16:35] - 0 skipped because existing week/month/year periods reports are less than 3600 seconds old
INFO [2016-07-07 14:16:35] Total API requests: 4
INFO [2016-07-07 14:16:35] done: 1/1 100%, 3026 vtoday, 1 wtoday, 1 wperiods, 4 req, 40391 ms, no error
INFO [2016-07-07 14:16:35] Time elapsed: 40.391s

1 Like

Are the archive tables empty, or do they contain records?

can you check you are looking at the right website and the correct date?

Hate to admit this…it was the date! Did not realise that the date defaults to previous day which is obviously empty with a new install. Also hate to admit that it took far too long to realise that :slight_smile:

All working.