Zen Cart Logo
Forums / All Other Contributions/Addons / Error when installing newsletter_subscribe_2_2_2

Error when installing newsletter_subscribe_2_2_2

Views: 653

Results 1 to 3 of 3
4 Oct 2011, 6:31 AM
#1
asiamarinehub avatar

asiamarinehub

New Zenner

Join Date:
Oct 2007
Posts:
41
Plugin Contributions:
0

Error when installing newsletter_subscribe_2_2_2

I am using zen cart 1.3.9h and installing newsletter_subscribe_2_2_2.

As I was doing the installing, I realise I do not know the location for some of the files. Thus, I decide to uninstall / delete those from the module.

When I go back to Newsletter and Product Notifications Manager

I tried to send a newsletter, I got this

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 'WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or cust' at line 1
in:
[SELECT email_address as customers_email_address FROM WHERE email_format != 'NONE' and confirmed = 1 and (customers_id IS NULL or customers_id = 0) order by email_address ]
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.

How can I solve it?

4 Oct 2011, 6:53 AM
#2
asiamarinehub avatar

asiamarinehub

New Zenner

Join Date:
Oct 2007
Posts:
41
Plugin Contributions:
0

Re: Error when installing newsletter_subscribe_2_2_2

Solved.

27 Nov 2011, 10:57 AM
#3
thannaree avatar

thannaree

Zen Follower

Join Date:
Dec 2010
Location:
Thailand
Posts:
304
Plugin Contributions:
1

Re: Error when installing newsletter_subscribe_2_2_2

could you please share with us all how you solved it?