{"action":"closed","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/6436","labels_url":"https://api.github.com/repos/piwik/piwik/issues/6436/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/6436/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/6436/events","html_url":"https://github.com/piwik/piwik/issues/6436","id":45647197,"number":6436,"title":"duplicate entries in piwik_log_action leading to pages not visible in segments","user":{"login":"voidswitch","id":8788294,"avatar_url":"https://avatars.githubusercontent.com/u/8788294?v=3","gravatar_id":"","url":"https://api.github.com/users/voidswitch","html_url":"https://github.com/voidswitch","followers_url":"https://api.github.com/users/voidswitch/followers","following_url":"https://api.github.com/users/voidswitch/following{/other_user}","gists_url":"https://api.github.com/users/voidswitch/gists{/gist_id}","starred_url":"https://api.github.com/users/voidswitch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/voidswitch/subscriptions","organizations_url":"https://api.github.com/users/voidswitch/orgs","repos_url":"https://api.github.com/users/voidswitch/repos","events_url":"https://api.github.com/users/voidswitch/events{/privacy}","received_events_url":"https://api.github.com/users/voidswitch/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/piwik/piwik/labels/Bug","name":"Bug","color":"fc2929"},{"url":"https://api.github.com/repos/piwik/piwik/labels/Major","name":"Major","color":"eb6420"}],"state":"closed","locked":false,"assignee":{"login":"diosmosis","id":125140,"avatar_url":"https://avatars.githubusercontent.com/u/125140?v=3","gravatar_id":"","url":"https://api.github.com/users/diosmosis","html_url":"https://github.com/diosmosis","followers_url":"https://api.github.com/users/diosmosis/followers","following_url":"https://api.github.com/users/diosmosis/following{/other_user}","gists_url":"https://api.github.com/users/diosmosis/gists{/gist_id}","starred_url":"https://api.github.com/users/diosmosis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/diosmosis/subscriptions","organizations_url":"https://api.github.com/users/diosmosis/orgs","repos_url":"https://api.github.com/users/diosmosis/repos","events_url":"https://api.github.com/users/diosmosis/events{/privacy}","received_events_url":"https://api.github.com/users/diosmosis/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/piwik/piwik/milestones/72","labels_url":"https://api.github.com/repos/piwik/piwik/milestones/72/labels","id":850567,"number":72,"title":"Piwik 2.11.0","description":"Pool of tickets we pick issues to work on. This release may include DB schema upgrades.\r\n","creator":{"login":"mattab","id":466765,"avatar_url":"https://avatars.githubusercontent.com/u/466765?v=3","gravatar_id":"","url":"https://api.github.com/users/mattab","html_url":"https://github.com/mattab","followers_url":"https://api.github.com/users/mattab/followers","following_url":"https://api.github.com/users/mattab/following{/other_user}","gists_url":"https://api.github.com/users/mattab/gists{/gist_id}","starred_url":"https://api.github.com/users/mattab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattab/subscriptions","organizations_url":"https://api.github.com/users/mattab/orgs","repos_url":"https://api.github.com/users/mattab/repos","events_url":"https://api.github.com/users/mattab/events{/privacy}","received_events_url":"https://api.github.com/users/mattab/received_events","type":"User","site_admin":false},"open_issues":17,"closed_issues":114,"state":"open","created_at":"2014-11-03T02:42:12Z","updated_at":"2015-02-09T04:01:36Z","due_on":"2015-02-11T11:00:00Z","closed_at":null},"comments":8,"created_at":"2014-10-13T14:20:45Z","updated_at":"2015-02-09T04:01:36Z","closed_at":"2015-02-09T04:01:36Z","body":"Hi,\r\n\r\ncurrently we encountered a strange issue with pages listed in *actions->pages*, but not if using a segment (which should include this page). Investigating the issue I found duplicate entries in piwik_log_action.\r\n\r\nidaction | name | hash | type | url_prefix\r\n---------- | -------- | --------- | -------- | --------\r\n4114714 | example.com/somepage | 652463546 | 1 | 1\r\n4114715 | example.com/somepage | 652463546 | 1 | 1\r\n\r\nIn piwik_log_link_visit_action only *idaction 4114715* is referenced, and displayed with views in *actions->pages*; creating a segment matching *example.com/somepage* gets 0 views for this page.\r\n\r\nSomething to consider is that, we use 2 balanced Piwik installations for tracking, a setup which should be working fine, but also has the potential to create this kind of issue as *type, hash* is not unique. \r\n\r\n"}}