Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

internal error on sending mail with special chars #2043

Closed
rcubetrac opened this issue Jan 14, 2009 · 39 comments

Comments

Projects
None yet
1 participant
@rcubetrac
Copy link

commented Jan 14, 2009

Reported by fsu on 14 Jan 2009 14:19 UTC as Trac ticket #1485687

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..

Keywords: attachment
Migrated-From: http://trac.roundcube.net/ticket/1485687

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jan 14, 2009

Comment by @alecpl on 14 Jan 2009 17:44 UTC

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

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jan 14, 2009

Comment by fsu on 14 Jan 2009 20:27 UTC

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

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jan 15, 2009

Comment by @alecpl on 15 Jan 2009 08:16 UTC

#1485681 marked as duplicate of that issue.

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jan 15, 2009

Owner changed by @alecpl on 15 Jan 2009 08:16 UTC

=> none

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jan 15, 2009

Milestone changed by @alecpl on 15 Jan 2009 08:16 UTC

later => 0.2.1

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jan 15, 2009

Comment by rafi iplus on 15 Jan 2009 11:46 UTC

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

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jan 15, 2009

Comment by fsu on 15 Jan 2009 13:31 UTC

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..

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jan 16, 2009

Comment by @alecpl on 16 Jan 2009 08:48 UTC

what PHP version are you using?

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jan 16, 2009

Comment by fsu on 16 Jan 2009 09:23 UTC

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

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Feb 1, 2009

Comment by jjj on 1 Feb 2009 17:51 UTC

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

Greetings

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Feb 1, 2009

Comment by fsu on 1 Feb 2009 19:10 UTC

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..

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Feb 6, 2009

Comment by @alecpl on 6 Feb 2009 08:36 UTC

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

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Feb 6, 2009

Comment by fsu on 6 Feb 2009 12:59 UTC

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 */

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Feb 6, 2009

Comment by @alecpl on 6 Feb 2009 13:04 UTC

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

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Feb 16, 2009

Comment by @alecpl on 16 Feb 2009 09:55 UTC

Added info about unicode in INSTALL file.

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Feb 16, 2009

Status changed by @alecpl on 16 Feb 2009 09:55 UTC

new => closed

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Mar 11, 2009

Comment by fsu on 11 Mar 2009 09:35 UTC

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

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Apr 22, 2009

Comment by jjj on 22 Apr 2009 19:42 UTC

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.

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Apr 22, 2009

Status changed by jjj on 22 Apr 2009 19:42 UTC

closed => reopened

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Apr 23, 2009

Comment by @alecpl on 23 Apr 2009 06:57 UTC

Replying to jjj:

on my box with rc 0.2.1 still doesnt work.
[[BR]]
but you have problem with internal error or with attachment name in sent mail? If the latter, open a new ticket attaching message source.

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Apr 23, 2009

Status changed by @alecpl on 23 Apr 2009 06:57 UTC

reopened => closed

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Apr 23, 2009

Comment by jjj on 23 Apr 2009 21:43 UTC

Replying to alec:

Replying to jjj:

on my box with rc 0.2.1 still doesnt work.
[[BR]]
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.

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Apr 23, 2009

Status changed by jjj on 23 Apr 2009 21:43 UTC

closed => reopened

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jun 3, 2009

Comment by @alecpl on 3 Jun 2009 10:40 UTC

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.

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Jun 3, 2009

Status changed by @alecpl on 3 Jun 2009 10:40 UTC

reopened => closed

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Sep 30, 2009

Comment by gabor87 on 30 Sep 2009 07:44 UTC

Dont work in 0.3-stable. any patch?

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Sep 30, 2009

Keywords changed by gabor87 on 30 Sep 2009 07:44 UTC

attachment

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Sep 30, 2009

Severity changed by gabor87 on 30 Sep 2009 07:44 UTC

normal => major

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Sep 30, 2009

Milestone changed by gabor87 on 30 Sep 2009 07:44 UTC

0.2.1 => 0.3.1

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Status changed by gabor87 on 5 Oct 2009 05:47 UTC

closed => reopened

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Comment by @alecpl on 5 Oct 2009 06:22 UTC

Do not reopen tickets without any feedback information, please.

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Status changed by @alecpl on 5 Oct 2009 06:22 UTC

reopened => closed

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Comment by gabor87 on 5 Oct 2009 06:32 UTC

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: "rvztr tkrfrgp.doc"

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Status changed by gabor87 on 5 Oct 2009 06:32 UTC

closed => reopened

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Comment by @alecpl on 5 Oct 2009 06:50 UTC

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.

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Comment by gabor87 on 5 Oct 2009 06:56 UTC

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!

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Comment by @alecpl on 5 Oct 2009 06:56 UTC

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

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Status changed by @alecpl on 5 Oct 2009 06:56 UTC

reopened => closed

@rcubetrac rcubetrac closed this Oct 5, 2009

@rcubetrac

This comment has been minimized.

Copy link
Author

commented Oct 5, 2009

Comment by gabor87 on 5 Oct 2009 07:09 UTC

Works, very thanks!

@rcubetrac rcubetrac added this to the 0.3.1 milestone Mar 20, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.