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

Serious error in GUI export #9877

Closed
AndrewAuwel opened this issue Mar 4, 2016 · 15 comments
Closed

Serious error in GUI export #9877

AndrewAuwel opened this issue Mar 4, 2016 · 15 comments
Labels
answered For when a question was asked and we referred to forum or answered it. Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users.

Comments

@AndrewAuwel
Copy link

Hi!

There seems to be a serious bug in Piwik:

If you select a date range and try to export a TSV over the GUI, under strange circumstances (high traffic website, site with deep navigation) the exported file shows incorrect statistics. Also the diagram shows incorrect values.

Here a screenshot:
day_gui

The respective URL has 1149 views on Feb 22. The diagram and the exported TSV file show 0 views on this day.

I run Piwik in version 2.15 (but this error already occured in previous versions).

The selection of date ranges seems very unreliable to me. There occured different erros in the past.

Any help?

Thanks and best
hulotte

@sgiehl
Copy link
Member

sgiehl commented Mar 5, 2016

Are you able to reproduce that on http://demo.piwik.org ?
If it is reproducable please post the steps for reproducing and we will have a look.

@tsteur
Copy link
Member

tsteur commented Mar 6, 2016

Please also let us know whether the last day you are using is today or whether it is a day in the past.

@AndrewAuwel
Copy link
Author

@sgiehl: I already tried that but the error is not reproducable

@tsteur: I am not 100% sure what you mean with the last day I am using. I compared the numbers for Feb 22 by choosing today vs the numbers from Feb 10 to Feb 23 by choosing date range.

@tsteur
Copy link
Member

tsteur commented Mar 7, 2016

I was wondering whether you basically did this on Feb 22? This would mean Feb 22 was today on that day.

Do you maybe remember if you have used this date range before?

Is it maybe possible to get access to your Piwik instance and database? I presume that some kind of archives were marked as finished although they maybe weren't and it's not rearchiving. I can also give you a command to re-archive the data which might fix it.

@AndrewAuwel
Copy link
Author

I checked the statistics on Feb 23 and then again on March 4, so I used this date range before.

I'm afraid we cannot grant access to our Piwik instance and/or database. But the re-archiving idea sounds plausible. Would be great if you could give us the command for re-archiving the data!

@tsteur
Copy link
Member

tsteur commented Mar 8, 2016

I just noticed while our API method invalidateArchivedReports says it does support to invalidate range archives, it does not really support it. It's buggy. I've created an issue for this (#9898).

A workaround that you could try would be to execute the following SQL query to remove the archives from DB manually (you might need to adjust idsite value and prefix for archive table):

delete from `piwik_archive_numeric_2016_02` where date1 = "2016-02-10" and date2= "2016-02-23" and period = 5 and idsite = 1;
delete from `piwik_archive_blob_2016_02` where date1 = "2016-02-10" and date2= "2016-02-23" and period = 5 and idsite = 1;

@AndrewAuwel
Copy link
Author

period=5 seems not to be defined in our instance.

mysql> select name, date1, date2, period from piwik_archive_numeric_2016_02 where period=5;
Empty set (0.00 sec)

mysql> select name, date1, date2, period from piwik_archive_numeric_2016_03 where period=5;
Empty set (0.00 sec)

mysql> select name, date1, date2, period from piwik_archive_blob_2016_02 where period=5;
Empty set (0.00 sec)

mysql> select name, date1, date2, period from piwik_archive_blob_2016_03 where period=5;
Empty set (0.00 sec)

There are just values for periods 1 to 3.

mysql> select distinct(period) from piwik_archive_numeric_2016_02;
+--------+
| period |
+--------+
|      1 |
|      2 |
|      3 |
+--------+
3 rows in set (0.02 sec)

mysql> select distinct(period) from piwik_archive_numeric_2016_03;
+--------+
| period |
+--------+
|      1 |
|      2 |
|      3 |
+--------+
3 rows in set (0.00 sec)

mysql> select distinct(period) from piwik_archive_blob_2016_02;
+--------+
| period |
+--------+
|      1 |
|      2 |
|      3 |
+--------+
3 rows in set (0.05 sec)

mysql> select distinct(period) from piwik_archive_blob_2016_03;
+--------+
| period |
+--------+
|      1 |
|      2 |
|      3 |
+--------+
3 rows in set (0.00 sec)

@tsteur
Copy link
Member

tsteur commented Mar 13, 2016

Sorry, just noticed the query wouldn't solve it in this case. Try

delete from `piwik_archive_numeric_2016_02` where date1 = "2016-02-22" and date2= "2016-02-22" and period = 1 and idsite = 1;
delete from `piwik_archive_blob_2016_02` where date1 = "2016-02-22" and date2= "2016-02-22" and period = 1 and idsite = 1;

@mattab
Copy link
Member

mattab commented Mar 31, 2016

ping @babielau (see previous comment) - let us know!

@mattab mattab added the Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. label Mar 31, 2016
@mattab mattab added this to the 2.16.x (LTS) milestone Mar 31, 2016
@AndrewAuwel
Copy link
Author

It takes some time to clone the DB of our live Piwik instance and copy it into our Piwik development instance.

Or is there an easy way to just isolate one idSite (in our case idSite=1) and copy all its data into an new idSite in another Piwik instance (the new idSite should be =30 for example).

@mattab mattab modified the milestones: 2.16.x (LTS), Mid term Apr 1, 2016
@AndrewAuwel
Copy link
Author

@mattab: We executed the commands but it did not help. The exported statistics (from the GUI) and the diagrams are still not delivering consistent statistics (compared to the exported statistics from the API).

Any ideas?

@AndrewAuwel
Copy link
Author

@mattab: Any news?

@mattab
Copy link
Member

mattab commented Jan 9, 2017

Sorry we are not able to reproduce the issue without more information on how to reproduce... Does anyone else experience this issue?

@mattab
Copy link
Member

mattab commented Jan 9, 2017

Fyi: if you need our professional support we can help, feel free to contact us at: http://piwik.org/support/

@mattab
Copy link
Member

mattab commented Jun 19, 2017

Besides #9898 we are not aware of any more problem, and unfortunately can't reproduce. Would be great if you can send us access to your PIwik + steps to reproduce. Feel free to re-open the issue once you do this. Thanks!

@mattab mattab closed this as completed Jun 19, 2017
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Jun 19, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it. Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users.
Projects
None yet
Development

No branches or pull requests

4 participants