Home Community Forum Plugins

Documentation

For Developers For Storeowners

Services Donate Get Started

Forums / Managing Customers and Orders / error 1064 after client completed order.

error 1064 after client completed order.

Locked

Results 1 to 9 of 9

This thread is locked. New replies are disabled.

09 May 2007, 17:19

cristaltech

New Zenner

Join Date:: Apr 2007
Posts:: 87
Plugin Contributions:: 0

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

:lamo: 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 ???

12 May 2007, 13:13

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: error 1064 after client completed order.

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. :wink2:

14 May 2007, 15:09

cristaltech

New Zenner

Join Date:: Apr 2007
Posts:: 87
Plugin Contributions:: 0

Re: error 1064 after client completed order.

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

14 May 2007, 20:53

cristaltech

New Zenner

Join Date:: Apr 2007
Posts:: 87
Plugin Contributions:: 0

Re: error 1064 after client completed 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 zen_sc_customer set amount = amount - where customer_id=1]

This is the full error I am receiving

14 May 2007, 21:52

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: error 1064 after client completed order.

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

15 May 2007, 07:34

cristaltech

New Zenner

Join Date:: Apr 2007
Posts:: 87
Plugin Contributions:: 0

Re: error 1064 after client completed order.

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.

15 May 2007, 08:20

cristaltech

New Zenner

Join Date:: Apr 2007
Posts:: 87
Plugin Contributions:: 0

Re: error 1064 after client completed order.

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 ???????????

15 May 2007, 08:40

cristaltech

New Zenner

Join Date:: Apr 2007
Posts:: 87
Plugin Contributions:: 0

Re: error 1064 after client completed order.

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.

15 May 2007, 15:21

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: error 1064 after client completed order.

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 ... :smile: