1064 - You have an error in your SQL syntax;

[Guest]

I am getting the following error when trying to checkout. My server was upgraded to Mysql 5

 

http://www.golftape.com/checkout_shipping.php

 

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 ab.customers_id = '49' and ab.address_book_id = '51'' at line 1

 

select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id, ab.entry_state from ((address_book ab) left join zones z on (ab.entry_zone_id = z.zone_id) left join countries c on (ab.entry_country_id = c.countries_id) where ab.customers_id = '49' and ab.address_book_id = '51'

 

 

Thanks

[arietis]

 

it looks to me like you have mismatched parenthesis. where you have ((address_book ab) change it to (address_book ab) and see if that helps.