Missing feature data after adding product accessories

[BMCS]

Hello all. My first time posting and I hope I can get some assistance here.

 

PS1.5.4.1 with non default Theme.

I have imported 50 products to a test site.Every product has 4 features and all imports OK.

 

After adding an Accessory to 1 product it appears to delete 1 feature from random product. On Smarty console the random product feature shows a NULL value.

 

This has happened in MANY tests. Delete and add products, add accessory, missing features.

 

Unsure what entries should be in Database tables but this shows-

ps_product_feature = 200 entries

ps_feature_value = 94 entries (missing feature entry for product)

 

I checked and rechecked Product import CSV..imports OK. Removed unwanted Modules, cleared cache, manually removed cache items. Restored database from within phpMyadmin.

Force compile ON, cache OFF, CCC OFF.

 

I thought about Database, core files or theme file or languages problem. What files are used to get update Accessories and would it affect Features. I shall keep investigating.

 

If anyone can help or suggest I would be very happy.

 

UPDATE:

Adding Product accessory deleted a record in ps_feature_value database table.

Feature is removed from Product as it retrieved as NULL value since the DB entry is not there!

Edited July 24, 2013 by kred59 (see edit history)

[BMCS]

UPDATE2. Continuing saga..love talking to myself.

 

I re did all my Product import data removing ' apostrophes and & ampersands etc.

Thought I had solved it. Added accessories and it seems all Features are still OK in all products.

 

Wrong! Checked some products and now Features still showing but BO some have been moved from Pre-Defined to Custom automatically as image. Is this normal, I assume not.

 

Does this suggest a corrupt installation, database or just code error. Anyone please.

[seanloo]

If you import products csv with pre-defined values, product feature value will be removed if you manual edit the product detail (even click Save without edit anything). Don't know how to debug it until now, so I have to set product features in customised values.

 

Refer http://www.prestashop.com/forums/topic/252700-product-features-suddenly-missing-please-help/