Duplicate Database Product Entries

[CC]

Hey p33ps

 

Just a quickie...

 

Has anyone had the problem of duplicate product entries in the database when you add a product?

In fact when I did the original install the database duplicated everything on the initial install.

 

This is the first time I have used the latest snapshot, so just wondering if anyone has had this.

 

If so could you let me know the cure please?

 

ta all.

 

CC.

[jficarra]

CC,

 

There were 2 people that I can recall who were having duplicate entry problems but with different areas than you. One person was having a problem when adding address book entries (didn't happen all the time, only some of the time).

 

The other person was having duplicate entry errors when he was copying a product from one category to another.

 

Solution to my knowledge is still needed. I had suggested to them to use the latest snapshot, but that didn't work. I've been *lightly* testing the 11/10/2002 snapshot and haven't had any problems like this.

 

-Jim

[Pixel]

When you start messing around with the database and flush/empty fields things get out of wack.

Mainly the problem seems to happen when you flush a certain table and not another that contains the same customer_id.

 

Try this:

 

Flush/empty the following tables (please back up first)

Customers

Address_book

 

And any other tables that contain the customer_id

 

What should happen then is that when a new customer registers the customer_id will be in sink with all other customer_ids that exist in other tables.

 

I think what happens is that deleting customers from admin does not appear to delete address_book entries for that customer as well ? (may work in the majority of cases depending on the host ?)

Best to go into the database and flush/empty/delete from there.

 

It seemed to work for me, so hope this helps.

Rob