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?