Week, Month Views = 0


#1

Hello,

I´ve an error with the Cron Job.
I do not have any numbers for Week and Month Views. It is everytime 0.

Piwik Version = 2.2.2
Server= debian 7.1

Error


Error: Got invalid response from API request: http://myPiwikAddress/piwik/index.php?module=API&method=API.get&idSite=3&period=week&date=last1000&format=php&token_auth=b20191b5d3fa5afdc6170ffc8506e31e&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:71:"Adding a subtable to the row, but it already has a subtable associated.";}'
INFO CoreConsole[2014-05-09 08:43:30] [da0db] Error: Got invalid response from API request: http://myPiwikAddress/piwik/index.php?module=API&method=API.get&idSite=3&period=month&date=last1000&format=php&token_auth=b20191b5d3fa5afdc6170ffc8506e31e&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:192:"This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings > General Settings. (error: id 536 not found).";}'
INFO CoreConsole[2014-05-09 08:43:30] [da0db] Error: Got invalid response from API request: http://myPiwikAddress/piwik/index.php?module=API&method=API.get&idSite=3&period=year&date=last1000&format=php&token_auth=b20191b5d3fa5afdc6170ffc8506e31e&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:192:"This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings > General Settings. (error: id 536 not found).";}'
ERROR CoreConsole[2014-05-09 08:43:30] [da0db] 3 total errors during this script execution, please investigate and try and fix these errors.
ERROR CoreConsole[2014-05-09 08:43:30] [da0db] 3 total errors during this script execution, please investigate and try and fix these errors.

I also have tried with this: --force-all-websites --force-all-periods=315576000 --force-date-last-n=1000 but same error.
And I also deleted the piwik_archive_* Tables via phpmyadmin.

Any solution?


#2

Timeout Value is 10800 seconds…


#3

PHP version upgrade helped someone else with a bug in freebsd maybe this will help you as well?

What php version you running?


#4

I´m running PHP 5.4.4-14


(Matthieu Aubry) #5

Thank you for the report, I have reopened a ticket in our issue tracker API message: This report has been reprocessed since your last click. · Issue #3414 · matomo-org/matomo · GitHub

I hope we can solve it in some future version. do you get this error on every run of archive.php ?

Thanks for your feedback!


#6

Yes I get this Error on every run of Archive.php.