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

Jump to bottom

API: get PageUrl returns same results for several day #4872

Closed
pvledoux opened this issue Mar 18, 2014 · 4 comments
Closed

API: get PageUrl returns same results for several day #4872

pvledoux opened this issue Mar 18, 2014 · 4 comments
Assignees
@tsteur
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
2.4.0

Comments

@pvledoux
Copy link

Here is the request:

http://analytics.domain.com/index.php?module=API&method=Actions.getPageUrl&date=2014-03-11,2014-03-18&period=day&idSite=1&format=json&token_auth=xxxxx&pageUrl=http://www.domain.com/my/page/

Here is the results:

{
    "2014-03-11": [
        {
            "label": "/my-page",
            "nb_visits": 33,
            "nb_uniq_visitors": 27,
            "nb_hits": 148,
            "sum_time_spent": 12059,
            "nb_hits_with_time_generation": 135,
            "min_time_generation": "0.001",
            "max_time_generation": "5.299",
            "entry_nb_uniq_visitors": "9",
            "entry_nb_visits": "9",
            "entry_nb_actions": "50",
            "entry_sum_visit_length": "9530",
            "entry_bounce_count": "6",
            "exit_nb_uniq_visitors": "12",
            "exit_nb_visits": "13",
            "avg_time_on_page": 365,
            "bounce_rate": "67%",
            "exit_rate": "39%",
            "avg_time_generation": 0.833,
            "url": "http://www.domain.com/my/page/"
        }
    ],
    "2014-03-12": [],
    "2014-03-13": [
        {
            "label": "/my-page",
            "nb_visits": 14,
            "nb_uniq_visitors": 13,
            "nb_hits": 14,
            "sum_time_spent": 1691,
            "nb_hits_with_time_generation": "13",
            "min_time_generation": "0.034",
            "max_time_generation": "0.964",
            "entry_nb_uniq_visitors": "3",
            "entry_nb_visits": "3",
            "entry_nb_actions": "4",
            "entry_sum_visit_length": "10",
            "entry_bounce_count": "2",
            "exit_nb_uniq_visitors": "6",
            "exit_nb_visits": "6",
            "avg_time_on_page": 121,
            "bounce_rate": "67%",
            "exit_rate": "43%",
            "avg_time_generation": 0.478,
            "url": "http://www.domain.com/my/page/"
        }
    ],
    "2014-03-14": [
        {
            "label": "/my-page",
            "nb_visits": 33,
            "nb_uniq_visitors": 27,
            "nb_hits": 148,
            "sum_time_spent": 12059,
            "nb_hits_with_time_generation": 135,
            "min_time_generation": "0.001",
            "max_time_generation": "5.299",
            "entry_nb_uniq_visitors": "9",
            "entry_nb_visits": "9",
            "entry_nb_actions": "50",
            "entry_sum_visit_length": "9530",
            "entry_bounce_count": "6",
            "exit_nb_uniq_visitors": "12",
            "exit_nb_visits": "13",
            "avg_time_on_page": 365,
            "bounce_rate": "67%",
            "exit_rate": "39%",
            "avg_time_generation": 0.833,
            "url": "http://www.domain.com/my/page/"
        }
    ],
    "2014-03-15": [
        {
            "label": "/my-page",
            "nb_visits": 3,
            "nb_uniq_visitors": 3,
            "nb_hits": 3,
            "sum_time_spent": 12,
            "nb_hits_with_time_generation": "3",
            "min_time_generation": "0.555",
            "max_time_generation": "0.775",
            "exit_nb_uniq_visitors": "2",
            "exit_nb_visits": "2",
            "avg_time_on_page": 4,
            "bounce_rate": "0%",
            "exit_rate": "67%",
            "avg_time_generation": 0.652,
            "url": "http://www.domain.com/my/page/"
        }
    ],
    "2014-03-16": [
        {
            "label": "/my-page",
            "nb_visits": 33,
            "nb_uniq_visitors": 27,
            "nb_hits": 148,
            "sum_time_spent": 12059,
            "nb_hits_with_time_generation": 135,
            "min_time_generation": "0.001",
            "max_time_generation": "5.299",
            "entry_nb_uniq_visitors": "9",
            "entry_nb_visits": "9",
            "entry_nb_actions": "50",
            "entry_sum_visit_length": "9530",
            "entry_bounce_count": "6",
            "exit_nb_uniq_visitors": "12",
            "exit_nb_visits": "13",
            "avg_time_on_page": 365,
            "bounce_rate": "67%",
            "exit_rate": "39%",
            "avg_time_generation": 0.833,
            "url": "http://www.domain.com/my/page/"
        }
    ],
    "2014-03-17": [
        {
            "label": "/my-page",
            "nb_visits": 14,
            "nb_uniq_visitors": 13,
            "nb_hits": 14,
            "sum_time_spent": 1691,
            "nb_hits_with_time_generation": "13",
            "min_time_generation": "0.034",
            "max_time_generation": "0.964",
            "entry_nb_uniq_visitors": "3",
            "entry_nb_visits": "3",
            "entry_nb_actions": "4",
            "entry_sum_visit_length": "10",
            "entry_bounce_count": "2",
            "exit_nb_uniq_visitors": "6",
            "exit_nb_visits": "6",
            "avg_time_on_page": 121,
            "bounce_rate": "67%",
            "exit_rate": "43%",
            "avg_time_generation": 0.478,
            "url": "http://www.domain.com/my/page/"
        }
    ],
    "2014-03-18": [
        {
            "label": "/my-page",
            "nb_visits": 33,
            "nb_uniq_visitors": 27,
            "nb_hits": 148,
            "sum_time_spent": 12059,
            "nb_hits_with_time_generation": 135,
            "min_time_generation": "0.001",
            "max_time_generation": "5.299",
            "entry_nb_uniq_visitors": "9",
            "entry_nb_visits": "9",
            "entry_nb_actions": "50",
            "entry_sum_visit_length": "9530",
            "entry_bounce_count": "6",
            "exit_nb_uniq_visitors": "12",
            "exit_nb_visits": "13",
            "avg_time_on_page": 365,
            "bounce_rate": "67%",
            "exit_rate": "39%",
            "avg_time_generation": 0.833,
            "url": "http://www.domain.com/my/page/"
        }
    ]
}

