internal error on sending mail with special chars

[fsu]

I got "internal error occured" -error on sending mail with scandinavian chars.

I also made patch to fix it. it's not optimal solution but I got my webmail working again..

[alec]

What database are you using? It must be something session (database) related.

[fsu]

I have mysql-5.0.26-12 and here is connection string:
$rcmail_configdb_dsnw? = 'mysql://username:password@localhost/roundcubemail';
(replaced user/pass..)

[alec]

#1485681 marked as duplicate of that issue.

[rafi_iplus]

I made patch, and i have new problem (maybe the same). I got "internal error occured" when mail is forwarded (with special polish chars).

[fsu]

rafi_iplus: thanks, I updated patch, so forwarding should work now.

alec: Yep, it's something related to sessions and utf8..

this patch is not meant to be final solution and I hope, it will not be included to 0.2.1.. Best solution is to fix session problem, which will also fix this problem..

[alec]

what PHP version are you using?

[fsu]

pretty old, but php5-5.2.0.. I hope php6 fixes this utf8 mess.. ;)

[jjj]

Fsu i had the same problem. Now after adding your patch i can send mails with my language special chars (elożółtęczki.txt) but when i'm sending to gmail account filename changes to: UTF-8elo%C5%BC%C3%B3%C5%82t%C4%99czki.txt Why is that? How to repair this?

Greetings

[fsu]

jjj: It's something related to subject's encoding and email headers.. I think that's other bug, so you should make new ticket from that..

[alec]

People, what's your database charset? SHOW CREATE TABLE session; SHOW CREATE DATABASE roundcube;

[fsu]

CREATE TABLE session (

sess_id varchar(40) NOT NULL,
created datetime NOT NULL default '0000-00-00 00:00:00',
changed datetime NOT NULL default '0000-00-00 00:00:00',
ip varchar(15) NOT NULL,
vars text NOT NULL,
PRIMARY KEY (sess_id)

) ENGINE=MyISAM DEFAULT CHARSET=ascii

CREATE DATABASE roundcubemail /*!40100 DEFAULT CHARACTER SET latin1 */

[alec]

So, I think changing charset to utf-8 should fix the issue.

[alec]

Added info about unicode in INSTALL file.

[fsu]

I changed charset to utf8 and updated to 0.2.1 and attachments works fine now.

[jjj]

CREATE TABLE session (

sess_id varchar(40) character set ascii NOT NULL,
created datetime NOT NULL default '0000-00-00 00:00:00',
changed datetime NOT NULL default '0000-00-00 00:00:00',
ip varchar(15) character set ascii NOT NULL,
vars text character set ascii NOT NULL,
PRIMARY KEY (sess_id)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC

CREATE DATABASE roundcubemail /*!40100 DEFAULT CHARACTER SET utf8 */

on my box with rc 0.2.1 still doesnt work.

[alec]

Replying to jjj:

on my box with rc 0.2.1 still doesnt work.

but you have problem with internal error or with attachment name in sent mail? If the latter, open a new ticket attaching message source.

[jjj]

Replying to alec:

Replying to jjj:

on my box with rc 0.2.1 still doesnt work.

but you have problem with internal error or with attachment name in sent mail? If the latter, open a new ticket attaching message source.

With internal error after attaching message with special chars. Nothing change.

[alec]

jjj: change columns encoding. I see it's set to ascii. Also try svn-trunk version. If this not helps open new ticket, probably your issue is different. Describe your problem and environement again there.

[gabor87]

Dont work in 0.3-stable. any patch?

[alec]

Do not reopen tickets without any feedback information, please.

[gabor87]

The patch successful work previous version, but dont work in 0.3-stable. Well, I cant upgrade. Please fix scandinavian chars in 0.3.1, because we cant send/forward mail with attachments.

Attachment name example: "Árvíztűrő tükörfúrógép.doc"

[alec]

The same attachment name works for me, so we don't need such patch. Did you checked the database encoding as I said in my comments to this ticket? Describe your environment.

[gabor87]

db: latin1_swedish_ci
cache: utf8_general_ci
contacts: utf8_general_ci
identities: utf8_general_ci
messages: utf8_general_ci
session: ascii_general_ci
users: utf8_general_ci
myisam

Thanks!

[alec]

So, I think if you change all of them to utf-8 issue will not happen.

[gabor87]

Works, very thanks!