Reports not showing data when setting filters

Product Support
1

Your software
My Mautic version is: v3.3.3
My PHP version is: 7.4.20
My Database type and version is: mysqlnd 7.4.20

Your problem
My problem is: Hi!

I’m basically trying to create reports in Mautic. I want to track the deliverability of the emails I’ve set up under a certan category.

Data source: Emails
Colums: Category ID, Category Name, Name, Sent count, Read count, Read ratio
Filters: Column(Category ID) equals Value(CategoryID), Dynamic=Yes.

I set up the filters correctly but the reports won’t show data. I’ve tried to filter the data by Category ID, Category Name, Email Name (all the emails I want to track contain a common word) but I can’t seem to make it work.

These errors are showing in the log:
[2021-06-17 15:25:52] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjU0Njt9Zjo4OiJmemJ2eSI7djo1Mzk7Zjo3OiJmZ2JnIjtmOjU1OiI5M2RjOTE2MzJiM2Q1MzkzNTkzMDE1IjtmOjc6InlmYmUiO2Y6ODoiMTg3MTciO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjUzOTt9fQ== {“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:546;}f:8:“fzbvy”;v:539;f:7:“fgbg”;f:55:“93dc91632b3d5393593015”;f:7:“yfbe”;f:8:“18717”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:539;}} is not a serialized array at /var/www/vhosts/email.domainhidden.com/httpdocs/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}
[2021-06-17 15:25:52] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjU0Njt9Zjo4OiJmemJ2eSI7djo1Mzk7Zjo3OiJmZ2JnIjtmOjU1OiI5M2RjOTE2MzJiM2Q1MzkzNTkzMDE1IjtmOjc6InlmYmUiO2Y6ODoiMTg3MTciO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjUzOTt9fQ== {“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:546;}f:8:“fzbvy”;v:539;f:7:“fgbg”;f:55:“93dc91632b3d5393593015”;f:7:“yfbe”;f:8:“18717”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:539;}} is not a serialized array at /var/www/vhosts/email.domainhidden.com/httpdocs/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}
[2021-06-17 15:25:53] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjU0Njt9Zjo4OiJmemJ2eSI7djo1Mzk7Zjo3OiJmZ2JnIjtmOjU1OiI5M2RjOTE2MzJiM2Q1MzkzNTkzMDE1IjtmOjc6InlmYmUiO2Y6ODoiMTg3MTciO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjUzOTt9fQ== {“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:546;}f:8:“fzbvy”;v:539;f:7:“fgbg”;f:55:“93dc91632b3d5393593015”;f:7:“yfbe”;f:8:“18717”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:539;}} is not a serialized array at /var/www/vhosts/email.domainhidden.com/httpdocs/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}
[2021-06-17 20:28:28] mautic.NOTICE: Symfony\Component\Console\Exception\RuntimeException: Too many arguments, expected arguments “command”. (uncaught exception) at /var/www/vhosts/email.domainhidden.com/httpdocs/vendor/symfony/console/Input/ArgvInput.php line 188 while running console command mautic:reports:scheduler
[2021-06-17 20:28:28] mautic.WARNING: Command mautic:reports:scheduler exited with status code 1

Steps I have tried to fix the problem:

I’ve also tried:
Filters: Column(Category Name) equals Value(Category Name), Dynamic=Yes.
Filters: Column(Name) contains Value(Common word), Dynamic=Yes.

1
11658×833 59.4 KB

2
21649×712 20.2 KB

If you’d be able to help me, that’d be very much appreciated!

2

Same problem here with 4.1.1

No errors in log file.

Started when updating to 4.1.1

3

Your click through values look strange, it would typically contain email list id, lead id, etc… looking at your data above, you do not have the right keys in the variable (when value is decoded from base64).

I would check what is happening with those values by sending out some test emails (to yourself), then copy links from the email you got, extract ct variables (click through values).

Values are base64 encoded, so to see whats actually inside you will have to decode the value, once you do you (should) get serialized php array.

If you do not find stuff like lead, email, etc. in this array, something is wrong with link generation. And you have another issue.

Reports are not working because current values in serialized arrays have no meaning for mautic report functionality.

Regards, M.