mautic.ERROR: Invalid clickthrough value:

malik · August 27, 2020, 1:07pm

Your software
My PHP version is : php 7.3.20
My MySQL version is 5.7.30-1debian10 (docker image: mysql:5.7)
Mautic: v3.0.2

Errors
After sending a campaign, the email numbers (open, click, etc) are now showing up in the campaign

I can still see the numbers at the email template level but it’s not appearing in the campaign section.

… Invalid clickthrough value …

These errors are showing in the Mautic log :

{“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:47:“dbzcbvta.fifag”;v:4;v:48;}f:8:“fzbvy”;v:47;f:7:“fgbg”;f:55:“8a700b4254fb6275630157”;f:7:“yfbe”;f:6:“728”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:47;}} is not a serialized array at /var/www/html/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}

Any idea?

gary.harrison · September 22, 2020, 3:36am

I’m experiencing the same issue here…

malik · October 9, 2020, 7:31am

Anyone who can help here?

adirbnology · November 29, 2020, 9:33am

same issue here as well . no idea how to trace it

plato39 · April 28, 2021, 12:09pm

I have the same issue. Even with v3.3.2. (I’m not using docker image).

imihandstand · May 8, 2021, 4:46pm

I have the same error. Mautic 3.3.2

[2021-05-08 12:55:28] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjU3MTt9Zjo4OiJmemJ2eSI7djo0MzM7Zjo3OiJmZ2JnIjtmOjU1OiI5MzI5MWI1ZTNhNWEwNjczNDI0MzkyIjtmOjc6InlmYmUiO2Y6ODoiNzU4MjYiO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjQzMzt9fQ== {"exception":"[object] (Mautic\\CoreBundle\\Exception\\InvalidDecodedStringException(code: 0): The string b:8:{f:9:\"fbhedf\";b:5:{v:3;f:47:\"dbzcbvta.fifag\";v:4;v:571;}f:8:\"fzbvy\";v:433;f:7:\"fgbg\";f:55:\"93291b5e3a5a0673424392\";f:7:\"yfbe\";f:8:\"75826\";f:0:\"dubaafy\";b:4:{f:8:\"fzbvy\";v:433;}} is not a serialized array at /mydomain/mautic/mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"} []

plato39 · August 2, 2021, 11:28am

This is still happening. Mautic 3.3.3.

Yosu_Cadilla · February 21, 2023, 7:14am

I can confirm this is still an issue with Mautic 4.4.x

There’s an open issue on Github, please guys go there and report your case if you have a couple minutes to spare…

github.com/mautic/mautic

Clickthrough error - string is not a seriazelized array

opened 11:13AM - 24 Oct 18 UTC

closed 03:50PM - 30 Jul 20 UTC

pety-dc

bug

[//]: # ( Invisible comment: IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII…I Before you create the issue: IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Search for similar report among other reported issues. Learn how to troubleshoot at https://www.mautic.org/docs/en/tips/troubleshooting.html Use drag&drop to attach images or other files ) ## Bug Description After sending emails that contains tracked links I often see such error messages in the log. Not all clicks end up in errors like this. So far I could not figure out what leads to this kind of clickthrough error. Mautic is behind proxy, runs in docker container Locale is set to hungarian UTF-8 | Q | A | --- | --- | Mautic version | 2.14.1 | PHP version | 7.0.28 | Browser | Firefox 62.0.3 ### Steps to reproduce 1. Create segment mail with tracked link 2. Send mail to multiple recipients 3. Wait for incoming clicks ### Log errors `[2018-10-15 14:49:21] mautic.CRITICAL: Uncaught PHP Exception InvalidArgumentException: "The string ,f.&..U"0U{,f....{f. ..{.f.lzfj{z.f0.n...lzfj{f.4W.&..e.u/6t..ug.dd..dg.t.dtW.&..W92,..vz..ddd.dcW.&. zW0.,.a0..dzdg;f...{.f.h= = is not a serialized array." at /var/www/html/app/bundles/CoreBundle/Helper/ClickthroughHelper.php line 42 []` [//]: # ( Invisible comment: Please 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. )

Yosu_Cadilla · March 17, 2023, 1:29pm

Probably related:

github.com/mautic/mautic

Clickthrough error - string is not a seriazelized array

opened 11:13AM - 24 Oct 18 UTC

pety-dc

bug

## Bug Description After sending emails that contains tracked links I often see… such error messages in the log. Not all clicks end up in errors like this. So far I could not figure out what leads to this kind of clickthrough error. Mautic is behind proxy, runs in docker container Locale is set to hungarian UTF-8 | Q | A | --- | --- | Mautic version | 2.14.1 (still an issue on 4.4.x) | PHP version | 7.0.28 | Browser | Firefox 62.0.3 ### Steps to reproduce 1. Create segment mail with tracked link 2. Send mail to multiple recipients 3. Wait for incoming clicks ### Log errors `[2018-10-15 14:49:21] mautic.CRITICAL: Uncaught PHP Exception InvalidArgumentException: "The string ,f.&..U"0U{,f....{f. ..{.f.lzfj{z.f0.n...lzfj{f.4W.&..e.u/6t..ug.dd..dg.t.dtW.&..W92,..vz..ddd.dcW.&. zW0.,.a0..dzdg;f...{.f.h= = is not a serialized array." at /var/www/html/app/bundles/CoreBundle/Helper/ClickthroughHelper.php line 42 []` [//]: # ( Invisible comment: Please 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. )

github.com/mautic/mautic

Campaign: Error with sending scheduled email and with tracking

opened 09:40PM - 12 Nov 20 UTC

danielwpsouza

T2 bug campaigns email

[//]: # ( Invisible comment: IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII…I Before you create the issue: IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Search for similar report among other reported issues. Learn how to troubleshoot at https://www.mautic.org/docs/en/tips/troubleshooting.html Use drag&drop to attach images or other files ) ## Bug Description This bug occurs in campaign events. DOESN'T HAPPEN IN COMMON EVENTS... When creating a campaign that sends an email to the contact, and then tracks the action "Clicked on email", after the contact clicks the link an error in the log appears. Furthermore, Mautic stops recording any more "Contact / lead" tracking. The same email sent outside of a campaign does not generate the error. Also, campaign that contains the email sending rule: "in the relative time period". 1 day between the hours of 08:00 am to 03:00 pm, still sends e-mails after the scheduled time. | Q | A | --- | --- | Mautic version | 3.1.2 | PHP version | 7.3 PHP-FPM | SMTP | SendBlue ### Steps to reproduce 1. Create an email with a LINK. 2. Create a campaign containing: Has valid email address, Visits a page, Add Do Not Contact, Modify contact's segments, Update contact, Change campaigns. 3. Configure email delivery: "in the relative time period". 1 day between the hours of 08:00 am to 03:00 pm ### Tracking error The tracking problem, I see that it is related to devices that have multiple users. 1. Create Two Leads. 2. Send email to the 2. 3. Click the link in the email on one of the Leads and check its history, it is working perfectly. 4. Click the link in the email with the other Lead, now look at the history of the two leads. Traking was not triggered for either lead. ### Log errors [//]: # ( Invisible comment: Please 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. ) mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjQxMDg7fWY6ODoiZnpidnkiO3Y6NDk4O2Y6NzoiZmdiZyI7Zjo1NToiOGFiZGFkZTc1MTg4NTIxNjEzMjgyNiI7Zjo3OiJ5ZmJlIjtmOjk6IjY3ODc0MiI7ZjowOiJkdWJhYWZ5IjtiOjQ6e2Y6ODoiZnpidnkiO3Y6NDk4O319 {"exception":"[object] (Mautic\\CoreBundle\\Exception\\InvalidDecodedStringException(code: 0): The string b:8:{f:9:\"fbhedf\";b:5:{v:3;f:47:\"dbzcbvta.fifag\";v:4;v:4253;}f:8:\"fzbvy\";v:499;f:7:\"fgbg\";f:55:\"8abe41efff8d1525464563\";f:7:\"yfbe\";f:9:\"417552\";f:0:\"dubaafy\";b:4:{f:8:\"fzbvy\";v:499;}} is not a serialized array at /public_html/mkt.comm/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:53)"} [] ![Editar-Campanha-Mautic (1)](https://user-images.githubusercontent.com/72410310/98998660-48272d00-2515-11eb-82b1-9f19e4489923.png) ![image](https://user-images.githubusercontent.com/72410310/98998594-2cbc2200-2515-11eb-9e68-21df98332a6d.png) SendBlue It started before the scheduled time ![image](https://user-images.githubusercontent.com/72410310/98999204-25494880-2516-11eb-8bd4-db120748c109.png) It didn't stop when it should. ![image](https://user-images.githubusercontent.com/72410310/98999093-efa45f80-2515-11eb-9d67-92c950ae836d.png) Using Amazon SES SMTP, Mautic respected the configured shipping times. However, the test was performed in another installation, both on the same server with the same settings. <bountysource-plugin> --- Want to back this issue? **[Post a bounty on it!](https://app.bountysource.com/issues/94211522-campaign-error-with-sending-scheduled-email-and-with-tracking?utm_campaign=plugin&utm_content=tracker%2F5355074&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://app.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F5355074&utm_medium=issues&utm_source=github). </bountysource-plugin>

github.com/mautic/mautic

Fix Invalid clickthrough value exception

mautic:4.0 ← kuzmany:fix-Invalid_clickthrough_value

opened 01:47PM - 16 Sep 21 UTC

kuzmany

+57 -6

| Q | A | --------------------------------…------ | --- | Branch? | "features" for all features, enhancements and bug fixes (until 3.3.0 is released) | Bug fix? | yes/no | New feature? | yes/no | Deprecations? | yes/no | BC breaks? | yes/no | Automated tests included? | yes/no | Related user documentation PR URL | mautic/mautic-documentation#... | Related developer documentation PR URL | mautic/developer-documentation#... | Issue(s) addressed | Fixes #9400   #### Description: This PR fix issue millions logs like: `[2021-09-02 10:28:41] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo4OiJmemJ2eSI7djo0O3Y6NDAyO31mOjg6ImZ6YnZ5Ijt2OjQwMjtmOjc6ImZnYmciO2Y6NTU6Ijk0NjNiNWNjMWRmNzk5MjcwNjI0NDUiO2Y6NzoieWZiZSI7ZjowOiI0OTY1Nzg1IjtmOjA6ImR1YmFhZnkiO2I6NDp7Zjo4OiJmemJ2eSI7djo0MDI7fX0= {"exception":"[object] (Mautic\\CoreBundle\\Exception\\InvalidDecodedStringException(code: 0): The string b:8:{f:9:\"fbhedf\";b:5:{v:3;f:8:\"fzbvy\";v:4;v:402;}f:8:\"fzbvy\";v:402;f:7:\"fgbg\";f:55:\"9463b5cc1df79927062445\";f:7:\"yfbe\";f:0:\"4965785\";f:0:\"dubaafy\";b:4:{f:8:\"fzbvy\";v:402;}} is not a serialized array at..` I collect the requests, and it looks like this kind of requests are from bots (Microsoft....) Then we should skip it.  #### Steps to test this PR: 1. Load up [this PR](https://mautibox.com) 2. Go to your page with tracking code 3. Add to url `?ct=Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo4OiJmemJ2eSI7djo0O3Y6NTM4O31mOjg6ImZ6YnZ5Ijt2OjUzODtmOjc6ImZnYmciO2Y6NTU6Ijk0NzY4Y2I4YmZhMGY4Nzc2NTMzODEiO2Y6NzoieWZiZSI7Zjo5OiI4MjM5OTgiO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjUzODt9fQ` 4. Check your logs and you should see error : `mautic.ERROR: Invalid clickthrough value: ` 5. After PR page you should see not tracked page in the browser console - we asume it's bot ![image](https://user-images.githubusercontent.com/462477/133642035-0df7fb45-59d5-443e-9b21-abb2eb29e04c.png)