First off, I know there is a wiki article on this, but how come there isn’t a way to delete statistics for a website within Piwik itself? Why was a Wiki article written about it yet it wasn’t implemented as a feature? I find that absolutely crazy. (wiki is How do I delete all statistics for a given website, or for all websites? - Analytics Platform - Matomo)
I tried to delete the tables using the query on that wiki however I always get an error “#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE idsite 2’ at line 1”. I have tried all sorts of variations of the WHERE command, using different quotation marks, spaces in different places - everything - and it’s just not working. I’m on the latest MySQL.
But then I just all out go and delete all of the archive blob and numeric tables however the ones for this and last month keep reappearing even after dropping them. I don’t understand what’s going on and why this can’t be simpler.