As you can see, there is a repetitive pattern, and results are totally wrong. I compared with results for individual days:

2014-03-11: I can't have any results here, the page didn't exist yet
2014-03-13: result is correct
2014-03-14: result is correct
2014-03-15: result is correct
2014-03-16: result is the exact copy of the 14th, and it is incorrect, we got only 3 visits
2014-03-17: result is the exact copy of the 13th, which is incorrect, we got 16 visits
2014-03-18: result is the exact copy of the 14th, but we got only 9 visitors.

Finally, when I try to make this request on a bigger date range (from 01-01-2014 to 18-03-2014) I got this response:

(extract of the end of the response):

"nb_hits_with_time_generation":135,"min_time_generation":"0.001","max_time_generation":"5.299","entry_nb_uniq_visitors":"9","entry_nb_visits":"9","entry_nb_actions":"50","entry_sum_visit_length":"9530","entry_bounce_count":"6","exit_nb_uniq_visitors":"12","exit_nb_visits":"13","avg_time_on_page":365,"bounce_rate":"67%","exit_rate":"39%","avg_time_generation":0.833,"url":"MQN0+.=G9Q!dX=vN[Vq/~v{)Yuv)7oR}0,z6%AMrk!(-jn/y\V='7
GQhArFIuaPl- 04lG#P(vl?mlDn.rN
dF1eOL4 (Cc04%sh/WzZy%Mc^^I3s8#]ARHG{

I don't know if it's part of the same bug, but I get the same error or kind of pattern described above with all actions.getPageUrl requests.
@tsteur
Copy link
Member

tsteur commented May 14, 2014

Hi pvledoux,

can you still reproduce this issue? I tried to reproduce it many times but couldn't.

In case you can still reproduce it: Is it possible for you to provide as access to your FTP (where your Piwik files are) and access to your Piwik web interface? A user with view permission would be enough. Otherwise I cannot solve this issue.

@pvledoux
Copy link
Author

Hi!

I just upgraded to 2.2.2 and the yes, the problem remains, except that in the case of big date range, I get a clear memory exhausted error:

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 88 bytes) in /var/www/analytics/htdocs/core/Archive/DataTableFactory.php on line 205
{"result":"error","message":"Allowed memory size of 268435456 bytes exhausted (tried to allocate 88 bytes)"}

It's on a production server so it's a bit touchy to give an FTP access to it. How can I PM you?

@mattab
Copy link
Member

mattab commented May 15, 2014

You can email Thomas who is core team member, at thomas att piwik.org

Thanks for your help!

@tsteur
Copy link
Member

tsteur commented Jun 4, 2014

In e57984d: refs #4872 this should fix getPageUrl returns same results for several day when a range is used. Waiting to see which tests fail. In this case date always equaled to "2014-03-11,2014-03-18" for each subtable/day

@pvledoux pvledoux added this to the 2.4.0 - Piwik 2.4.0 milestone Jul 8, 2014
@tsteur tsteur self-assigned this Jul 11, 2014
@tsteur tsteur mentioned this issue Jul 11, 2014
Closed
@snyk-bot snyk-bot mentioned this issue Oct 16, 2022
Open
@sirinartk sirinartk mentioned this issue Oct 17, 2022
Open
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tsteur tsteur

Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
2.4.0
Development

No branches or pull requests
3 participants
@pvledoux @tsteur @mattab