Thanks...

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

Thanks for your reply, but that didn't work. I have no idea how the address_book_id field got to be auto-increment...wait, I installed a CVS version first time 'round, and rolled back to MS1. 

But even with the mods I installed, etc. I was able to add more than one customer. None of the mods I use effected the address_book table at all.

This is driving me nuts, because I've got a full cart designed and ready to roll...

Here is a dump:

mysql>SHOW TABLE CREATE address_book;
| address_book | CREATE TABLE `address_book` (
  `customers_id` int(11) NOT NULL default '0',
  `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',
  `address_book_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`address_book_id`),
  KEY `idx_address_book_customers_id` (`customers_id`)
) TYPE=MyISAM |

JC = LOST~ :cry: