duplicate product_option_value_to_product_option_id values??

[solardirect]

Somehow my table product_option_value_to_product_option_id values has duplicate values but of course each has it's own unique ID # in the key.

 

i.e.

ID, product_option, product_option_value

45, 8, 45

62, 8, 45

 

It seems that no actual products are using the extra entries; however, my concern is -- can I just delete them from the DB table? The duplicate entries show up in the admin Attributes manager section. I do not see any function for this table product_option_value_to_product_option_id as it does not appear as a field any where else in the DB, unless it is referenced in the code somewhere; does it serve any purpose? Is it safe to delete these extra entries without reprecussions?

 

I am using a snapshot from 5/18/03.

[solardirect]

Hello, anyone??????????????? Surely someone has an answer.

[Guest]

I believe it should be safe to delete the extra entries, however, I recommend that you backup your database, make the deletions, and then thoroughly test to make sure everything is ok. If it's not you can revert to your backed-up db.

 

Last time I looked at the table in any detail (which was easily 6 months ago or more), the product_option_value_to_product_option_id table was only used in contributions and not by default oscommerce.

 

The table identifies which option values work with which option types. For example it says the option type color has the possible values blue, green, red.

 

Contributions that provide a nice interface for setting up product attributes would likely use this table. For example, the New Attribute Manager contribution uses this table.

 

Even if you are using contributions that use the table, I doubt you'll run into any problems if you delete the duplicate rows.