1064 sql error after confirming order

[rued]

After confirming in step 3 in the checkout process I get this 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 '000000 where products_id = '11'' at line 1
in:
[update zen_products set products_ordered = products_ordered + 1,000000 where products_id = '11']

Zen Cart 1.3.0.1
Database Patch Level 1.3.0.1

MySQL 4.1.9-nt
Apache/2.0.52 (Unix)
PHP 4.3.10

Anyone who know what causes this?

[DrByte]

The "+ 1,000000 " part is what's causing the problem.

a. What addons have you installed, or what modifications have you made?
b. What are your currency settings for your default currency?

[san_san]

I get this error:
1064 You have an error in your SQL syntax near '(address_book ab left join zones z on (ab.en' at line 7
in:
[select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, co.countries_id, co.countries_name, co.countries_iso_code_2, co.countries_iso_code_3, co.address_format_id, ab.entry_state from customers c, (address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries co on (ab.entry_country_id = co.countries_id) ) where c.customers_id = '1' and ab.customers_id = '1' and c.customers_default_address_id = ab.address_book_id]


Please help !!

[Ajeh]

Upgrade to Zen Cart v1.3.0.1 ... the current version ... with a few bugfixes added to it such as this one ...

[san_san]

I already have version Zen Cart 1.3.0

Eran

[noface]

I have 1.3.0.2 and the same problem:

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 '000000 where products_id = '242'' at line 1
in:
[update shop_2_products set products_ordered = products_ordered + 1,000000 where products_id = '242']

How can be resolved problem with "+ 1,000000". I use Czech language (win-1250) with thousands separator "." and decimal point ",". It was always functional. Also language setting were always ok.

[noface]

I found solution.

When I changed in /includes/classes/order.php SQL command on row 670 from:

$db->Execute("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%f', $this->products[$i]['qty']) . " where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'");

to:

$db->Execute("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $this->products[$i]['qty']) . " where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'");

then the order is completed ok. Importand was string %f changed to %d

I hope it will help to others.

- Noface -

[Nellybongo]

I found solution.

When I changed in /includes/classes/order.php SQL command on row 670 from:

$db->Execute("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%f', $this->products[$i]['qty']) . " where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'");

to:

$db->Execute("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $this->products[$i]['qty']) . " where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'");

then the order is completed ok. Importand was string %f changed to %d

I hope it will help to others.

- Noface -

This Solution dont work for me, I have reinstalled and still not working, where is the patch to update my 1.3.0.1 to 1.3.0.3 ? can`t find it

Fresh install today..

[noface]

1.3.0.3? I am using 1.3.0.2. Two days ago I upgrade previous 1.2.6d. This solution ('%f' changed to '%d') is working with no error.

[Nellybongo]

Hello,

Sorry I am very new to this only installed the shop today, i mean 1.3.0.1 and what i mean to ask where do i upgrade to 1.3.0.2 then I can try your solution propely,

Kindest of Regards.