Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Question about "how to delete specific log" #11998

Open
Viviansweaty opened this issue Sep 5, 2017 · 1 comment
Open

Question about "how to delete specific log" #11998

Viviansweaty opened this issue Sep 5, 2017 · 1 comment

Comments

@Viviansweaty
Copy link

@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
Copy link
Member

mattab commented Sep 18, 2017

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants