Duplicating Problem

[Guest]

I was trying to duoplicate a product by selecting 'copy to' and then choosing duplicate as opposed to link and the following error

occurs:

 

1062 - Duplicate entry '0-82' for key 1

 

insert into products_to_categories (products_id, categories_id) values ('0', '82')

 

[TEP STOP]

 

 

What sort of problems would cause this?

[nvedia]

Its a mysql_insert_id problem which happens because there is referential integrity constraint on the products table.

In my opinion, you cannot duplicate a product in this way

[Guest]

Its a mysql_insert_id problem which happens because there is referential integrity constraint on the products table.

In my opinion, you cannot duplicate a product in this way

 

 

Is there a work around for this problem?

[nvedia]

Is there a work around for this problem?

 

Please do no create duplicate products in this way because table products, products_info etc are connected

You can remove this record from the product products_to_categorie and then everything should work fine

[Guest]

Please do no create duplicate products in this way because table products, products_info etc are connected

You can remove this record from the product products_to_categorie and then everything should work fine

 

 

So given that we would like to duplicate a product what is the best way to do this?

 

Also the store currently is working fine except we would like to duplicate some products.

[nvedia]

<<I was trying to duoplicate a product by selecting 'copy to' and then choosing duplicate as opposed to link and the following error>>>

Sorry I am not aware of this...

Where were you performing these steps?

[Guest]

<<I was trying to duoplicate a product by selecting 'copy to' and then choosing duplicate as opposed to link and the following error>>>

Sorry I am not aware of this...

Where were you performing these steps?

 

 

 

In administration->Catalog then going into any category and select a product within that category

 

upon selecting a product a few options appear on the right of the screen namely (Edit, Delete, Move and CopyTo)

 

By choosing CopyTo you then have a few more options appear:

 

Copy Method:

[ ] Link product

[ ] Duplicate product

 

Choosing duplicate product then selecting a category and then hitting 'copy' produces the error.