New Zenner
- Join Date:
- Jun 2006
- Posts:
- 8
- Plugin Contributions:
- 0
[DONE] Checkout_shipping problem -- user error
Not sure if this is a bug or what. I was trying to run a test purchase on my store to make sure everything is functioning properly before going live sometime next week and when i went to check out, this was the error that i got:
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]
Any suggestions?
