The other night I upgraded my database from 1.3.8a to 1.3.9h.
Everything seems to be working well other than when I try to send a customer email - i get the following error:
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 zen_customers as c on c.customers_id = s.customers_id' at line 1
[select c.customers_firstname, c.customers_lastname, s.email_address as customers_email_address from as s left join zen_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 have read through some posts on similar problems and the following seems to be something that pops up.
Prior to upgrade, I had the newsletter subscribe and email exporter modules installed. I did not remove any of these before upgrading.
Could someone please describe what steps I need to take in order to get everything working again.
Thanks in advance