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

Home » FUDforum Development » Bug Reports » Russian UTF-8 problems
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Russian UTF-8 problems [message #159515] Sat, 06 June 2009 16:45 Go to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 17: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
add to buddy list
ignore all messages by this user
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 02:56 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 05:21 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 05:42 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 07:02 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 07:36 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 08:22 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 08:31 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks! - private messages were fixed.
Re: FUDforum 2.8.1 Released [message #159527 is a reply to message #159526] Sun, 07 June 2009 10:12 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 10:51 Go to previous messageGo to next message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 12:12 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 13:34 Go to previous message
anli is currently offline  anli   Russian Federation
Messages: 23
Registered: June 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 13:35]

Report message to a moderator

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Fri Dec 15 08:44:57 EST 2017

Total time taken to generate the page: 0.00839 seconds