New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
API returned an error: Sequence 'piwik_archive_numeric_2015_01' not found. at Sequence.php:99 #6929
Comments
Hi there, to fix this issue you can execute the Mysql QUERY:
|
Similar issues were repoted on the forum more than once. Couldn't we simply create the sequence when it isn't found but should be |
see #6815 reason we didnt so far put a workaround is because it's a one-off issue, only heappen when old users upgrade, and in quite particular edge case... |
IIRC there was one on the german forum having the issue after upgrading |
I am experiencing the same issue - the insert fixed it for January, but now it is back. Will I have to run the insert each month? Piwik 2.10.0, always upgraded from dashboard (no manual stuff like ftp uploads, mysql schema upgrades etc). |
mysql> INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_01' , 99999); |
I'm still getting this issue after upgrading to Piwik 2.11. |
Let me know if there's any more information I can provide. |
We need to do something about this bug, adding |
@tsteur maybe you have an idea how we could fix this one in a proper way? |
New month, new luck. All my APIs requests from WordPress did have the error for the new month. INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_03' , 99999) did solve the problem for now, but I did a regular update via Dashboard and nothing in special. Please fix this before the next month. Thanks. |
That's strange but I also got this error in the UI tests after upgrading the OmniFixture, eg. http://builds-artifacts.piwik.org/ui-tests.transitions_deterministic_order/10588.8/screenshot-diffs/singlediff.html?processed=../processed-ui-screenshots/EvolutionGraph_annotations_none.png&expected=EvolutionGraph_annotations_none.png&github=EvolutionGraph_annotations_none.png I'll take a look at this bug... |
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
The text was updated successfully, but these errors were encountered: