Cannot delete feature from product

[pawelszulc]

Im in product backoffice and editing product but when i click remove feature and save product, after refresh feature exist. whether it is possible to check how the data from the product is saved?

[teemui]

Hi,

I have the same problem at 1.7.7.1. I cant remove the features, if I delete the feature and go away, then come back and it's there again. and if I delete the features they usually duplicate so theres a big list and I can't delete them. It's driving me nuts.

 

 

[endriu107]

This is knowed bug, it happens when you fill input with custom value but not choose from select any feature name. Only way to fix it is clear those data in database.

[teemui]

10 minutes ago, endriu107 said:

This is knowed bug, it happens when you fill input with custom value but not choose from select any feature name. Only way to fix it is clear those data in database.

Ok,  thank you for the info. How can I remove the data from database?

 

[endriu107]

You need to login to your database and edit tables:

PREFIX_feature_product - delete all row where id_feature is 0 - also remember id_feature_value all deleted rows you will need this later

PREFIX_feature_value_lang - delete all row where id_feature_value is same like above

PREFIX_feature_value - delete all row where id_feature is 0

 

It is good practice to create copy database before editing, in case of trouble you wil be able to restore it.

 

[teemui]

Thank you, got them removed!

[Tos85]

Hello,

I need to remove custom features from a single product. Can I proceed like this?

DELETE FROM PREFIX_feature_value_lang
WHERE id_feature_value IN (
    SELECT id_feature_value
    FROM pm_feature_product
    WHERE id_product = ID_PRODUCT
);

DELETE FROM PREFIX_feature_value
WHERE id_feature_value IN (
    SELECT id_feature_value
    FROM pm_feature_product
    WHERE id_product = ID_PRODUCT
);

DELETE FROM PREFIX_feature_product
WHERE id_product = ID_PRODUCT;

Best,