Core:delete-logs-data command Not deleting from log_action table

Support & Bugs
1

Hi,

I have executed the following using command prompt

./console core:delete-logs-data

But it is not deleting records from piwik_log_action table but when I execute following

./console core:archive

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.

Many thanks.

Kind Regards,
Saqib

2

No one ??

I have the same problem, the console core command delete-logs-data does not delete data from piwik_log_action.
Current piwik version: 2.16.5

Thanks !!

3

Hi,

Im tracking few sites with log analytics and i have 2 problems:

  1. 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).

  2. 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_.

4

Hi @glatzenarsch

This may solve your problem , have a look here :
http://piwik.org/faq/how-to/faq_20184/

Kind Reagrds,
Saqib

5

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

6

when i delete everything page count is 0, and than i run procedure import-archive page count is 36857, again i delete everything page count is 0 and import-archive gives me 39857 pageview

select DISTINC* from piwik_archive_numeric_2016_10 where idsite=12 and name=“Actions_nb_pageviews” and date1=“2016-10-09”;
±----------±---------------------±-------±-----------±-----------±-------±--------------------±------+
| idarchive | name | idsite | date1 | date2 | period | ts_archived | value |
±----------±---------------------±-------±-----------±-----------±-------±--------------------±------+
| 22193 | Actions_nb_pageviews | 12 | 2016-10-09 | 2016-10-09 | 1 | 2016-10-20 09:25:41 | 36857 |
±----------±---------------------±-------±-----------±-----------±-------±--------------------±------+
1 row in set (0.00 sec)

select DISTINC* from piwik_archive_numeric_2016_10 where idsite=12 and name=“Actions_nb_pageviews” and date1=“2016-10-09”;
±----------±---------------------±-------±-----------±-----------±-------±--------------------±------+
| idarchive | name | idsite | date1 | date2 | period | ts_archived | value |
±----------±---------------------±-------±-----------±-----------±-------±--------------------±------+
| 22193 | Actions_nb_pageviews | 12 | 2016-10-09 | 2016-10-09 | 1 | 2016-10-20 09:33:41 | 0 |
±----------±---------------------±-------±-----------±-----------±-------±--------------------±------+
1 row in set (0.00 sec)

select DISTINC* from piwik_archive_numeric_2016_10 where idsite=12 and name=“Actions_nb_pageviews” and date1=“2016-10-09”;
±----------±---------------------±-------±-----------±-----------±-------±--------------------±------+
| idarchive | name | idsite | date1 | date2 | period | ts_archived | value |
±----------±---------------------±-------±-----------±-----------±-------±--------------------±------+
| 22193 | Actions_nb_pageviews | 12 | 2016-10-09 | 2016-10-09 | 1 | 2016-10-20 09:40:30 | 39857 |
±----------±---------------------±-------±-----------±-----------±-------±--------------------±------+
1 row in set (0.00 sec)

AND log link visit action is only 1379 which is 28 times more…

select DISTINCT count() from piwik_log_link_visit_action where idsite=12 and server_time LIKE ‘2016-10-09%’;
±---------+
| count() |
±---------+
| 1379 |
±---------+
1 row in set (0.23 sec)

and every time i do procedure pageview is rising