Error when installing newsletter_subscribe_2_2_2

[asiamarinehub]

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?

[asiamarinehub]

Solved.

[Thannaree]

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