Problem with ipv6 addresses
Permalink Browser Info Environment
Hi, look at this errror:
Exception Occurred: [...]/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115 An exception occurred while executing 'INSERT INTO FormidableAnswerSets (formID, userID, collectionID, browser, platform, resolution, submitted, locale, ip, temp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["43", 0, 587, "Google Chrome 119.0.0.0", "Windows 10", "1280x1024", "2023-12-08 17:56:35", "pl_PL", "2a02:a31a:a045:c800:a028:675f:1f96:303d, 2a02:a31a:a045:c800:a028:675f:1f96:303d", 0]:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'ip' at row 1 (0)
An "ip" column needs to be extended, to handle ipv6 addresses in some cases. Currently it is varchar(50).
Exception Occurred: [...]/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115 An exception occurred while executing 'INSERT INTO FormidableAnswerSets (formID, userID, collectionID, browser, platform, resolution, submitted, locale, ip, temp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["43", 0, 587, "Google Chrome 119.0.0.0", "Windows 10", "1280x1024", "2023-12-08 17:56:35", "pl_PL", "2a02:a31a:a045:c800:a028:675f:1f96:303d, 2a02:a31a:a045:c800:a028:675f:1f96:303d", 0]:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'ip' at row 1 (0)
An "ip" column needs to be extended, to handle ipv6 addresses in some cases. Currently it is varchar(50).
| Type: | Ticket |
|---|---|
| Status: | In Progress |
Seems you IP-address is a string of your IP-address twice combined by a comma.
That's not good...
To create a quick fix, I think you need to check the "GDPR"-funtionality and then skip the IP-address. That way it won;t be saved in the results database.
Why your IP-address is a double IP is unknown to me.