Quote Originally Posted by kimsonvu View Post
Hi,

After search customer last name in Admin->Customer->Reward Points Module

I click into customer which i found to edit point but i saw this trouble :

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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM handicrareward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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.


Do you know how to fix this?

Thanks you!
Hi Andrew. I've just discovered I'm having this problem, too I've had a customer pay with Paypal, so need to manually award her points, but I can't due to this error.

I have checked and yes....I am running MySQL version 4.1.22-standard .
Any idea how I update this? Do I need to ask my host to do it?