Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Loading…

in Visitors - Overview, Action metrics not displayed when report purge is enabled #5054

Closed
anonymous-piwik-user opened this Issue · 16 comments

3 participants

Anonymous Piwik user Matthieu Aubry Thomas Steur
Anonymous Piwik user

hi there,

just did recently wiped all reports older than 3 months, keeping weekly, monthly and yearly.

When I go Actions - Downloads and select e.g. data in last September and

select some day - correctly give message that report doesn't exist - pw_downloads_day.png

select some week - correctly shows data - pw_downloads_week.png

Now going to Visitors - Overview, selecting exactly same week and choosing Download/Unique downloads it shows flat - pw_visitor_log.png

Since data are apparently in Piwik as seen in Actions tab, I guess this is defect. Visitor logs from that period are wiped, so it must be taken from archive.

Piwik 2.2.0

Matthieu Aubry
Owner

Thanks for the report. Could you also attach the settings for the "Delete old report" in Settings>Privacy?

Anonymous Piwik user

See attached settings.png - purge is set to weekly (too small screen to capture it whole) ...

Thomas Steur
Owner

In c9c5e79: refs #5054 this fixes all rows for all periods in old numeric tables were deleted instead of keeping the selected ones

Thomas Steur
Owner

In 3bb6a01: refs #5054 if no period should be kept do not append where clause to prevent mysql error

Thomas Steur
Owner

In c103d03: refs #5054 some more bug fixes and tests

Thomas Steur
Owner

In da9cd11: refs #5054 added integration flag

Thomas Steur
Owner

In 49cb0c5: refs #5054 some code improvements

Thomas Steur
Owner

Fixed. The numeric archives for all periods were deleted when "delete old reports" was enabled instead of keeping the selected ones. It worked fine for blob archives. This explains why data was there in the Downloads report but not in the evolution. Although this bug is fixed the data won't appear in the evolution afterwards as it only fixes future "delete old reports".

Thomas Steur
Owner

In f5c2d9b: refs #5054 fix some tests

Anonymous Piwik user

Thanks for the fix ... I have of course backup of db, but since some time passed, I cannot simply restore it. If I just replace piwik_archive_numeric_201X_XX from backup will it work? How about January archive, it holds yearly reports if I got it right, so can I replace Jan as well and it would re-create reports on next auto-archive?

Thomas Steur
Owner

If you just restore those piwik_archive_numeric_201X_XX tables it should work fine as the blobs should be still there. No need to re-archive then. It should just work. @Matt can you confirm?

Anonymous Piwik user

I just did that and it works pretty fine, all reports are back and kept after purging as well.

Philip Taffner sabl0r referenced this issue from a commit in sabl0r/piwik
Thomas Steur tsteur refs #5054 this fixes all rows for all periods in old numeric tables …
…were deleted instead of keeping the selected ones
c9c5e79
Philip Taffner sabl0r referenced this issue from a commit in sabl0r/piwik
Thomas Steur tsteur refs #5054 if no period should be kept do not append where clause to …
…prevent mysql error
3bb6a01
Philip Taffner sabl0r referenced this issue from a commit in sabl0r/piwik
Thomas Steur tsteur refs #5054 some more bug fixes and tests c103d03
Philip Taffner sabl0r referenced this issue from a commit in sabl0r/piwik
Thomas Steur tsteur refs #5054 added integration flag da9cd11
Philip Taffner sabl0r referenced this issue from a commit in sabl0r/piwik
Thomas Steur tsteur refs #5054 some code improvements 49cb0c5
Philip Taffner sabl0r referenced this issue from a commit in sabl0r/piwik
Thomas Steur tsteur refs #5054 fix some tests f5c2d9b
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.