bhawmik Posted January 29, 2004 Share Posted January 29, 2004 The primary shipping (or default) address field is blank in both check-out page as well as account page. However, in address_book.php page, the "address book entries" box is showing the address correctly. How do I fix this problem? I have upgraded from 2.2 CVS to 2.2MS 2. I have also gone thru the database upgrade step. Thanks Link to comment Share on other sites More sharing options...
guntersammet Posted January 29, 2004 Share Posted January 29, 2004 Did you change the address book layout and modified the customers table to have the new id's as default id's? That should be the cause. I haven't checked the update script, so I am not sure if this is included. HTH Gunter Link to comment Share on other sites More sharing options...
bhawmik Posted January 29, 2004 Author Share Posted January 29, 2004 Hi Gunter, How do I do this (change address book layout)? When I click the edit button on the address book page and then check the primary address, it works fine. But that is not a good solution for cutomers. Thanks Sudipta Link to comment Share on other sites More sharing options...
Guest Posted February 10, 2004 Share Posted February 10, 2004 Did you change the address book layout and modified the customers table to have the new id's as default id's? That should be the cause. I haven't checked the update script, so I am not sure if this is included. HTH Gunter Could you explain more about what you mean here? How do I set the new id's as the default id's? Link to comment Share on other sites More sharing options...
guntersammet Posted February 10, 2004 Share Posted February 10, 2004 The address book table layout changed from ms1 to ms2: http://cvs.sourceforge.net/viewcvs.py/tep/...r1=1.84&r2=1.71 Here a way how you can update that: -BACKUP THE WHOLE DB!!! -Export the address book table inot csv and open in Excel or your favourite spread sheet program. Insert a column at the beginning and number it 1,2,3,...). Delete the former address_book_id column (should be the 3rd column now [usually contains numbers between 1 and 5]). Drop the old address book table and create a new one with the new structure. Upload the file. -Export the customers table and open in Excel or your fssp. You now need to enter the matching number from the first column of the address book table into the customers_default_address_book_id column. Once you have done that, upload it again. HTH Gunter 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.