Contact randomly overwritten

Your software
My Mautic version is: v4.4.0
My PHP version is: 7.4.30
My Database type and version is: mysqlnd 7.4.30

Your problem
My problem is:
I work a lot with contact forms that create contacts. During the last month i repeatedly noticed, that when a new contact submits a form, mautic does not create a new contact but updates a seemingly random existing contact. there is absolutley no connection between these contacts.
firstname, lastname, email get overwritten. This can clearly be seen in the Audit Log (see screenshots). The values are completely different here.

I did a lot of testing and I know this is happening, if someone submits a form repeatedly with different email addresses but the same cookie (or maybe even from the same IP address?) - Which is OK i guess, but the contacts where this is happening are completely unrelated with each other.

Is there any logical explanation why this might happen? Might there be some kind of Bug that makes wrong connections between cookies/devices/ip-addresses? There is one strange error in the log (first line), which might point to the same IP address being used by another contact? Is there a way to deactivate this behavior?


These errors are showing in the log:

[2022-06-26 10:42:08] mautic.WARNING: The reference for contact 30743 and IP address 72946 is already there. (Unique constraint)
[2022-06-26 12:16:49] mautic.ERROR: Invalid clickthrough value: Yjo3OntmOjk6ImZiaGVkZiI7YjozOnt9Zjo4OiJmemJ2eSI7QTtmOjc6ImZnYmciO0E7Zjo3OiJ5ZmJlIjtmOjg6Ijc5MzQ2Ijt9 {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:7:{f:9:"fbhedf";b:3:{}f:8:"fzbvy";A;f:7:"fgbg";A;f:7:"yfbe";f:8:"79346";} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}
[2022-06-26 12:16:49] mautic.ERROR: Invalid clickthrough value: Yjo3OntmOjk6ImZiaGVkZiI7YjozOnt9Zjo4OiJmemJ2eSI7QTtmOjc6ImZnYmciO0E7Zjo3OiJ5ZmJlIjtmOjg6Ijc5MzQ2Ijt9 {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:7:{f:9:"fbhedf";b:3:{}f:8:"fzbvy";A;f:7:"fgbg";A;f:7:"yfbe";f:8:"79346";} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}
[2022-06-26 12:16:49] mautic.ERROR: Invalid clickthrough value: Yjo3OntmOjk6ImZiaGVkZiI7YjozOnt9Zjo4OiJmemJ2eSI7QTtmOjc6ImZnYmciO0E7Zjo3OiJ5ZmJlIjtmOjg6Ijc5MzQ2Ijt9 {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:7:{f:9:"fbhedf";b:3:{}f:8:"fzbvy";A;f:7:"fgbg";A;f:7:"yfbe";f:8:"79346";} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}
[2022-06-26 12:16:49] mautic.ERROR: Invalid clickthrough value: Yjo3OntmOjk6ImZiaGVkZiI7YjozOnt9Zjo4OiJmemJ2eSI7QTtmOjc6ImZnYmciO0E7Zjo3OiJ5ZmJlIjtmOjg6Ijc5MzQ2Ijt9 {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:7:{f:9:"fbhedf";b:3:{}f:8:"fzbvy";A;f:7:"fgbg";A;f:7:"yfbe";f:8:"79346";} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}
[2022-06-26 12:16:49] mautic.ERROR: Invalid clickthrough value: Yjo3OntmOjk6ImZiaGVkZiI7YjozOnt9Zjo4OiJmemJ2eSI7QTtmOjc6ImZnYmciO0E7Zjo3OiJ5ZmJlIjtmOjg6Ijc5MzQ2Ijt9 {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:7:{f:9:"fbhedf";b:3:{}f:8:"fzbvy";A;f:7:"fgbg";A;f:7:"yfbe";f:8:"79346";} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}
[2022-06-26 14:24:23] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo2OiJiY3YiO3Y6NDt2OjM7fWY6ODoiZnpidnkiO3Y6OTtmOjc6ImZnYmciO2Y6NTU6Ijk1YzE5Y2EwZWI4YzAwNjQxMTU2NjgiO2Y6NzoieWZiZSI7Zjo4OiI3OTM0NiI7ZjowOiJkdWJhYWZ5IjtiOjQ6e2Y6ODoiZnpidnkiO3Y6OTt9fQ== {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:"fbhedf";b:5:{v:3;f:6:"bcv";v:4;v:3;}f:8:"fzbvy";v:9;f:7:"fgbg";f:55:"95c19ca0eb8c0064115668";f:7:"yfbe";f:8:"79346";f:0:"dubaafy";b:4:{f:8:"fzbvy";v:9;}} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}
[2022-06-26 14:24:23] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo2OiJiY3YiO3Y6NDt2OjM7fWY6ODoiZnpidnkiO3Y6OTtmOjc6ImZnYmciO2Y6NTU6Ijk1YzE5Y2EwZWI4YzAwNjQxMTU2NjgiO2Y6NzoieWZiZSI7Zjo4OiI3OTM0NiI7ZjowOiJkdWJhYWZ5IjtiOjQ6e2Y6ODoiZnpidnkiO3Y6OTt9fQ== {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:"fbhedf";b:5:{v:3;f:6:"bcv";v:4;v:3;}f:8:"fzbvy";v:9;f:7:"fgbg";f:55:"95c19ca0eb8c0064115668";f:7:"yfbe";f:8:"79346";f:0:"dubaafy";b:4:{f:8:"fzbvy";v:9;}} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}
[2022-06-26 14:24:23] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo2OiJiY3YiO3Y6NDt2OjM7fWY6ODoiZnpidnkiO3Y6OTtmOjc6ImZnYmciO2Y6NTU6Ijk1YzE5Y2EwZWI4YzAwNjQxMTU2NjgiO2Y6NzoieWZiZSI7Zjo4OiI3OTM0NiI7ZjowOiJkdWJhYWZ5IjtiOjQ6e2Y6ODoiZnpidnkiO3Y6OTt9fQ== {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:"fbhedf";b:5:{v:3;f:6:"bcv";v:4;v:3;}f:8:"fzbvy";v:9;f:7:"fgbg";f:55:"95c19ca0eb8c0064115668";f:7:"yfbe";f:8:"79346";f:0:"dubaafy";b:4:{f:8:"fzbvy";v:9;}} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}
[2022-06-26 14:24:23] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo2OiJiY3YiO3Y6NDt2OjM7fWY6ODoiZnpidnkiO3Y6OTtmOjc6ImZnYmciO2Y6NTU6Ijk1YzE5Y2EwZWI4YzAwNjQxMTU2NjgiO2Y6NzoieWZiZSI7Zjo4OiI3OTM0NiI7ZjowOiJkdWJhYWZ5IjtiOjQ6e2Y6ODoiZnpidnkiO3Y6OTt9fQ== {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:"fbhedf";b:5:{v:3;f:6:"bcv";v:4;v:3;}f:8:"fzbvy";v:9;f:7:"fgbg";f:55:"95c19ca0eb8c0064115668";f:7:"yfbe";f:8:"79346";f:0:"dubaafy";b:4:{f:8:"fzbvy";v:9;}} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}
[2022-06-26 14:24:23] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo2OiJiY3YiO3Y6NDt2OjM7fWY6ODoiZnpidnkiO3Y6OTtmOjc6ImZnYmciO2Y6NTU6Ijk1YzE5Y2EwZWI4YzAwNjQxMTU2NjgiO2Y6NzoieWZiZSI7Zjo4OiI3OTM0NiI7ZjowOiJkdWJhYWZ5IjtiOjQ6e2Y6ODoiZnpidnkiO3Y6OTt9fQ== {“exception”:“[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:"fbhedf";b:5:{v:3;f:6:"bcv";v:4;v:3;}f:8:"fzbvy";v:9;f:7:"fgbg";f:55:"95c19ca0eb8c0064115668";f:7:"yfbe";f:8:"79346";f:0:"dubaafy";b:4:{f:8:"fzbvy";v:9;}} is not a serialized array at //mautic/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)”}

Steps I have tried to fix the problem:
I originally had the email field set to “public editable” - I deactivated that but it still happens

Thank you in advance :slight_smile:

Alright, after a lot of digging I figured it out myself:

This problem occurs if you anonymize IP-Addresses, which seems mandatory in the EU. Because of the anonymization a lot of IP addresses look the same and the contacts get merged. So you can either:

This Thread helped me out: