exxos's Atari, Amiga & retro forum

Hi,

After entering the shipping information I get the following text on an empty page

Error : (1366) Incorrect string value: '\xE2\x80\xAC

I tried entering it various times but always get the same error and I've tried being logged in and also not logged in.

Regards

@exxos ?

AlgAtari wrote: 14 Nov 2024 22:00 After entering the shipping information I get the following text on an empty page

Error : (1366) Incorrect string value: '\xE2\x80\xAC

I tried entering it various times but always get the same error and I've tried being logged in and also not logged in.

That is odd. Can you PM me some screenshots of what you are entering and what the error page has (with URL) .

Does this happen before or after clicking the checkout button (which directs you to stripe) ?

The store doesn't normally error to a different page (first I ever heard of that) the store JS checks for known errors and reports above the checkout button of any detected errors.

If you know your IP address it will help trace you in the logs.

If I can replicate what you are doing exactly (as much info as possible helps) and I can replicate it here, then I can normally trace errors pretty quick and fix them. Though as its 11pm now, I won't be able to look at it until tomorrow.

According to GPT4

The PHP error (1366) Incorrect string value: '\xE2\x80\xAC' is a MySQL error code indicating an incorrect string value. This occurs when you're attempting to insert or update data containing characters that cannot be represented in the target column's character set.

The specific sequence \xE2\x80\xAC corresponds to the Unicode Right-to-Left Override (RLO) character (U+202E), which is a control character used for changing the text direction in bidirectional text. This character often appears in data copy-pasted from certain sources or in text that has been tampered with.

So I believe it was copy and pasting address information which was somehow also including a control character which was not correctly handled by the store scripts :roll:

The front-end and back-end scripts have been updated to avoid similar problems in the future. If there are invalid characters then that box will be highlighted in red as an error as the store would normally do anyway. However, if the text looks correct and shows up an error then I suggest manually typing in the problem fields to make sure "hidden characters" are not copied over.

Thanks for the poke @rubber_jonnie , I've not had time lately to even look at anything on the forum.

exxos wrote: 15 Nov 2024 11:38 Thanks for the poke @rubber_jonnie , I've not had time lately to even look at anything on the forum.

You're welcome :)