@mattab opened this Issue on December 17th 2017 Member


  1. when a site is deleted we do not actually delete the log_ records for this site, ie. we keep all historical RAW data
  2. when a website is deleted, we delete the row completely from the site table.

so 1) is fine and by design, but 2) is not good enough, as it leads to "orphaned" RAW data logs where we don't know which website the logs (used to) refer to.

-> Instead we should use a soft delete where the row would have a flag deleted=1.

This would make the database represent the real state of the data and be more consistent with our newer practises (ie. soft deletes are used for Goals / Funnels / Forms / Heatmaps / Sessions / Scheduled reports / Segments)

@mattab commented on May 14th 2018 Member

see also #12907 When website has been deleted, we should also delete the raw data for this website

@mattab commented on July 1st 2019 Member

When a website is deleted, we now also delete the RAW data. So this issue is not really needed.
Instead see: https://github.com/matomo-org/matomo/issues/2121
and https://github.com/matomo-org/matomo/issues/9181

This Issue was closed on July 1st 2019
Powered by GitHub Issue Mirror