API: Last 12 months, this month missing data!


#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.

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!!


(Lukas Winkler) #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…