Apostrophe in new user email address

[russfordyce]

I just tried adding a new user to the system....irish guy...o'donnell. Sugar won't let me save the user instead returns an error - "invalid email address"

i.e. - bobbyo'donnell@mail.com

HELP!

[susiewilliams]

Hi there,

I don't think you can put an apostrophe in any email address (whether it's in Sugar or not). Isn't that a special character that's disallowed by email systems?

[russfordyce]

While I am no expert, the outlook card for this user has an apostrophe in the email address. My boss has one too.... I am able to email from outside the company via gmail into the company with an apostrophe in the email address......so...I think it is allowed.

How can I turn off the email validation?

[rps1984]

That character is illegal in e-mail addresses. I have a feeling the display name (or real name) uses one, but the actual from address does not.

Example of a from address:
bobbyo'donnell@example.com <bobbyodonnell@example.com>

Notice the one with the ' and the one without the '

[karlsfre]

You CAN have an apostrophe in the email address. It is actually quite common here in Ireland.

The email address is defined in RFC 822 http://www.w3.org/Protocols/rfc822/, which basically says that the part before the @ can have any ASCII character apart from Space, Control characters, "(", ")", "<", ">", and "@".

[karlsfre]

I actually get the email address into SugarCRM, through the SOAP interface to Prospects (a.k.a Targets)

My problem is that when Sugar goes to send the email it translates the apostrophe to %039 (the URL encoding for the apostrophe, ASCII character 0x39).

So, instead of sending the email to bobbyo'donnell@example.com it sends an email to bobbyo%039donnell@example.com. Then I get an error message back from the example.com mail server, saying that the mailbox does not exist.

At the moment I have a good few users who cannot get their newsletter because of this problem.

It seems this bug is fixed in the next release: 4.5.1g.

[leigh]

Any indication of what/where the problem is? I have a 3.5.1c installation which is showing the same issues, I'd much rather fix the bug than upgrade.

[kuske]

The email RFC explains exactly which chars are allowed, just see http://www.rfc-editor.org/rfc/rfc2822.txt for details.

I could not find there, that apostrophes are disallowed

But I see alsoe that they are a great problem that should be solved.

hk

[rjhunja]

Any intent of fixing this? 5.1a and it's still broken. We see lots of email addresses out there that have apostrophes and other email systems handle them fine.

[eggsurplus]

The regular expressions for this if you wish to edit and allow apostrophes is in:
include/SugarEmailAddress/SugarEmailAddress.php (look for $regex)
jssource/src_files/include/javascript/sugar_3.js (function isValidEmail)