Mysqli prepare error: Unknown column 'value' in 'field list'

Support & Bugs
1

Hej!
Every time I run the archive.sh for piwik I got for both websites the following error:

Archiving period = week for idsite = 1…

<?xml version="1.0" encoding="utf-8" ?> Archiving period = month for idsite = 1... <?xml version="1.0" encoding="utf-8" ?> Archiving period = year for idsite = 1... Unknown column 'value' in 'field list<?xml version="1.0" encoding="utf-8" ?> 75303 40796 Archiving for idsite = 1 done!

For idsite 2 it’s the same. Any idea what I can do? I run Piwik 2.1 on PHP 5.5 with MySQL 5.5.

Thanks,
Tim

2

Matt said in 2012 that archive.sh was deprecated…

“Because we now recommend to use archive.php, archive.sh is deprecated but will still work probably forever”

Source: 301 Moved Permanently

Maybe try with archive.php instead ?

Dali

3

Thanks Dali.
I tried it with the php file, but got the same result… :frowning:

SUMMARY OF ERRORS
Error: Got invalid response from API request: http://piwik.rootsrv.eu/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=week&date=last260&format=php&token_auth=e60b62f21b1d326e64dff5a31687c54f&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:60:“Mysqli prepare error: Unknown column ‘value’ in ‘field list’”;}'
Error: Got invalid response from API request: http://piwik.rootsrv.eu/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=month&date=last52&format=php&token_auth=e60b62f21b1d326e64dff5a31687c54f&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:60:“Mysqli prepare error: Unknown column ‘value’ in ‘field list’”;}'
Error: Got invalid response from API request: http://piwik.rootsrv.eu/index.php?module=API&method=VisitsSummary.getVisits&idSite=2&period=week&date=last260&format=php&token_auth=e60b62f21b1d326e64dff5a31687c54f&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:60:“Mysqli prepare error: Unknown column ‘value’ in ‘field list’”;}'
Error: Got invalid response from API request: http://piwik.rootsrv.eu/index.php?module=API&method=VisitsSummary.getVisits&idSite=2&period=month&date=last52&format=php&token_auth=e60b62f21b1d326e64dff5a31687c54f&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:60:“Mysqli prepare error: Unknown column ‘value’ in ‘field list’”;}'
Error: Got invalid response from API request: http://piwik.rootsrv.eu/index.php?module=API&method=CoreAdminHome.runScheduledTasks&format=csv&convertToUnicode=0&token_auth=e60b62f21b1d326e64dff5a31687c54f&trigger=archivephp. Response was 'task,output
CoreAdminHome.purgeOutdatedArchives,ERROR: Mysqli prepare error: Unknown column ‘value’ in 'where clause’
PrivacyManager.deleteReportData,Time elapsed: 0.125s
PrivacyManager.deleteLogData,Time elapsed: 0.124s
Piwik\Plugins\CorePluginsAdmin\MarketplaceApiClient.clearAllCacheEntries,Time elapsed: 0.002s
CoreAdminHome.optimizeArchiveTable,Time elapsed: 0.028s
DBStats.cacheDataByArchiveNameReports,ERROR: Mysqli prepare error: Unknown column ‘value’ in ‘field list’'
5 total errors during this script execution, please investigate and try and fix these errors
ERROR: 5 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://piwik.rootsrv.eu/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=week&date=last260&format=php&token_auth=e60b62f21b1d326e64dff5a31687c54f&trigger=archivephp. Response was ‘a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:60:“Mysqli prepare error: Unknown column ‘value’ in ‘field list’”;}’

4

did it use to work and just now stop failing?

5

I’m not sure. Checking the cronjobs the first time after a long period to check if everything is fine. But now it fails every time.