Product Attributes Double When Edited

[usnswcc]

This is horrible. I have about one hundred attributes and about 50 items attached to certain attributes in my store. I went into edit a color attribute from Neon Yellow to N.Yellow and it doubled up. So now there is

 

ID 148 N.Yellow

ID 148 N.Yellow

 

Then when I add a new product and I select soem colors then view how it came out there are totally different colors selected and most of them are not the ones I selected. I guess since it doubled up it now skips. Does anyone know how to fix this? I edited about 5 colors and they are all doubled up so you can imagine how screwed up it is.

[Guest]

backup the db table the edit it mannually in the sql file then reupload the modified you have your tables lined up wrong when you deleted an attribute from a product it didn't release the att id from the product so now you get duplicates.

 

This is horrible. I have about one hundred attributes and about 50 items attached to certain attributes in my store. I went into edit a color attribute from Neon Yellow to N.Yellow and it doubled up. So now there is

 

ID 148 N.Yellow

ID 148 N.Yellow

 

Then when I add a new product and I select soem colors then view how it came out there are totally different colors selected and most of them are not the ones I selected. I guess since it doubled up it now skips. Does anyone know how to fix this? I edited about 5 colors and they are all doubled up so you can imagine how screwed up it is.