Newsletter-Only Subscriptions for v1.3x

[gilby]

I have had to uninstall this and have done so, except that I am getting an error in my sql. How do you uninstall the sql part of this?

What is the error?

[1kell]

What is the error?

After uninstalling this, whenever I go to the "Send Mail", to try to email subcribers I can't, I get this message:

Send Email To Customers


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 'as s left join customers as c on c.customers_id = s.customers_id' at line 1
in:
[select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from as s left join customers as c on c.customers_id = s.customers_id ]
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.

I recall having to run an SQL change when installing this, so there must be something I need to run to uninstall it, right? I don't know what to run though and I am stuck with no email capability, which is really a big inconvenience as you can imagine