Hello,

I have enabled the auto sku generate for a certain product type and am using the node title token. After I create a product, if I delete it and then recreate a new product with the same title, I get an error message saying this is a duplicate entry in the database. Shouldn't the auto generated sku delete when the product is deleted?

Am I missing a something when I delete a product?

Thank you,
Kim

Comments

fossle’s picture

fossle commented

I looked at the database and if a product is deleted and then recreated, the auto sku keeps the NID of the deleted node, not the new one. I also tried using the title-raw but this didn't seem to make a difference.

willvincent’s picture

willvincent commented
Category: support » bug

Yes, I believe this is a bug.. I think it's a bit more broad than this though. I think the problem is that non of the data generated by the power tools module is actually removed from the database when a product is deleted.

I'll look into it as soon as I can.

willvincent’s picture

willvincent commented
Component: Miscellaneous » Code
willvincent’s picture

willvincent commented
Status: Active » Postponed
willvincent’s picture

willvincent commented
Status: Postponed » Closed (cannot reproduce)

This is most likely due to the previous improper usage of the non-existent db_next_id() function call.. that has been changed in the latest release 6.x-1.12.

sean porter’s picture

sean porter commented

I'm still getting this issue using 6x-1.2

Cheers,
Sean