1064 sql error after confirming order

[noface]

Here is ZIP with changed-only files:

http://prdownloads.sourceforge.net/z...y.zip?download

[Nellybongo]

Thanks I shall try it now,

with your solution stay online.

[Nellybongo]

No it still won`t work, I have pasted the code with macromedia,

it actually says on the front page of my shop this :-

Warning Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

I have checked the server information at it says this :-

Zen Cart 1.3.0.2
Database Patch Level: 1.3.0.1
v1.3.0.1 [2006-08-23 23:08:37] (Version Update 1.3.0->1.3.0.1)
v1.3.0.1 [2006-08-23 23:08:01] (Version Update 1.3.0->1.3.0.1)
v1.3.0.2 [2006-08-23 23:08:01] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0 [2006-08-23 20:53:01] (Fresh Installation)
v1.3.0 [2006-08-23 20:53:01] (Fresh Installation)

Any ideas ?

[noface]

During installation you update only files, not database. Try to run installation once more and when you will see possibility to upgrade ZenCart AND update database, click on UPDATE DATABASE. I hope, that's all.

But, I think there will be some other problem then '%f'/'%d' only. So, try to patch database. It is good step at all.

[DrByte]

Warning Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

Can you re-run the zc_install program and apply the patches for 1301-to-1302 again?

[Nellybongo]

Thanks DrByte,

I shall try this and let you know if it works.

Kind Regards.

[Nellybongo]

I tried a fresh install, and upgraded to 3.0.1.2

I made a new user and logged in , added 1 item to my cart, and here is my error when I go to the checkout,

1064 You have an error in your SQL syntax near '(zen_address_book ab left join zen_zones z on' 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 zen_customers c, (zen_address_book ab left join zen_zones z on (ab.entry_zone_id = z.zone_id) left join zen_countries co on (ab.entry_country_id = co.countries_id) ) where c.customers_id = '2' and ab.customers_id = '2' and c.customers_default_address_id = ab.address_book_id]

If you would like to see this working my dev site is
http://celticstudio.co.uk/zen

[DrByte]

what version of MySQL are you using?

[Nellybongo]

what version of MySQL are you using?

Mysql 3.23.56

Php Version 4.3.10

[Nellybongo]

Just to update you on this problem, I have download the new version and it works with the PHP and MYsql I am running at the moment. No problems and Excellent product.

Thanks to you all for you help.