I installed version 1.3.0.1 (Not completely sure about the version. I deleted the zip file and when I click on check for updates nothing happens.)
I was testing the cart, and I got the following error page after creating a login and proceeding to checkout...
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]
Any ideas?
Thank you for any help you can give me,
Gigi
Bookmarks