error 1064 after client completed order.

[cristaltech]

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=12' at line 1
in:
[update zen_sc_customer set amount = amount - where customer_id=12]

The order is completed and is correctly added to admin and the clients profile.

I cannot understand the error. Can someone help me with this ???

[TheOracle]

I cannot see any table names with sc_ from the zen core. Did you installed a contribution module for checkout ? If so, I'd suggest to ask to the original MOD's topic in order to get a definite answer from the author who actually built this MOD.

[cristaltech]

This is a new installation. No mods been modified, I think. Where is the files situated and can I recover them from my backups ???

[cristaltech]

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 zen_sc_customer set amount = amount - where customer_id=1]

This is the full error I am receiving

[TheOracle]

From which page does this error message appears exacly and which Zen-Cart version are using ?

[cristaltech]

1.3.7; After step 3 when the order is confrmed. It happens when the payment mods EFT, Debit order or invoice method is chosen. I do not have a problem with credit card or paypal.

[cristaltech]

Ok It have the same error with all the transactions, does not matter credit card, eft, invoice, debit order, or paypal.

The error is on the return path, where it should open the page which should be specified to open when finalizing the sale.

Where can I edit that ???????????

[cristaltech]

I got it sorted out. The shipping modules order must be from 0. That mean if you use more than one, say flat rate and free shipping, it must be in sequence 0 and 1. It sorted out that problem. So in my opinioin all 1064 errors is shipping errors.

[Ajeh]

When numbering modules ... it is best to number all modules that are installed and not just some or you can inadvertantly setup values that overwrite one another ...

I number by 10s as I might want to rearrange things later ...