Smth wrong with db collation & GD

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: collation

Author

Posts
April 20, 2015 at 10:56 pm #37705

Dmitry Koptyubenko
Buyer

Post count: 9

Hi!

Thanks for trying to help me. Asked this at https://wordpress.org/support/topic/need-to-change-fonts

I use Geodirectory plugin in Russia, and the fonts I use support kyrillic letters. Still one doesn’t. When I click on the marker icon on the map, I read something like Р’РІРµРґРµРЅСЃРєРѕРіРѕ etc. not words. That’s something wrong with the font? Where to change it?

http://pumbr.ru/club/

U’ve wrote:

if you still have problems then please post on our support forum and we will be able to ask for login details in private and we can take a look to help resolve this for you

PLEASE DO HELP ME!

April 20, 2015 at 11:21 pm #37706

Paolo
Site Admin

Post count: 31211

Hi,

the problem isn’t a Font, but the database collation.

Please provide phpmyadmin (cpanel) link and credentials and we will fix it for you.

Thanks

April 21, 2015 at 4:38 am #37714

Dmitry Koptyubenko
Buyer

Post count: 9

This reply has been marked as private.

April 21, 2015 at 2:25 pm #37741

Dmitry Koptyubenko
Buyer

Post count: 9

By the way here http://pumbr.ru/club/places/education/ the problem with the bubble is present, still when you see i’ve got right letters when just directing the mouse to the point

April 22, 2015 at 8:56 am #37782

Stiofan O’Connor
Site Admin

Post count: 22956

Hi Dmitry,

I see it is correct in the DB, i think it’s a problem when being converted to html for the AJAX call, i think this might be due to you running PHP < 5.4? Can you verify your PHP version? If you can pass me wp-admin and FTP details i will try and find a solution. Thanks, Stiofan

April 22, 2015 at 9:11 am #37784

Dmitry Koptyubenko
Buyer

Post count: 9

This reply has been marked as private.

April 22, 2015 at 9:20 am #37786

Stiofan O’Connor
Site Admin

Post count: 22956

Thanks for the info Dmitry, i am travelling today and have to leave now, i will look at this first thing tomorrow morning.

(if you have PHP 5.4 or less you might want to try to upgrade?, this seems to be the problem function: http://php.net/manual/en/function.htmlentities.php)

Thanks,

Stiofan

April 22, 2015 at 7:31 pm #37814

Dmitry Koptyubenko
Buyer

Post count: 9

My hosting supports php 5.3 only (yeah – lots of oil, vodka and bears going down the streets, but no php 5.4). Could you please identify, if it is really the only problem? I’m unable to solve it by myself, upgrading manually, but i’ll try to find smbd who can

April 23, 2015 at 10:25 am #37867

Stiofan O’Connor
Site Admin

Post count: 22956

OK i got to the bottom of this, your server was specifically sending the encoding an non utf-8 for the ajax requests, i have now specifically told it to always use utf-8 and to override server settings.

Please check now.

Thanks,

Stiofan

April 23, 2015 at 10:38 am #37868

Dmitry Koptyubenko
Buyer

Post count: 9

IT WORKS! Thank you so much!

April 23, 2015 at 11:01 am #37870

Stiofan O’Connor
Site Admin

Post count: 22956

You are welcome! 🙂

If you think we deserve some good feedback (which is what helps us grow) feel free to leave us a good review: https://wordpress.org/support/view/plugin-reviews/geodirectory

Thanks,

Stiofan
Author

Posts