Skip to content
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

Archive tables going back years for new installation #7211

Open
iquito opened this issue Feb 15, 2015 · 1 comment
Open

Archive tables going back years for new installation #7211

iquito opened this issue Feb 15, 2015 · 1 comment
Labels
Bug For errors / faults / flaws / inconsistencies etc.

Comments

@iquito
Copy link

iquito commented Feb 15, 2015

I have started using Piwik in May of 2014, but noticed that the piwik_archive_ tables go back until 2004_09 - meaning Piwik created tables for every month since 2004_09, which are all complete empty until 2014_01.

This means there are 224 empty tables (2004_09-2013_12 for _blob and _numeric) in my Piwik installation which will never have any data in them. Is this a bug, or can this behavior somehow be changed? Maybe Piwik could notice itself when the oldest entry was made, so no unnecessary tables are created.

@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Feb 16, 2015
@mattab mattab added this to the Short term milestone Feb 16, 2015
@mattab
Copy link
Member

mattab commented Feb 16, 2015

Hi @iquito yes it's a bug, I have noticed it before on the demo.piwik.org as well. I guess there is some code path that sometimes will trigger the archiving with an old date, causing this bug. To fix, we could ensure that we don't create archive tables for dates older than the oldest websites in the piwik instance.

@mattab mattab modified the milestones: Short term, Mid term Apr 7, 2015
@mattab mattab modified the milestones: Long term, Mid term Dec 5, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Development

No branches or pull requests

2 participants