emailing customer problem after uninstalling newsletter subscribe addon please help

[markhof]

hello

i added the email newsletter module -- big mistake --

was not able to get it working how i wanted. uninstalled it. now i'm getting
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.



when i try and view admin -- tools -- send email


anyone see this?

[DrByte]

It has changed the contents of the query_builder table in your database. Easiest fix is to put back the original entries by deleting the existing ones and inserting the originals by copying them from the original zc_install/sql/mysql_zencart.sql script (located near the bottom of the file) via phpMyAdmin.