API: Last 12 months, this month missing data!

Support & Bugs
1

Hi Matomo,

We are running Piwik 2.16.1. The data in Piwik is showing but when we request the API last 12months we have the last month missing in data.

https://ibb.co/6BSFs13
https://ibb.co/6BSFs13431×570 64.3 KB

For every site it is:

<result date="2019-03"/></result>

Also for last 30 days:
cpiwik/index.php?module=API&method=VisitsSummary.get&idSite=all&period=month&date=last1&format=xml&token_auth=xxxxx

Most of the last 30 days are just empty…

In MySQL We see that “piwik_archive_numeric_2019_03” has twice as many entries as last months, but IDs seem to be double… Maybe there is something wrong there?

Hope someone can help us out with our missing data!!

2

Hi,

Keep in mind that there are 23 stable releases since 2.16.1.
Chances are that one of them has fixed this issue.

3

Hi,

I have found the issue already:

It was my php_imap.dll extension, i have commented this in php.ini and now it works.

Found the issue with running Archive, which was throwing errors.
misc/cron/archive.php?token_auth=xxxxx

Yes we should upgrade, the only thing why we didn’t upgrade before is that the API changed a lot and we have to rewrite all our dashboards…

1 Like