When the check out button is clicked, the error message appears:
1064 You have an error in your SQL syntax near '(address_book ab left join zones z on (ab.ent' 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 = '3' and ab.customers_id = '3' and c.customers_default_address_id = ab.address_book_id]

I saw some posting regarding 1064 error, but their conditions are different from mine and not sure it's ok to follow one of their responses or not since I'm not familiar with SQL and PHP at all.

My ZenCart version is 1.3.0

I don't know why this is happening and how to fix. Please help.

Anyone have any information on this? I am having the same problem. This seems rediculous since I just downloaded, installed and set up everything without modifying any files.

I found somebody else had the same issue in the forum. He/She tried things suggested, but any of them don't seem to be real solutions since their problems remained after trying them. I installed the patches to 1.3.0.2. It didn't solve the problem, but showed another clue: the MySQL on the server is not proper to ZenCart. The MySQL is pre-installed by the hosting service. Its version is 3.23.56. When I installed ZenCart, there was a note, the program was tested with MySQL 5. I assume the database does not collaborate with ZenCart. I didn't know the version of MySQL until that point because the hosting company doesn't say which version they have in their feature list. Since I'm not technical to work around database, I'm going to change the hosting service who actually support ZenCart. I don't have time to play around with this since the site is for my client. But, if this is your site, and have some time and technical knowledge, you might be able to find another solution. Good luck.

delmarva:

Anyone have any information on this? I am having the same problem. This seems rediculous since I just downloaded, installed and set up everything without modifying any files.
What was the name of the file you downloaded?

http://prdownloads.sourceforge.net/zencart/zen-cart-v1.3.0-full-fileset.zip?download

Then I uploaded the patch:
http://sourceforge.net/project/showfiles.php?group_id=83781&package_id=171544&release_id=412075
and uploaded the files, replacing the originals. Ran the setup again and changed permissions. Same error when trying to check out.

1064 You have an error in your SQL syntax near '(address_book ab left join zones z on (ab.ent' 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]

I am using a dedicated server with godaddy.com
I am using mysql version 3.23.58
I also have a vbulletin forum which is not linked

I would hate to have to go to a "pay for" solution. All help is appreciated.

What is the exact name on the Zip that you downloaded?

I did the upgrade again and the problem seems to be solved. The zip file was zen-cart-v1.3.0.1-changed_files_only.zip

Now, how to change the "Sales Message Goes Here" :blink:

Thanks for the help.

Note: the current version of Zen Cart is v1.3.0.2 ... :cry:

Might want to do one more upgrade and get all the bugs out in one night ... :smile:

Gotcha. I'll do that now. Thanks... I think I tried it and ran into a PHP problem, but I'll let you know in a minute.

PHP Session.Save_Path = /var/lib/php/session -->Unwriteable

Here it is...?

delmarva:

PHP Session.Save_Path = /var/lib/php/session -->Unwriteable

Here it is...?

That's an orange-colored alert, right? You can ignore it. PHP's setting for that is an informational note only.

I tried updating them twice. It seems to have fixed the problem, but now when I try to update to the latest patch, I get this message:

1062 Duplicate entry 'Administrator' for key 2
in:
[INSERT INTO query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');]

http://www.zen-cart.com/forum/showthread.php?p=221548#post221548