Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Alternate Shipping Address Stopped Working


Recommended Posts

The seperate ship to address quit working for EXISTING customers only. If you create an account you can ship to an alternate address. However, if you are an existing customer with an alternate ship to address on file when the reach the shipping method page and click change address button you get this error message. The address is still in the DB, just not there on the shipping address page. Here's the msg.




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 'entry_country_id as country_id from address_book where customers_id = '1373'' at line 1


select address_book_id, entry_firstname as firstname, entry_lastname as lastname, entry_company as company, entry_street_address as street_address, entry_suburb as suburb, entry_city as city, entry_postcode as postcode, entry_state as state, entry_zone_id as zone_id, entry_residence_id as residence_id entry_country_id as country_id from address_book where customers_id = '1373'



Link to comment
Share on other sites

  • 1 month later...


This topic is now archived and is closed to further replies.

  • Create New...