@Viviansweaty opened this Issue on September 5th 2017

@tsteur
Hi, there

I want to delete the specific data which I imported.

for example,
I imported June's data but for some reason I want to delete the log of idsite=100 (only this part)

I try below
./console core:delete-logs-data --dates=2017-06-01,2017-06-30 --idsite=100
delete from piwik_archive_numeric_2017_06 where idsite=100;
delete from piwik_archive_blob_2017_06 where idsite=100;

but it seemed that didn't work and the data(idsite=100's part) still there
is there any wrong with the code I used? or there has another way to remove it.

I appreciate your kindly help as always.
Regards,

@mattab commented on September 18th 2017 Owner

but it seemed that didn't work and the data(idsite=100's part) still there

Do you mind posting the full output of the script, as well as what SQL queries you run to check that data is still there for those dates?

Powered by GitHub Issue Mirror