Tweet
I'm going to use my great psychic powers to deduce the problem. (In other words, I'm taking a shot in the dark, completely at random! 
)
The simplest solution I can think of that fits all the facts is that somehow the primary key of one of your tables (probably the recipes table, as discussed below) got renumbered, but the links to that key in the favorites and learned recipes tables weren't updated to point to the new values.
I'm guessing you have three (relevant) tables; one for all items that show up in the UI, one for items saved as favorites, and one for recipes. In the favorites table, you have a pointer stored that links to that item's recipe. With the last patch, I'm guessing the order of the recipes got shuffled around in the database, and their primary key in the recipes table got renumbered for whatever reason. The links from the items table were updated to point to the right recipe, but my guess is that the pointers in the favorites table were never updated. Hence, the links from the favorite items table still points to "an" entry in the recipes table; it's just not pointing to the "right" recipe for the favorite saved. This explains why you get an incorrect recipe.
When you search for a recipe instead of using the one in your favorites, it has to pull the item from the items table. Since the recipe pointers there are correct, you get the right recipe that way.
That's why deleting and re-adding the recipes works -- you get rid of the incorrect entry in the favorites table and replace it with the working one from the items table.
The issue of the vanishing learned recipes is more puzzling. I too had this problem happen. I did some arctic wyvern masks before the most recent patch and I learned the recipe. After the patch, I had to relearn that same recipe before I could make more masks.
I'm going to make another wild, speculative guess here. The renumbering of the the items in the recipes table also caused your learned list to go wonky. Although the reference to the item in the learned items table still points to "something," it no longer points to the correct recipe. Hence, when you re-learn it, a new entry is made, this time pointing to the new ID of the recipe you're learning.
Hope this helps you out.
)The simplest solution I can think of that fits all the facts is that somehow the primary key of one of your tables (probably the recipes table, as discussed below) got renumbered, but the links to that key in the favorites and learned recipes tables weren't updated to point to the new values.
I'm guessing you have three (relevant) tables; one for all items that show up in the UI, one for items saved as favorites, and one for recipes. In the favorites table, you have a pointer stored that links to that item's recipe. With the last patch, I'm guessing the order of the recipes got shuffled around in the database, and their primary key in the recipes table got renumbered for whatever reason. The links from the items table were updated to point to the right recipe, but my guess is that the pointers in the favorites table were never updated. Hence, the links from the favorite items table still points to "an" entry in the recipes table; it's just not pointing to the "right" recipe for the favorite saved. This explains why you get an incorrect recipe.
When you search for a recipe instead of using the one in your favorites, it has to pull the item from the items table. Since the recipe pointers there are correct, you get the right recipe that way.
That's why deleting and re-adding the recipes works -- you get rid of the incorrect entry in the favorites table and replace it with the working one from the items table.
The issue of the vanishing learned recipes is more puzzling. I too had this problem happen. I did some arctic wyvern masks before the most recent patch and I learned the recipe. After the patch, I had to relearn that same recipe before I could make more masks.
I'm going to make another wild, speculative guess here. The renumbering of the the items in the recipes table also caused your learned list to go wonky. Although the reference to the item in the learned items table still points to "something," it no longer points to the correct recipe. Hence, when you re-learn it, a new entry is made, this time pointing to the new ID of the recipe you're learning.
Hope this helps you out.
Comment