🐛 [TBC] Unlearning Axesmith causes Weaponsmith to disappear.

[Eonfluxx]

Bug Details

After obtaining [Weaponsmith], we want to learn [Master Axesmith]. Suppose we no longer wish to be [Master Axesmith] and want to switch specializations to another one. After unlearning [Master Axesmith], [Weaponsmith] also disappears after a relog. [Weaponsmith] should remain to be able to learn another specialization.

Steps to Reproduce

1. Learn Blacksmithing and level it up to 375.
2. Acquire Weaponsmith spell - .l 9787.
3. Save the character with .save - now we have the 9787 spell recorded in character_spell table.
4. Visit Kilram to learn Axesmithing - .go creat 42297.
5. Click on "Please teach me how to become an Axesmith."
6. Save the character.
7. Now the spell 9787 in character_spell has been replaced with 17041.
8. Unlearn Axesmithing at Kilram by clicking "I wish to unlearn Axesmithing."
9. Save the character again.
10. Now 17041 spell removed from database, but we still have the 9787 spell in book (it will be removed after relog, as it is no longer present in the database).

Expected behavior

[Weaponsmith] also disappears after a relog. [Weaponsmith] should remain to be able to learn another specialization.

Suggested Workaround

No response

Crash Log

No response

Core SHA1 Commit Hash

last

Database SHA1 Commit Hash

last

Operating System

win11

Client Version

2.4.3 (The Burning Crusade)

[AnonXS]

[Eonfluxx]

The Weaponsmith skill is still in book after Master Axesmith unlearn, but removed from DB (not actually removed, but replaced with other spell - read my first message). Logout your character after Master Axesmith unlearning, then log in and see that Weaponsmith is missed.