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

Insights No rows match the criteria when "all" is selected #14124

Closed
mritzmann opened this issue Feb 21, 2019 · 9 comments · Fixed by #14356
Closed

Insights No rows match the criteria when "all" is selected #14124

mritzmann opened this issue Feb 21, 2019 · 9 comments · Fixed by #14356
Labels
Bug For errors / faults / flaws / inconsistencies etc.

Comments

@mritzmann
Copy link

mritzmann commented Feb 21, 2019

Problem

The Insights are no longer displayed. Message: No rows match the criteria

screenshot

  • To be found at Behaviour -> pages -> Switch Table to Insights
  • URL: /index.php?module=CoreHome&action=index&idSite=7&period=day&date=yesterday&updated=4#?idSite=7&period=day&date=2019-02-14&category=General_Actions&subcategory=General_Pages

Reproducible

The problem does not occur in the demo version.

System

  • Matomo Version: 3.8.1
  • PHP 5.6.40

Notes

The html alt tag says:

The following rows have a growth of at least 1% compared to Wed, Feb 13. Changes affecting less than 3 visits were ignored.

The Pages Views are different enough in my case.


Maybe the problem is already known?

@tsteur
Copy link
Member

tsteur commented Feb 21, 2019

I tested on various instances and it works fine everywhere. Does it work for you for other day? or when comparing for other periods?

@mritzmann
Copy link
Author

mritzmann commented Feb 25, 2019

Does it work for you for other day?

Does not work for any date.

or when comparing for other periods?

Tested previous day and same day in the previous week. Unfortunately both do not work.

Today I cloned the installation and disabled all non-core plugins. Problem exists. Maybe you have an idea how I can debug this?

@tsteur
Copy link
Member

tsteur commented Feb 25, 2019

I've looked into the code but can't really see any reason why it shouldn't work. Is there any chance you could give us view access and email us credentials at hello at matomo.org ?

Can you otherwise maybe access your database and see if the SQL query gives you a result for your username?
select * from matomo_option where option_name like '%viewdata%actions%getpageurls%' (you may need to adjust the prefix) or maybe try another user?

@hebnony
Copy link

hebnony commented Mar 6, 2019

I have the same problem since 1 to 3 month.
Matomo version: 3.8.1
MySQL version: 5.7.21
PHP version: 5.6.33
Under docker.

@b3wii
Copy link

b3wii commented Apr 8, 2019

Same problem:
Matomo version: 3.9.1
MySQL version: 10.1.37
PHP version: 7.2.15

@tsteur
Copy link
Member

tsteur commented Apr 8, 2019

To investigate the issue, someone would ideally give us access to their Matomo and server (so we can debug and find the issue).

@moedech
Copy link

moedech commented Apr 12, 2019

We will prepare a copy for you @tsteur and send you the login credentials

@tsteur
Copy link
Member

tsteur commented Apr 16, 2019

Cheers. I've replied.

@tsteur tsteur added the Bug For errors / faults / flaws / inconsistencies etc. label Apr 17, 2019
@tsteur
Copy link
Member

tsteur commented Apr 17, 2019

We can reproduce the issue when selecting "all" in the filter limit

@mattab mattab changed the title Insights No rows match the criteria Insights No rows match the criteria when "all" is selected Jun 29, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants