New Zenner
- Join Date:
- May 2006
- Posts:
- 24
- Plugin Contributions:
- 0
Database error when click on "Checkout"
Hi, I'm testing my web site and when I click on "Go to checkout" iget the error:
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]
I'm using version 1.3.0.
Please help - I'm lost!!
