I have a website running, where the customer last weekend entered over 400 products but unfortently one of the products throws and error when i try to edit it in ucommerce backend, giving me a error on a property called show in carrousel.
It is one product out of meany that failed, but i cant enter the product so i cant delete it. and honestly it feels very very wrong to start delete products directly from the database due to all the relations in there.
Could i just delete all the Product Properties from uCommerce_ProductProperty where productId = myProductId ??
This issue have been fixed in a later version of uCommerce. I think it was some threading issue. Nevertheless. There at least two ways to fix it. You are mentioning one yourself. You can remove all property values for the one product which are causing the exception or you can try to find the specific property value. Depending on how many property fields you have I would try to find the exact property value causing this.
I know I have had the sql statement somewhere but I'm not sure whether I have lost it. I will try to find it.
Multiple controls with the same ID
I have a website running, where the customer last weekend entered over 400 products but unfortently one of the products throws and error when i try to edit it in ucommerce backend, giving me a error on a property called show in carrousel.
It is one product out of meany that failed, but i cant enter the product so i cant delete it. and honestly it feels very very wrong to start delete products directly from the database due to all the relations in there.
Could i just delete all the Product Properties from uCommerce_ProductProperty where productId = myProductId ??
And btw how did this happen ???
i can inform that i can see the product on the frontend without any errors
Hi Troels,
This issue have been fixed in a later version of uCommerce. I think it was some threading issue. Nevertheless. There at least two ways to fix it. You are mentioning one yourself. You can remove all property values for the one product which are causing the exception or you can try to find the specific property value. Depending on how many property fields you have I would try to find the exact property value causing this.
I know I have had the sql statement somewhere but I'm not sure whether I have lost it. I will try to find it.
Best regards Martin
is working on a reply...