Zen Cart Logo
Forums / General Questions / Newsletter didn't seem to send, mySQL error?

Newsletter didn't seem to send, mySQL error?

Locked

Views: 1,021

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
8 Feb 2010, 9:59 PM
#1
redpanda avatar

redpanda

New Zenner

Join Date:
Aug 2009
Posts:
59
Plugin Contributions:
0

Newsletter didn't seem to send, mySQL error?

Hi,
I am at a complete loss as to what to do was trying to send a newsletter and got this error msg.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cherieoreilly####################.au'' at line 1
in:
[select customers_email_format from zen_customers where customers_email_address= 'cherieoreilly####################.au'cherieoreilly####################.au']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any help is appreciated.

8 Feb 2010, 11:27 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Newsletter didn't seem to send, mySQL error?

Just a wild guess, but it looks like a bad email address assigned to one of your customers.

2 Mar 2010, 12:02 PM
#3
redpanda avatar

redpanda

New Zenner

Join Date:
Aug 2009
Posts:
59
Plugin Contributions:
0

Re: Newsletter didn't seem to send, mySQL error?

yeah it is but deleting that email address doesn't seem to solve the probelm, any thoughts?

3 Mar 2010, 5:23 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Newsletter didn't seem to send, mySQL error?

Pardon me for stating the obvious, but ... using valid addresses will prevent errors caused by invalid addresses. So, fixing the bad address should be something you might consider.