Zen Cart Logo
Forums / General Questions / emailing customer problem after uninstalling newsletter subscribe addon please help

emailing customer problem after uninstalling newsletter subscribe addon please help

Views: 548

Results 1 to 2 of 2
21 Apr 2011, 4:10 PM
#1
markhof avatar

markhof

New Zenner

Join Date:
Apr 2011
Posts:
4
Plugin Contributions:
0

emailing customer problem after uninstalling newsletter subscribe addon please help

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?

21 Apr 2011, 4:49 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: emailing customer problem after uninstalling newsletter subscribe addon please help

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.