Error in FAQ: Delete visits using SQL - not everything is deleted #17498
Labels
c: Website matomo.org
For issues related to our matomo.org website.
Milestone
Comments
|
Hi @uok, thanks for creating this issue. I tested the SQL and indeed it does not emptying the It's not a code related issue, I will discuss with the team what is the best way to solve this so we can hopefully get things sorted and working for you. |
flamisz
added
Bug
sgiehl
added
the
c: Website matomo.org
|
@flamisz , can you please provide SQL commands for fixing? Thanks! |
|
Hi @uok, unfortunately, currently, we can't provide an SQL command that emptying |
|
Is this fixed? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
FAQ: https://matomo.org/faq/how-to/faq_20184/
Section "Delete visits using SQL query"
Code "delete all data for a given website"
After running the code with e.g. log_visit.idsite = 1, everything is deleted from all tables except entries in table
log_action.There are many entries left that belong to this site. How can I delete them?
From what I can understand is that info is linked via idaction_name and idaction_url to this table.
What is the correct SQL code for this task?
It would be a lot better, if after a user deletes a website from Matomo GUI also the log data, reports, etc. are deleted from the database. I did not expect the need for this manual step after confirming "Deleting a website will delete all log data that has been collected for it. This action is permanent and cannot be undone." in the GUI.
The text was updated successfully, but these errors were encountered: