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
Comments
Are you able to reproduce that on http://demo.piwik.org ? |
Please also let us know whether the last day you are using is |
I was wondering whether you basically did this on Feb 22? This would mean 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. |
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! |
I just noticed while our API method 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 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; |
period=5 seems not to be defined in our instance.
There are just values for periods 1 to 3.
|
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; |
ping @babielau (see previous comment) - let us know! |
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: 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? |
@mattab: Any news? |
Sorry we are not able to reproduce the issue without more information on how to reproduce... Does anyone else experience this issue? |
Fyi: if you need our professional support we can help, feel free to contact us at: http://piwik.org/support/ |
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! |
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:
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
The text was updated successfully, but these errors were encountered: