Your software
My PHP version is : 7.4.23
My MySQL/MariaDB version is (delete as applicable): MySQL/MariaDB version
Updating/Installing Errors
I am (delete as applicable): Installing / Updating
Upgrading/installing via (delete as applicable) : Web / Command Line
These errors are showing in the installer :
These errors are showing in the Mautic log :
[2021-09-16 16:26:27] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjcyMTt9Zjo4OiJmemJ2eSI7djo4NTtmOjc6ImZnYmciO2Y6NTU6Ijk0NzYwMzRjOWVkODU3Mzc4NTQ2MTYiO2Y6NzoieWZiZSI7Zjo5OiI1NjUxNTUiO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2Ojg1O319 {“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:721;}f:8:“fzbvy”;v:85;f:7:“fgbg”;f:55:“9476034c9ed85737854616”;f:7:“yfbe”;f:9:“565155”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:85;}} is not a serialized array at /var/www/vhosts/posta.thepulso.com/httpdocs/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}
Your problem
My problem is :
I have that error on the Log and how to fix it after updating to 4.0.0
Steps I have tried to fix the problem :
I’ve already cleaned Caché and update the Schema.
Here is a PR which should address that issue:
mautic:4.0
← kuzmany:fix-Invalid_clickthrough_value
opened 01:47PM - 16 Sep 21 UTC
| 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 #...
<!--
Additionally (see https://contribute.mautic.org/contributing-to-mautic/developer/code/pull-requests#step-5-work-on-your-pull-request):
- Always add tests and ensure they pass.
- Bug fixes must be submitted against the lowest maintained branch where they apply
(lowest branches are regularly merged to upper ones so they get the fixes too.)
- Features and deprecations must be submitted against the "features" branch.
-->
<!--
Please write a short README for your feature/bugfix. This will help people understand your PR and what it aims to do.
-->
#### 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.
<!--
If you are fixing a bug and if there is no linked issue already, please provide steps to reproduce the issue here.
-->
#### 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)
<!--
If you have any deprecations, list them here along with the new alternative.
If you have any backwards compatibility breaks, list them here.
-->
Please test and if it fixes the issue, leave a comment on the pull request!
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…
opened 11:13AM - 24 Oct 18 UTC
closed 03:50PM - 30 Jul 20 UTC
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. )