I have executed the following using command prompt
But it is not deleting records from piwik_log_action table but when I execute following
then data is been deleting from piwik_log_action . It has solved my problem but this command also creates report archive tables and I do not want these report archive tables to be processed . I just want to delete data only .
Anyone have idea why first command is not working accordingly.
Im tracking few sites with log analytics and i have 2 problems:
i send one day log file with piwik import script and then execute core:archive script on piwik it has all records on dashboard, but when i reprocess for second time, records are increasing every time i run archiving.
I deleted all visitor log data and reports for a given date and website with core:delete comands, and directly in mySQL and my dashboard for specific date is empty, but when i import logs again and run archiving i get valid records except PAGEVIEWS which are increased proportionally every time i run this procedure ( import-archive).
how can i delete my historical pageview information for specific day, i tried with core:delete, core:clear-caches, optimizing database and manualy deleting old visitor logs and reports from:
piwik_log_conversion_item, piwik_log_conversion, piwik_log_link_visit_action, piwik_log_visit, piwik_log_action, (archive_numeric_) and blob archive tables (archive_blob_.
and after that dashboard for specific site and day is empty and after first procedure of importing and archiving same logs for that site and day all information except pageview is fine, pageviews are increased every time i repeat this procedure as if something is not deleted or its cashed somewhere (pageview count) :S