Zen Follower
- Join Date:
- Feb 2005
- Location:
- Manchester ~ UK
- Posts:
- 107
- Plugin Contributions:
- 0
Site SQL errors after sending email and order confirm
Hello,
We are getting the following errors on a site after an email is being sent, (eg: once you hit the send button from the contact form).
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 '''' at line 1
in:
[select customers_email_format from zen_customers where customers_email_address= '']
Secondly, the site is pulling another similar 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 '''' at line 1
in:
[select customers_email_format from zen_customers where customers_email_address= '']) once you confirm an order (using both the authorise payment module and check/money order option).
The site is version 1.3.0.2 and hosted using:
PHP Version 4.4.1 and
MySql version 5.0.21
Many thanks if you can point me in the direction of solving this one.