[PHP8] SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'url' at row 1 about search-replace-db HOT 2 OPEN

I can confirm the above.

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

from search-replace-db.

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.

from search-replace-db.