Hall of Fame

[grantj21]

Languages management system not working what are you doing about this issue as I'm not the only one with the same issue here using 3.4 is there a fix? is it a database issue what? Please advice.

The issue, the database is not save the information for the translation.

[PHPVibe A.]

Hi, a solution for thouse who cannot serialize large strings has been shared and also updated for upcomming release http://www.phprevolution.com/forum/code/translation-issue/msg12773/#msg12773

[grantj21]

That worked just fine again great advice your the man

[PHPVibe A.]

No worries, it's my job.

[grantj21]

OK got that working how but there is an issue with the character-set this looks like this Déconnexion but it comes out like this Du00e9connexion any fix?

[PHPVibe A.]

Where? You need to be specific about where it happens.

[grantj21]

How clear can I be the translation isn't working right for any language when it comes to using the right character as I send the French word for logout is déconnexion what my website is showing is this Du00e9connexion as you can see the é is now u00e9 my database is using CHARACTER SET utf8.

This is how you have set-up the database I didn't write this script and its not my server as my other website have no issues with translating see this link http://www.zulubee.co.uk go to the bottom of the page and change the language to French and see for yourself that it working on my server.

[PHPVibe A.]

Ok, relax, nobody blamed your server but we're not french.

lib/functions.php

find:

Code Select Expand

return $trans[$txt];

replace it with:

Code Select Expand

return _html($trans[$txt]);

let me know if it's ok now.

[grantj21]

That's a No it didn't work, I'm not French and I don't speak it.

[PHPVibe A.]

Not sure, I've tested on my installs and all seems ok.
Can you check if the table is actually utf8 like in attached screen.

[grantj21]

Right I put a word into the database Table: vibe_languages  French Déconnexion and it reads Déconnexion on the site and admin, However I put the same word in the admin end and save and come out like this Du00e9connexion so the database is fine its the page that sends/saves the information to the database it has no issue with reading it. Hope you understand that.

[grantj21]

My database is the same as yours word for word see image when enter directly into the database

[PHPVibe A.]

Ok, will ask Mario to look into it for this upgrade.
I've tested on mine creating a french language, and I had no problems, but we'll look into it.

Have you applied Mario's mod for json storing of languages or your are still on default serialize method?

[grantj21]

Yes I'm using the updated mod as it wasn't working all to start with.

[PHPVibe A.]

When you have edited the file, did you use an utf-8 without bom mode on the editor?
Just to clear this parts out.

[grantj21]

Yes used note pad ++ and saved file as Encoding encode UTF-8 without BOM I've even started with a new file and edited and uploaded still the same I don't understand if you have it working why it not doning the same here. can you send me a copy of your functions.php if still don't work then its not this file

[PHPVibe A.]

We're so close to 3.5, let us focus on that and see if you still have this issue when upgrading.

[grantj21]

OK Sounds good that 3.5 is on its way, a bit off putting but I'll get by as my PHPMelody script is doing the job now. As a lot of my users are in the Far East but I can't control the front content like Vibe. So I end up with youtube porn 18+ crap which is off putting to the other 90% of users. Well it will give me time to set-up my hosting business which is almost ready to go live and yes all Vibe users are welcome need inform just pm me

[grantj21]

The update didn't fix my issue, but it wouldn't the languages didn't have any upgrade so what's going with this, is it working our not? How do I fix it

[Marius P.]

Did you create a new language?

[grantj21]

Yes deleted old made new still the same thing its not having any of it. removed lang and languages from database and reinstalled them to the database made first language English ok, doing French or any other language and it will not work, please send me a clean copy of functions.php

[Marius P.]

Ok, so I think the issue is with the escape function from ezsql, I've tested here: http://www.videosqq.com/&clang=fr

in functions.php:

find

Code Select Expand

$_value = escape( json_encode( $value ) );

and replace with:

Code Select Expand

$_value = addslashes(json_encode( $value )) ;

[grantj21]

Nice one it worked thank god, and a big thank you too you guys. I can now open my site to the world. I own you a beer any time your passing.

[Marius P.]

Nice one it worked thank god, and a big thank you too you guys. I can now open my site to the world. I own you a beer any time your passing.

No beer, just be a success story, we'll buy you the beer