Page Statics – Top Trend stats don’t work correctly

Hi @mostafas1990

Could you be so kind and look into this issue?

Thanks!

Hello @horgster,

Thank you for bringing this to our attention. I apologize for the confusion caused by the inconsistent information displayed in WP Statistics.

I would recommend updating to the latest version to see if that resolves the issue. If it does not, please reach out to us at [email protected]. Our team is here to help.

Best regards,

Mohammadreza

Hi @reventon94

I have the latest version installed: version 13.2.16…….

When navigating to Pages Statistics.
If filter the timeframe from e.g. 2023-02-06 to 2023-02-09 and press “GO”,
the Top Pages section DO NOT reflect the top pages visits for that timeframe. This has been working in version 12.x of this plugin.

Ref picture:
https://pasteboard.co/qvwubybjHgCJ.png

Can you please be so kind to fix this?

Hi @reventon94 and @mostafas1990

Do you have an status on this issue?

I’d prefer you to wait until the release of version 14.0 because there are a lot of upcoming updates and features.

Hey @mostafas1990

Thanks for your kind answer.
I have upgraded to the 14.0.1.. The problem still exist and the Top Pages is not filtered with the custom dates.

Why have you decided to only show 5 url’s per page in the Top Pages`?
Why break something that was working..

Hi,

I have upgraded to the 14.0.1.. The problem still exist and the Top Pages is not filtered with the custom dates.

Can you introduce the issue by screenshot?

Why have you decided to only show 5 url’s per page in the Top Pages`?

Good point, I’ve changed it to 25.

https://github.com/wp-statistics/wp-statistics/commit/655ed1d179a93c67a62ac0940086489e46f3fc56

Hi @mostafas1990

Thanks for great support!

Thumbs up for changing to displaying 25 urls.

Here is the problem:

This Year statistics:
https://paste.pics/ff9b88bb9597ef1fe800c311396a0f5b

14 Days statistics:
https://paste.pics/4febb8ea7fe67d3e7577fc9768d4e03e

Yesterday stats:
https://paste.pics/f57d52a4990dfcae5c10290a0788b3de

As you can see, the Top Pages is not displayed correctly accordingly to dates / time period that is selected/filtered. This was working 100% correctly in version 12.x

We appreciate the screenshots because they help us identify the problems, but after checking this section against our development, it appears to be working as intended.

https://capture.dropbox.com/eZCZGqySqBaV7jxl

Weird indeed.

@mostafas1990

Could be due to incorrect date format in the code and the database?
It works if I rollback to the old version ?12.6.3.. The WordPress installation is running i NB-NO language.

Any chance to do some debugging together?

• This reply was modified 1 year, 9 months ago by horgster.

Not entirely sure, but let’s debug the queries, Can you please take a look at the queries on the current page by Query Monitor?

@mostafas1990

Query: pages::getTop()

SELECT?pages.date,pages.uri,pages.id,pages.type, SUM(pages.count) + IFNULL(historical.value, 0)?AS?count_sum
FROM?XXX_statistics_pages pages
LEFT?JOIN?XXX_statistics_historical historical
ON?pages.uri=historical.uri
AND?historical.category=’uri’
WHERE?(pages.date?BETWEEN?‘2023-01-29’
AND?‘2023-02-28’)
GROUP?BY?uri
ORDER?BY?count_sum?DESC
LIMIT?0,5

5 rows returned.

@mostafas1990

I only have these WP Stats Queries available:
https://paste.pics/c5b69a6a897c47804caaf3971b20f252

What is the query name for the Top Pages ?

Hi @horgster

Thank you for debugging, the query that you provided is correct.

What is the query name for the Top Pages ?

It’s Pages::getTop();

Hi @mostafas1990

Are we running same query in the 12.6.3 version?
Remember that the summarization works perfect in the old version.

So what should we do next to debug this further?