[PHP8] SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'url' at row 1

[anasmoiz]

Hello,

When we are running the script with PHP 8.0 and we receive the following error.

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'url' at row 1

If we downgrade the version to PHP 7.3 or 7.4, it works perfectly I can see this issue was previously reported #354 as well but was closed without providing an actual solution.

Please note that this is not happening with every site hosted on PHP 8.0 but with a few. if you guys need any details or access to replicate this please let us know, we would really like to solve this issue with your team.

[smissaertj]

I can confirm the above.

How did you deal with this @anasmoiz ? Did you find a workaround of any kind?

[alex-umani]

It's not a solution, but I found a bit of a workaround. The problem is that in PHP 8, the PDO class switched from defaulting in SILENT mode to defaulting to EXCEPTION mode (https://php.watch/versions/8.0/PDO-default-errmode)

It doesn't solve the underlying problem (you are trying to insert invalid data to the database), but you can get it to ignore the errors and continue if you add the following line to srdb.class.php:

$params[ PDO::ATTR_ERRMODE ] = PDO::ERRMODE_SILENT;

Insert that around line 558, right before they explicitly set ERRMODE to EXCEPTION when the code is running in debug mode.

It's gotten the code running for me again. Hope it helps.