FUDforum: Bug Reports

Home » FUDforum Development » Bug Reports » ümläüt

Show: Today's Messages :: Polls :: Message Navigator

ümläüt [message #159446]

Wed, 03 June 2009 14:26

nozafc

Messages: 75
Registered: April 2009

Karma: 0

Member

Just upgraded to 2.8.1 and one of my users is having a problem with his name

It was Afflikönig

Now the ö gets messed up in his name. Was working fine before the upgrade. Also it posts fine in the post-area just userid bit that messes up.

Report message to a moderator

Re: ümläüt [message #159447 is a reply to message #159446]

Wed, 03 June 2009 14:57

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Just change it back to what is should be in the User Manager control panel.

The data was somehow not stored as UTF-8. FUDforum 2.8.1 forces the DB connection to UTF-8.

Report message to a moderator

Re: ümläüt [message #159448 is a reply to message #159446]

Wed, 03 June 2009 15:21

nozafc

Messages: 75
Registered: April 2009

Karma: 0

Member

Doesn't seem to work. The name doesn't change

I've shorted his name to Affik for the time being but when I try to put Afflikönig in it says updated but the name doesn't change. I can force it to change via direct update to the database but again this causes the problem of not displaying correctly. The same happens if I try and change my name to nözafc , it basically changes it to n . It seems when trying to change the name it gets as far as the first ümläüt and ignores whatever is after it.

Report message to a moderator

Re: ümläüt [message #159450 is a reply to message #159448]

Wed, 03 June 2009 15:46

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

I have no problem creating a user "Afflikönig" on my forum. Please run the "MySQL Charset Changer" to see if it helps.

Report message to a moderator

Re: ümläüt [message #159451 is a reply to message #159446]

Wed, 03 June 2009 16:01

nozafc

Messages: 75
Registered: April 2009

Karma: 0

Member

Ok I'll try that later

It also seems to affect thread titles

Somebody just tried to create a thread title with a £ sign in it and it chopped everything off from the £ onwards

Ie

Blah blah £ blow blow

Became

Blah blah

Report message to a moderator

Re: ümläüt [message #159453 is a reply to message #159450]

Wed, 03 June 2009 17:07

nozafc

Messages: 75
Registered: April 2009

Karma: 0

Member

naudefj wrote on Wed, 03 June 2009 16:46

I have no problem creating a user "Afflikönig" on my forum. Please run the "MySQL Charset Changer" to see if it helps.

OK I've done that and still get the same issue

If I create a thread with a only a £ as the thread title it actually creates a blank thread title

Plus the issue with the name is still there

Report message to a moderator

Re: ümläüt [message #159454 is a reply to message #159453]

Wed, 03 June 2009 18:04

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

I'm unable to reproduce any of your problems. Check if your HTML pages are defined with utf-8 as Content-Type (header.tmpl). Also check what gets stored in your database.

Best of luck.

Frank

Report message to a moderator

Re: ümläüt [message #159455 is a reply to message #159446]

Wed, 03 June 2009 19:03

nozafc

Messages: 75
Registered: April 2009

Karma: 0

Member

Ok the only thing I can find in the file system related to the charset is in /thm/default/i18n/english/charset file and that says utf-8 (it seems a few template files point back to this)

The only other thing I found that all the tables in the database have a collation of utf8_unicode_ci while the database itself appears to be utf8_general_ci

That means very little to me and it's not something I want to change without understanding the consequences.

Report message to a moderator

Re: ümläüt [message #159462 is a reply to message #159455]

Thu, 04 June 2009 09:44

Peter Vendike

Messages: 65
Registered: February 2009
Location: Denmark

Karma: 0

Member
Translator

I recently had similar problems, when I upgraded from 2.8.0 to 2.8.1. I think this behavior is typical if there is a mismatch between charsets of host / FUD / php / mysql.

http://fudforum.org/forum/index.php?t=msg&th=118368&start=3&

If you are on Linux operation system, you could try de_DE.UTF-8 as charset and recompile theme.

Report message to a moderator

Re: ümläüt [message #159564 is a reply to message #159446]

Thu, 11 June 2009 11:43

nozafc

Messages: 75
Registered: April 2009

Karma: 0

Member

Just an update on this

I've recently installed a brand new forum with 2.8.1 installed and I'm getting the same problem

Quote:

If you are on Linux operation system, you could try de_DE.UTF-8 as charset and recompile theme.

How do I do this ?

Report message to a moderator

Re: ümläüt [message #159567 is a reply to message #159564]

Thu, 11 June 2009 14:32

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

See http://cvs.prohost.org/index.php/Theme_Manager#Locale

Report message to a moderator

Re: ümläüt [message #160003 is a reply to message #159567]

Tue, 14 July 2009 12:46

zwickyy

Messages: 12
Registered: July 2009

Karma: 0

Junior Member
Translator

I also have troubles with the locale / encodings. I followed this thread but no success up to now.

Here is my environment:
Version 2.8.1
Server is on Linux
file /fud/data/thm/default/i18n/german/charset is utf-8
file /fud/data/thm/default/i18n/german/locale is utf-8
locale in Theme Manager is de_DE.UTF-8 (I tried also utf-8 only)
Server Locale ist also de_DE.UTF-8

Here comes the use case:
When I view the Posts in the Flat Mode everything seems ok. When I switch to the Tree mode it still seems ok. But after clicking on the Message link below the special characters are messed up.

E.g. before: Body: ÖÄÜ öäü
after clicking the subject of the post all these carracters are messed up:
index.php?t=getfile&id=5672&private=0

After refreshing (F5) the special chars are correct again!

For me it seems that the "preview" of a message in the tree mode works differently then the other view.

Attachment: screenshot.PNG
(Size: 10.42KB, Downloaded 1274 times)

-- Zwickyy

[Updated on: Tue, 14 July 2009 12:50]

Report message to a moderator

Re: ümläüt [message #160004 is a reply to message #160003]

Tue, 14 July 2009 13:01

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

You need this patch: http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=11934 (Force charset with AJAX get)

Report message to a moderator

Re: ümläüt [message #160005 is a reply to message #160004]

Tue, 14 July 2009 13:42

zwickyy

Messages: 12
Registered: July 2009

Karma: 0

Junior Member
Translator

That did the Trick Very Happy

Thank you very much!

But I saw that this breaks now the tree view on Internet Explorer 8:

Error on Page: Line 141 column 4: Object does not support this property or method

This is the code at this line:
beforeSend: function(xhr) {
xhr.overrideMimeType('text/html; charset=utf-8');
},

-- Zwickyy

[Updated on: Tue, 14 July 2009 13:43]

Report message to a moderator