New Zenner
- Join Date:
- May 2005
- Posts:
- 2
- Plugin Contributions:
- 0
Email disabled in upgrade to 1.3.7
I upgraded from v1.2.7 to 1.3.7. Everything worked great except the "email customers" in admin. I tried opening a new account in my store and got no email welcome. No PayPal responses either.
Clicking Admin/Tools/Send Email I got this error msg. instead of the text editor:
"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 'PRODUCTID order by c.customers_lastname, c.customers_firstname A
in:
[select c.customers_firstname, c.customers_lastname, c.customers_email_address from zen_customers c, zen_orders o, zen_orders_products op where o.customers_id = c.customers_id and o.orders_id = op.orders_id PRODUCTID order by c.customers_lastname, c.customers_firstname ASC ]
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."
What I tried:
Reverting back to 1.27 (and the old DB) brought HTML Area email text editor box back.
I tried a clean install of v1.3.7 and same thing happened, no emails sent. I tried installing 1.3.6 and got same.
Finally, deleted the whole value for zen_query_builder` VALUES (6, 'email', 'All Customers who have purchased product xx'.
This brought back the email text editor box function, and the emails I wrote show up in the DB email archive, but the emails did not arrive.
There is some glitch in this upgrade process. What can it be????