special characters in extra fields : help needed

[frommarcq +]

Hi,
I'm with v4.0.8 developper version, and using 68classifieds in french language.
Some extra fields (stored in 'optValue') are containing some signs which are causing some troubles (eg. '�', '�'...).
When s/he add or modify an ad, if a member chooses in a list an option containing one of these characters, the 'sValue' created will be empty.
How could I fix this problem ?
Thanks for your help !
Regards
Pascal

[Eric Barnes +]

Hi Pascal,

Can you give me an example so I can test locally?

Maybe include the extra field type and value entered.

[frommarcq +]

Hi Eric,
Before you have to change of language file (from UTF-8 tuo iso-8859-1)
Juste create an extra-field "test", and propose 3 choices (checkbox) :
- without accent
- with acc�nt
- with accént
With my configuration, if I only choose the first one, no problem. But if I choose the second and/or the third, the extra field will be displayed, but without any option...
Can you duplicate that ?
Thanks a lot !
Regards
Pascal

[Eric Barnes +]

Is this in v4.0.8 or the v3.1 line?

[frommarcq +]

it is v4.0.8 developper version.

[philoo +]

Pascal,

as-tu bascul� les templates de l'Admin en 'charset=ISO-8859-1' ?
Si ce n'est pas le cas, le navigateur ne renvoie correctement pas au serveur les caract�res accentu�s que tu as saisis dans tes champs-extra, et par cons�quent il ne les �crit pas correctement dans la babase ...

=========================

Pascal,

Did you turn your admin templates with the correct 'charset=ISO-8859-1' ?
If not, the navigator will not send correct characters with accents your wrote in your extra-fields to the server that will be unable to write them correctely in database ..

[Eric Barnes +]

Hi,

Can you open the includes/classes/kernel/Listings.php and go to line 1811 which should have this:

PHP Code:

'value'=> html_entity_decode($rs['sValue']), 


Try to replace it with:

PHP Code:

'value'=> $rs['sValue'], 


[frommarcq +]

Sorry, but it didn't work.

I think I've fixed that problem (using your suggestion) changing this code twice in Listings.php :

$objValue = htmlentities($objValue, ENT_QUOTES, 'UTF-8');

with

$objValue = htmlspecialchars($objValue, ENT_QUOTES, 'iso-8859-1');

I hope I don't have created a vunerability...

Pascal

[frommarcq +]

Philoo,
Thanks for your answer.
The problem was that I upgraded from v3 to v4, because the 'old' fields were causing troubles (before it accepts french characters).
I've changed the charset. I think that if you use a fresh install, you won't have any trouble. But I can't manually change all the fields used before the upgrade.
Regards
Pascal

Philoo,
Merci de ta r�ponse.
Le probl�me vient surtout de la migration de la v3 vers la v4, car les "anciens" champs posaient souci (auparavant, les accents �taient accept�s).
J'ai bien chang� le Charset. Je pense que si tu utilises une installation neuve (sans migration), �a ne doit poser aucun souci. Mais je ne pouvais modifier manuellement la totalit� des anciens champs enregistr�s avant la mise � jour.
Cordialement,
Pascal

[Eric Barnes +]

Good point Pascal. In v4 install we set all the database tables and values to UTF-8. So that could be it.