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.
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.
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.
Bookmarks