Recent Topics

1 Dec 08, 2013 00:52    

hi friends,

I upgraded b2evo version from 3.3.3 to 5.0.6
and almost felt relief, until noticed that Russian language in COMMENTS not displaying properly.

Meanwhile the rest of the russian language content - in the BODY/POSTS - is all OK.

What might be done to repair russian language encoding in comments ?

example url: http://www.ant-sudak.ru/hotel/about-hotel/01

--
PS:

1. After cleaning CASHES and FIRST (F5) reload of page with COMMENTS - (RU)-comments display correctly.
But the next reload of page crashes comment again to broken symbols.

2. If I RESAVE (RU) comment - it displays correctly (on the first page load).
But the next reload of page crashes comment again to broken symbols.

hmm

2 Dec 08, 2013 19:23

FIXED

ok,
I tried this: http://forums.b2evolution.net/5-0-0-0-bug
and this: http://shininghappypeople.net/deljr/b2e-russian-english.html

and these helped me to find my own simple solution.

1.
I noticed, that after "Clear pre-renderered comment cache (DB)" (through b2evo/ admin.php) - my Cyrillic (Russian) comments are displayed properly just once, until the next reload.

2.
So I went to my HOSTING phpMyAdmin and found there TABLES responsible for COMMENTS PRE-RENDERING = evo_comments__prerendering.
For some reason its COLLATION was "latin1_swedish_ci" .
So I changed it manually to "utf8_general_ci" and now at last feel relief ).

Good luck to all !

3 Dec 08, 2013 19:30

4 Dec 10, 2013 09:21

Excellent @acho, thanks for sharing. I just realized you posted this before I sent my answer :)


Form is loading...