FUDforum: Bug Reports » NNTP import fails with charset issue

Home » FUDforum Development » Bug Reports » NNTP import fails with charset issue (Different charset for the sender than for the message contents)

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

NNTP import fails with charset issue [message #184912]

Sat, 15 February 2014 09:38

StephenKing

Messages: 10
Registered: August 2012

Karma:

Junior Member

Hi,

I'm not sure if this is because of a limitation of the news reader, MySQL or FUDforum - but the effect was that NNTP import stopped working.

Path: lists.typo3.org!not-for-mail
From: J�rg Schaller <typo3@rasc....com>
Newsgroups: typo3.german
Subject: Re: [TYPO3-german] Mit Powermail news MEHRSPRACHIG
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Newsreader: Forte Agent 6.00/32.1186

The From: header of the email seems to be ISO-8859-1 encoded, while the body of the message is declared as UTF-8.
Even Thunderbird has trouble with this, when I show the message details (it shows the ö correctly in the list of mails).

The bad thing with FUDforum is that the import always stops with a fatal error, because of a duplicate key entry, as there is already another user 'J':

1062: Duplicate entry 'J' for key 'fud30_users_i_l'
Query: INSERT INTO fud30_users ( login, alias, ... ) VALUES ( 'J�rg Schaller', 'J�rg Schaller',......' )

So FUDforum seems to pass the name as is to MySQL, which then truncates the string.

I'm not sure, what a good relief could be.. and I'm also not an expert in mail header affairs - but it is valid that header fields are of a different charset then the body, isn't it?
Or is more a mistake of the Forte Agent mailer (that I never heard of).

Thanks
Steffen

P.S: Entry in our issue tracker: http://forge.typo3.org/issues/55997

Attachment: mail.txt
(Size: 2.03KB, Downloaded 823 times)
Attachment: Screen Shot 2014-02-15 at 10.28.49.png
(Size: 136.20KB, Downloaded 812 times)

Report message to a moderator

[Message index]

		NNTP import fails with charset issue By: StephenKing on Sat, 15 February 2014 09:38
		Re: NNTP import fails with charset issue By: naudefj on Wed, 02 April 2014 08:11
		Aw: Re: NNTP import fails with charset issue By: Fladi on Wed, 02 April 2014 09:52
		Re: Aw: Re: NNTP import fails with charset issue By: naudefj on Wed, 02 April 2014 10:05

Previous Topic:	Importing #n from a.b.cCannot fetch #n: 430 No such article: n
Next Topic:	Registered users change view and get error message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 19 15:55:25 GMT 2024

Total time taken to generate the page: 0.04734 seconds