Hi all,

I'm getting SQL errors when trying to email a customer, email coupons etc. I'm running 1.3.8a and have recently moved to a new server (Lunarpages).

Any help will be much appreciated.

Here's the error when trying to send a coupon.

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 '= subdate(now(),INTERVAL 3 MONTH) ORDER BY c.customers_lastname, c.customers_fir' at line 1
in:
[select o.date_purchased, c.customers_email_address, c.customers_lastname, c.customers_firstname from customers c, orders o WHERE c.customers_id = o.customers_id AND c.customers_newsletter = 1 GROUP BY c.customers_email_address HAVING max(o.date_purchased) <= subdate(now(),INTERVAL 3 MONTH) 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.
Here's the error when trying to email from the customer list.

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 '= subdate(now(),INTERVAL 3 MONTH) ORDER BY c.customers_lastname, c.customers_fir' at line 1
in:
[select o.date_purchased, c.customers_email_address, c.customers_lastname, c.customers_firstname from customers c, orders o WHERE c.customers_id = o.customers_id AND c.customers_newsletter = 1 GROUP BY c.customers_email_address HAVING max(o.date_purchased) <= subdate(now(),INTERVAL 3 MONTH) 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.