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
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.
Hi @uok, thanks for creating this issue. I tested the SQL and indeed it does not emptying the
log_action table, just deletes rows from it.
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.