FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Russian UTF-8 problems
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Russian UTF-8 problems [message #159515] Sat, 06 June 2009 20:45 Go to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
During upgrading from 2.8 to 2.8.1 I got a message about changing a language from russian-1251 to russian. After upgrading all messages become abracadabra (all interface messages are ok). At mysql charset admin menu item I got a recommendation to convert tables to utf8 - have done, nothing changed.

Have I missed something?
Re: FUDforum 2.8.1 Released [message #159517 is a reply to message #159515] Sat, 06 June 2009 21:36 Go to previous messageGo to next message
JanRei is currently offline  JanRei   
Messages: 361
Registered: October 2005
Location: Germany
Karma: 0
Senior Member
Contributing Core Developer
Translator
I think the new theme uses UFT-8 as charset while the stored messages using the charset of the old theme. One way to fix this should be converting the messages to UTF-8 using "Compact Messages" in the Admin Control Panel. It is recommended to make a backup of the files before - in case something goes wrong.

---

By the way, is it possible that the server here at fudforum.org doesn't send mail notifications anymore? I received the last on March 21st.
Re: FUDforum 2.8.1 Released [message #159518 is a reply to message #159517] Sun, 07 June 2009 06:56 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Upgrade script:
Your forum's language was changed from russian-1251 to russian. Please convert your database and message files to UTF-8 before opening your forum.


database -> MySQL Charset Changer

message files -> Message Compactor
Re: FUDforum 2.8.1 Released [message #159521 is a reply to message #159515] Sun, 07 June 2009 09:21 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
Thanks! - I have missed "Compact Messages" contains another big function - messages converting Smile All is OK now.

P.S Indeed, new messages notifications are resting somewhere Laughing
Re: FUDforum 2.8.1 Released [message #159522 is a reply to message #159515] Sun, 07 June 2009 09:42 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
Sorry, I was too fast. After compacting (and converting) messages from russian-1251 to utf forums messages are OK, but private post messages are still abrakadabra. It seems, I still missed something Smile
Re: FUDforum 2.8.1 Released [message #159523 is a reply to message #159522] Sun, 07 June 2009 11:02 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Here's a fix: http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=11936

A reconversion will probably mess up your messages. So, remove the first part (conversion of normal messages) before you run it.
Re: FUDforum 2.8.1 Released [message #159524 is a reply to message #159523] Sun, 07 June 2009 11:36 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
naudefj wrote on Sun, 07 June 2009 07:02
Here's a fix: http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=11936

A reconversion will probably mess up your messages. So, remove the first part (conversion of normal messages) before you run it.


Is it correct to (temporary) delete from patched compact.php all code from
/* Normal Messages */
till
/* Private Messages */
? I'm not PHP guru Smile
Re: FUDforum 2.8.1 Released [message #159525 is a reply to message #159524] Sun, 07 June 2009 12:22 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Looks about right, just keep the lines that define $tbl and
$stm:

$tbl =& $DBHOST_TBL_PREFIX;
...
$stm = time();
Re: FUDforum 2.8.1 Released [message #159526 is a reply to message #159515] Sun, 07 June 2009 12:31 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
Thanks! - private messages were fixed.
Re: FUDforum 2.8.1 Released [message #159527 is a reply to message #159526] Sun, 07 June 2009 14:12 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Well done Andrew! I realize the UTF-8 conversion is a pain in the behind, but it's well worth the effort.
Re: FUDforum 2.8.1 Released [message #159528 is a reply to message #159515] Sun, 07 June 2009 14:51 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
It isn't a problem of any kind - rather it is something very tiny: sometimes search results at the end of a message citation has something unprintable - I have attached an image to illustrate it.

index.php?t=getfile&id=5607&private=0

And, naudefj, I'm agree with you - UTFization is a good thing Smile
Re: FUDforum 2.8.1 Released [message #159529 is a reply to message #159528] Sun, 07 June 2009 16:12 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
This patch should fix it: http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=11937

PS: Remember to rebuild your themes after applying it.
Re: FUDforum 2.8.1 Released [message #159532 is a reply to message #159529] Sun, 07 June 2009 17:34 Go to previous message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
naudefj wrote on Sun, 07 June 2009 12:12
This patch should fix it: http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=11937

PS: Remember to rebuild your themes after applying it.


naudefj, you fix problems faster than I apply patches Shocked Thanks! - this tiny issue has gone also.

[Updated on: Sun, 07 June 2009 17:35]

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: UTF-8 isn't correctly displayed in thread view
Next Topic: Blank Page - Not Processing PHP pages
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 19:55:43 GMT 2024

Total time taken to generate the page: 0.02468 seconds