' in email adress causes problems

Some of our customers have an apostrophe in their email address. When we try to send email via admin this throws a 1064 SQL error, presumably because the ' throws out the parsing. Any ideas how to work around/rectify?

What version of Zen Cart are you using?

Sorry, should have put that in the orignal post. The store configuration is:

Server OS: Linux 2.4.20-021stab028.19.777-enterprise
Database: MySQL 3.23.58
HTTP Server: Apache/2.0.51 (Fedora)
PHP Version: 4.3.10 (Zend: 1.3.0)
Zen Cart 1.3.0.2
Database Patch Level: 1.3.0.2

I'm using a modified version of the pupleshades template.

Regards

Peter

Have to admit I have never seen an email address with an apostrophe in it ...

Note: php v4.3.10 is rather outdated and you should see about upgrading to v4.4.2 ...

Ajeh:

Have to admit I have never seen an email address with an apostrophe in it ...

We've got many customers in Ireland (think O'Connor, O'Meera...). Most of the email addresses drop the apostrophe but there are a few that don't.

The PHP version is the one supplied and supported by my hosting company. I'll be upgrading as soon as they have anew supported version.

Regards

Peter

pglock:

Some of our customers have an apostrophe in their email address. When we try to send email via admin this throws a 1064 SQL error, presumably because the ' throws out the parsing. Any ideas how to work around/rectify?
Apostrophe in an email address? I dont think thats allowed in most of the cases but yeah some countries do use it....
The problem is definitely due to the problem in parsing because of aporstrophe in the email
See here:
http://www.regular-expressions.info/email.html

Well, the solution would be that you would have to change the script wherever email verification is being done and also make sure it gets inserted into mysql properlly and get retreived properly too
Thanks
San

OK, thnks for the info. It looks like a codefest is required.

Regards

Peter

pglock:

OK, thnks for the info. It looks like a codefest is required.

Regards

Peter
Hmm, nothing complex though

Try this
http://codegrrl.com/!/faq/view/apostrophe_in_email_all/

Please make sure that you backup files before you edit any
Let us know if it corrects the problem
Thanks !
San

pglock:

Some of our customers have an apostrophe in their email address. When we try to send email via admin this throws a 1064 SQL error...

Do the customers receive their "welcome" emails properly?
Do they receive order-confirmation emails properly?

Sorry for the delay in replying, other issues with the new site (mostly DNS, not Zen Cart).

Yes, customers are recieving emails OK. It is only two customers out of 4000+ that have an apostrophe in their email so it's not a major issue for day to day operation but does affect newsletters.

I'll look at the phpmail 'stripslash' approach in the next update (August).

Regards

Peter