This is my first time asking a question on the forum whereas I've found many answers before I haven't been able to find an answer to the following:
I am working for an online store and have been working with configurable products, creating attributes and so on. The problem came up when I had created an attribute for a product and everything was fine until I deleted the attribute before disassociating it from the product itself. Now I have quite a few products that are crashing the store when I enable them as the old attribute code is still being associated with these products.
I was able to find on Stack that this is what is causing it and have found the errant attribute code. I tried recreating the old attribute but obviously it assigns a new code.
I used Magento store Manager CustomSQL to discover the attribute code but it wont let me change anything or delete.
My question: How can I delete the old attribute code from the database?