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

Question

Basilakis opened this issue 4 years ago · 12 comments

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.

Answer 1 · 2021-03-09T05:53:08.000Z

Answer 2 · 2021-03-09T08:09:36.000Z

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

Answer 3 · 2021-03-09T08:10:59.000Z

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

Answer 4 · 2021-03-09T08:13:33.000Z

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!

Answer 5 · 2021-03-11T06:24:11.000Z

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

Answer 6 · 2021-03-22T10:33:06.000Z

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

Answer 7 · 2021-03-22T11:41:37.000Z

hello, unfortunately I didn't :(

Answer 8 · 2021-05-03T09:45:00.000Z

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?

Answer 9 · 2021-05-03T09:56:24.000Z

Hi,

No seems to not working with PHP 8 at all

Answer 10 · 2021-05-03T11:00:13.000Z

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

Answer 11 · 2021-05-03T11:17:50.000Z

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

Answer 12 · 2021-05-03T11:29:20.000Z

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