DB/NPC: Warosh the Redeemed

[TQPS]

Description

Completed the quest Urok Doomhowl yesterday and noticed the following lines spamming in the DBErrorsl.log file.

CreatureTextMgr: Could not find Text for Creature Warosh the Redeemed (Entry 10800, spawnId 17) in 'creature_text' table. Ignoring.

Expected behaviour

Warosh the Redeemed should say the lines listed here under "completion".

Disclaimer: I was not aware of any issue doing the quest (other than the large number of spawns produced) but was unfamiliar with the quest to notice what was expected during handin.

Steps to reproduce the problem

1. Go to LBRS
2. Accept Warosh's quest Urok Doomhowl
3. Go complete the objective and return to him
4. Hand in quest and he changes into Warosh The Redeemed
5. Check DBErrors.log and errors appear

Branch

3.3.5

TC rev. hash/commit

TrinityCore rev. 87a4bc3 2021-07-23 00:12:58 +0300 (3.3.5 branch) (Win64, RelWithDebInfo, Static)

Operating system

Windows 7 x64

Custom changes

Trickerer's Bots

[dr-j]

Well texts seem to exist for me

CreatureID  - GroupID  - ID  - Text  - Type  - Language  - Probability  - Emote  - Duration  - Sound  - BroadcastTextId  - TextRange  - comment
10800  - 0  - 0  - %s whimpers.  - 16  - 0  - 100  - 0  - 0  - 0  - 6101  - 0  - Warosh The Redeemed
10800  - 0  - 1  - %s grumbles.  - 16  - 0  - 100  - 0  - 0  - 0  - 6102  - 0  - Warosh The Redeemed
10800  - 0  - 2  - %s snorts.  - 16  - 0  - 100  - 0  - 0  - 0  - 6103  - 0  - Warosh The Redeemed
10800  - 0  - 3  - %s cries.  - 16  - 0  - 100  - 0  - 0  - 0  - 6104  - 0  - Warosh The Redeemed
10800  - 1  - 0  - Hahah!  Revenge is mine!  - 14  - 0  - 100  - 0  - 0  - 0  - 6105  - 0  - Warosh The Redeemed
10800  - 2  - 0  - Rawww!  Urok is dead!!  Hahah!!  - 14  - 0  - 100  - 0  - 0  - 0  - 6126  - 0  - Warosh The Redeemed
10800  - 3  - 0  - Revenge is mine!  - 12  - 0  - 100  - 0  - 0  - 0  - 6127  - 0  - Warosh The Redeemed

[CraftedRO]

Today I tried to convert @dr-j like this but for some reason is still not called after completing the quest (doesn't appear) , but at least dberrors are gone.

-- / * Affected lines: 14 Records found: 0 Warnings: 0 Duration of 2 queries: 0.000 sec. * /
DELETE FROM `creature_text` WHERE `CreatureID`=10800 AND `Probability`=100;
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(10800, 0, 0, '%s whimpers.', 16, 0, 100, 0, 0, 0, 6101, 0, 'Warosh The Redeemed'),
(10800, 0, 1, '%s grumbles.', 16, 0, 100, 0, 0, 0, 6102, 0, 'Warosh The Redeemed'),
(10800, 0, 2, '%s snorts.', 16, 0, 100, 0, 0, 0, 6103, 0, 'Warosh The Redeemed'),
(10800, 0, 3, '%s cries.', 16, 0, 100, 0, 0, 0, 6104, 0, 'Warosh The Redeemed'),
(10800, 1, 0, 'Hahah!  Revenge is mine!', 14, 0, 100, 0, 0, 0, 6105, 0, 'Warosh The Redeemed'),
(10800, 2, 0, 'Rawww!  Urok is dead!!  Hahah!!', 14, 0, 100, 0, 0, 0, 6126, 0, 'Warosh The Redeemed'),
(10800, 3, 0, 'Revenge is mine!', 12, 0, 100, 0, 0, 0, 6127, 0, 'Warosh The Redeemed');