fizisition Posted January 29, 2007 Share Posted January 29, 2007 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' [TEP STOP] Link to comment Share on other sites More sharing options...
fizisition Posted January 30, 2007 Author Share Posted January 30, 2007 Can anyone please help. Link to comment Share on other sites More sharing options...
fizisition Posted February 5, 2007 Author Share Posted February 5, 2007 any ideas here people :-" Link to comment Share on other sites More sharing options...
fizisition Posted March 23, 2007 Author Share Posted March 23, 2007 I still am unable to figure this problem out. :-" Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.