Looks like...

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=228068#228068
----------------------------------------------------------------

That did it! I took 2.2-MS1 and clipped the sql statement reguarding the address_book table. It seems that in MS1 the default structure of the table was this:

| address_book | CREATE TABLE `address_book` (
  `customers_id` int(11) NOT NULL default '0',
  [color=red]`address_book_id` int(11) NOT NULL default '1',[/color]
  `entry_gender` char(1) NOT NULL default '',
  `entry_company` varchar(32) default NULL,
  `entry_firstname` varchar(32) NOT NULL default '',
  `entry_lastname` varchar(32) NOT NULL default '',
  `entry_street_address` varchar(64) NOT NULL default '',
  `entry_suburb` varchar(32) default NULL,
  `entry_postcode` varchar(10) NOT NULL default '',
  `entry_city` varchar(32) NOT NULL default '',
  `entry_state` varchar(32) default NULL,
  `entry_country_id` int(11) NOT NULL default '0',
  `entry_zone_id` int(11) NOT NULL default '0',
   [color=red]PRIMARY KEY  (`address_book_id`,`customers_id`)[/color]
) TYPE=MyISAM |

HUGE difference from what mine was...go figure.

Thanks for getting my brain in gear!

JC