Incorrect string value: '\xD1' for column 'ordAuth

Author	« Topic »
Andrey9 New Member Israel 98 Posts	Posted - 01/24/2023 : 06:59:01 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
Vince Administrator 42944 Posts	Posted - 01/24/2023 : 07:36:09 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
Andrey9 New Member Israel 98 Posts	Posted - 01/24/2023 : 08:21:16 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
Vince Administrator 42944 Posts	Posted - 01/24/2023 : 08:33:22 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
Andrey9 New Member Israel 98 Posts	Posted - 01/24/2023 : 08:41:34 Email Kislev Andrey
Vince Administrator 42944 Posts	Posted - 01/27/2023 : 03:16:21 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
	« Topic »