BUG?: Create account works, but DB INSERT fails!?

This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=186701#186701
----------------------------------------------------------------

Hey all,

I really have no clue what's going on with my shop, but it's getting very ignoring by now.

I will describe the situation what happens below in more detail, but in short: a user creates an account, and is logged in at that moment. But his data is NEVER written in the db!

[b]Issue:[/b]
Two new users would like to create an account and then buy something. 
Person A is first and creates an account succesful and his data is written to [address_book] and [customers]. No problem with Person A. But then, Person B arrives and also creates an account, and goes shopping. He does a checkout and pays. Person A receives a message that what Person B bought! However, the CC from Person B has payed for it. (Which is correct). Person B never receives an email.

What happened? Well, person A will get the address from person A and Person B never actually appears in the DB [customers]. 

[b]Snapshot example of how the dbase looks afterwards[/b]
[customers]
customerID=200, NAME=Person A

[address_book]
customerID=200, address_book_id=1, name=Person A
customerID=200, address_book_id=2, name=Person B


I had a look at the create_account_process.php and replaced customer_id=tep_db_insert_id() with a new query to look up for the email that the person just had given in and then get the id. I thought that in this way it never could mix up.. I was wrong! I leaves me puzzled and I have NO clue, except that the MySQL dbase is buggy... But I doubt that.

Anyone who had a similar error or know the solution to this?

Thanks!!!!

Joeri