interconnectit / Search-Replace-DB

This script was made to aid the process of migrating PHP and MySQL based websites. Works with most common CMSes.
https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
GNU General Public License v3.0
3.99k stars 850 forks source link

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

Closed Basilakis closed 3 years ago

Basilakis commented 3 years ago

Hello,

We are running this with PHP8 and we receive some errors.

Does the script have php8 compatibility?

Thank you for the reply, much appreciated.

Basilakis commented 3 years ago

@gianluigi-icit any help please? @jack-interconnectit ?

gianluigi-icit commented 3 years ago

well, dear @Basilakis , could you please post the errors you get instead of tag us? :smile_cat:

Basilakis commented 3 years ago

@gianluigi-icit ofc I can! :)

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

and when I downgraded from PHP 8 down to php7.4 it worked

gianluigi-icit commented 3 years ago

thank you, I changed the title :)

I'll take a look when I have a bit of time, unfortunately we are not working on this tool full time!

Basilakis commented 3 years ago

@gianluigi-icit Hey! Did you have had the chance to take a look?

Basilakis commented 3 years ago

@gianluigi-icit Hey! Did you have had the chance to take a look?

gianluigi-icit commented 3 years ago

hello, unfortunately I didn't :(

gianluigi-icit commented 3 years ago

Hello, I had time to check the minimum PHP version for this script to run and it's 5.6.16RC1

I googled your error message and seems related to some mysql configuration, downgrading php might changed something on your setup.

Did you fix it eventually?

Basilakis commented 3 years ago

Hi,

No seems to not working with PHP 8 at all

gianluigi-icit commented 3 years ago

I setup a php8 environment and ran the script without any problem, have you check your mysql?

Basilakis commented 3 years ago

Yeap, I did. Happen to more than 120 WordPress applications ( running it on hosting level ).

gianluigi-icit commented 3 years ago

I am sorry, you should raise the problem to your hosting, I have to close this issue.