{"action":"created","issue":{"url":"https://api.github.com/repos/mautic/mautic/issues/6874","repository_url":"https://api.github.com/repos/mautic/mautic","labels_url":"https://api.github.com/repos/mautic/mautic/issues/6874/labels{/name}","comments_url":"https://api.github.com/repos/mautic/mautic/issues/6874/comments","events_url":"https://api.github.com/repos/mautic/mautic/issues/6874/events","html_url":"https://github.com/mautic/mautic/issues/6874","id":380171055,"node_id":"MDU6SXNzdWUzODAxNzEwNTU=","number":6874,"title":"RabbitMQ Click Counts Not Working","user":{"login":"mtasuandi","id":2455314,"node_id":"MDQ6VXNlcjI0NTUzMTQ=","avatar_url":"https://avatars3.githubusercontent.com/u/2455314?v=4","gravatar_id":"","url":"https://api.github.com/users/mtasuandi","html_url":"https://github.com/mtasuandi","followers_url":"https://api.github.com/users/mtasuandi/followers","following_url":"https://api.github.com/users/mtasuandi/following{/other_user}","gists_url":"https://api.github.com/users/mtasuandi/gists{/gist_id}","starred_url":"https://api.github.com/users/mtasuandi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtasuandi/subscriptions","organizations_url":"https://api.github.com/users/mtasuandi/orgs","repos_url":"https://api.github.com/users/mtasuandi/repos","events_url":"https://api.github.com/users/mtasuandi/events{/privacy}","received_events_url":"https://api.github.com/users/mtasuandi/received_events","type":"User","site_admin":false},"labels":[{"id":154414515,"node_id":"MDU6TGFiZWwxNTQ0MTQ1MTU=","url":"https://api.github.com/repos/mautic/mautic/labels/Bug","name":"Bug","color":"e11d21","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-11-13T11:03:04Z","updated_at":"2018-11-14T16:09:08Z","closed_at":null,"author_association":"NONE","body":"[//]: # ( Invisible comment: \r\nIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII\r\nBefore you create the issue:\r\nIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII\r\nSearch for similar report among other reported issues.\r\nLearn how to troubleshoot at https://www.mautic.org/docs/en/tips/troubleshooting.html\r\nUse drag&drop to attach images or other files )\r\n\r\n## Bug Description\r\nHi!\r\n\r\nI use RabbitMQ on the queue protocol, and I use the one provided by cloudamqp.com for testing. I also run these command:\r\n\r\n* php app/console mautic:queue:process -e prod -i page_hit\r\n* php app/console mautic:queue:process -e prod -i email_hit\r\n\r\nThe email read counts work perfectly but the click counts is not tracked if I look at the data on the Email Segment Dashboard (https://site.co/s/emails/view/1). No matter how many times I clicked the link when I open the email, the click counts will always zero.\r\n\r\nBut the weird part is, if I look the history of my account (https://site.co/s/contacts/view/1), I can see some record if I clicked the link already.\r\n\r\nWhen I look at the database, if I disabled the queue protocol, on table page_hits, the redirect_id is NOT NULL. But if I use RabbitMQ, the redirect_id will always NULL.\r\n\r\nI'm using incognito mode when opening the email and clicking the link, I also try to use different browser and ask my friend to check on her side, but still, the click counts only increased if I disabled the queue protocol.\r\n\r\nI see quite similar issue #6718 but it didn't mention RabbitMQ.\r\n\r\nSo, to make it clear, the click counts was recorded on contact history (https://site.co/s/contacts/view/1), but its not increased on the email segment dashboard (https://site.co/s/emails/view/1).\r\n\r\n| Q   | A\r\n| --- | ---\r\n| Mautic version | 2.14.2\r\n| PHP version | PHP 7.1.24\r\n| Browser | Google Chrome\r\n\r\n### Steps to reproduce\r\n1. Create New Email Segment\r\n2. Send Email\r\n3. Open Email\r\n4. Click Link\r\n \r\n### Log errors\r\nNo error log.\r\n\r\n[//]: # ( Invisible comment:\r\nPlease check for related errors in the latest log file in [mautic root]/app/log/ and/or the web server's logs and post them here. Be sure to remove sensitive information if applicable. )\r\n"},"comment":{"url":"https://api.github.com/repos/mautic/mautic/issues/comments/438718310","html_url":"https://github.com/mautic/mautic/issues/6874#issuecomment-438718310","issue_url":"https://api.github.com/repos/mautic/mautic/issues/6874","id":438718310,"node_id":"MDEyOklzc3VlQ29tbWVudDQzODcxODMxMA==","user":{"login":"mtasuandi","id":2455314,"node_id":"MDQ6VXNlcjI0NTUzMTQ=","avatar_url":"https://avatars3.githubusercontent.com/u/2455314?v=4","gravatar_id":"","url":"https://api.github.com/users/mtasuandi","html_url":"https://github.com/mtasuandi","followers_url":"https://api.github.com/users/mtasuandi/followers","following_url":"https://api.github.com/users/mtasuandi/following{/other_user}","gists_url":"https://api.github.com/users/mtasuandi/gists{/gist_id}","starred_url":"https://api.github.com/users/mtasuandi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtasuandi/subscriptions","organizations_url":"https://api.github.com/users/mtasuandi/orgs","repos_url":"https://api.github.com/users/mtasuandi/repos","events_url":"https://api.github.com/users/mtasuandi/events{/privacy}","received_events_url":"https://api.github.com/users/mtasuandi/received_events","type":"User","site_admin":false},"created_at":"2018-11-14T16:09:08Z","updated_at":"2018-11-14T16:09:08Z","author_association":"NONE","body":"Update:\r\n\r\nThis code:\r\n\r\n`$pageRepo               = $this->em->getRepository('MauticPageBundle:Page');`\r\n`$pageRepo->find((int) $pageId)`\r\n\r\nat `app/bundles/PageBundle/EventListener/PageSubscriber.php` (line 192 & 195, staging branch) return null if I use Message Queue. I have no idea why.\r\n\r\nThe `$pageId` has a value."}}
{"actor":{"display_login":"mtasuandi"}}