Hello friends,
after last update PHP v7.4.11
when I finish order by press payment button I receive error:

Incorrect string value: '\xD1' for column 'ordAuthNumber' at row 1
Cannot find details for order id: 7848
after that status of order is Unknown

What I have to do to correct this error?


Kislev Andrey

Hi Andrey
Is it possible that you changed the name for the payment provider to one which has non-ASCII characters? Could you, as a test, try changing it to something with just standard ASCII chars and see if the error goes away, and if ti does then we know what to look at.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

When I have changed description of payment provider to English language the problem is resolved, but I still want to put description in any language.
Do you have idea to do that?

Kislev Andrey

Which payment provider are you using?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Email

Kislev Andrey

Hi Andrey
I think this is really down to the database character set and the cart is trying to set the authorization code of the order to the text that is used for the Email Payment method. Thinking about it, it is probably better to have something generic there so I'm going to change this in the cart to just "Email Order". To save updating, if you open incthanks.php in notepad and search for...

escape_string(mb_substr($authnumber,0,48))

...and change that to...

escape_string('Email Order')

...then it should fix this.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater