Quote Originally Posted by gonewild View Post
Now another error.

When the customer has a credit due everything works fine.
But when the customer does not have credit this error occurs after clicking confirm order.

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 customer_id=1' at line 1
in:
[update sc_customer set amount = amount - where customer_id=1]
Yes, I'm getting exactly the same error. In fact, because of other more pressing site issues I've removed the SQL completely and abandoned this module for the time being. It seems the module originator may have backed out and since there isn't enough other forum traffic to help resolve some of these problems, it isn't worth having it installed.
It's a shame because I think it could be a very useful module for many people but I just don't have the php expertise to work out these problems without some guidance.
I hope down the road interest will be peaked and the thread will be brought back to life.