I've searched this thread several times, and I'm not quite seeing a specific answer. I know several people have written about a 1064 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 '% WHERE (c.customers_lastname LIKE '% WHERE (c.customers_lastname LIKE '% WHERE ' at line 1
I'm getting the same thing when I attempt to add points to my customers' accounts. I'm currently using the following:
Reward Point Suite 1.22a
ZenCart 1.38a
I've been using the suite for several months with no problems. On the suggestion of my web host, I updated my server from PHP 4 to PHP 5 (FastCGI).
When I started getting the error message, I optimized my database and installed the SQL patch from 1.23a. However, I'm still getting the same error message. I can't seem to find a clear solution when I search this thread. Is there a fix I'm missing?
Thanks for your time.