I just updated to Piwik version 2.10.0 by unziping the zipfile, moving my config file into it, and then clearing the cache via php on the command line.

When I go to $URL/index.php?module=MultiSites&action=index&idSite=5&period=day&date=today

I get error message:
API returned an error: Sequence 'piwik_archive_numeric_2015_01' not found. at Sequence.php:99