Page 1 of 1
States at Admin account edit problem
Posted: Thu Jul 01, 2021 9:58 pm
by Owl
Greetings,
Phoenix 1.0.8.0 @ PHP 7.1, 7.4
When editing a costumers account in Admin and selecting a state from the dropdown menu it does not get saved. Anyone else facing this problem? IT does not create any error log entry nor gives any kind of PHP notice/warning.
Best Regards,
Re: States at Admin account edit problem
Posted: Sat Jul 03, 2021 10:12 am
by Omar_one
Re: States at Admin account edit problem
Posted: Sun Jul 04, 2021 9:13 am
by Owl
Well, it didnt fixed the problem but found what the problem is. It is a problem with states having special characters like accents and such. Any ideas how to fix this?
Re: States at Admin account edit problem
Posted: Sun Jul 04, 2021 9:49 am
by raiwa
Check that your encoding is set to utf8 in the database field.
A workaround is also to use html entities for the special characters.
Re: States at Admin account edit problem
Posted: Mon Jul 05, 2021 2:01 pm
by Owl
raiwa wrote: ↑Sun Jul 04, 2021 9:49 am
Check that your encoding is set to utf8 in the database field.
A workaround is also to use html entities for the special characters.
db is set to utf8_unicode_ci but also tried to set it up to utf8mb4_unicode_ci with no luck. What workaround are you sugesting?
Re: States at Admin account edit problem
Posted: Mon Jul 05, 2021 2:21 pm
by raiwa
raiwa wrote: ↑Sun Jul 04, 2021 9:49 am
A workaround is also to use
html entities for the special characters.
Re: States at Admin account edit problem
Posted: Mon Jul 05, 2021 9:38 pm
by Owl
Its even weirder.
It only gives the problem with foreign countries with special characters like "Cádiz" in Spain. Other Spanish countries, i.e., does not gives any problem. Default coutry states with or without the special chars works perfectly.