Core/QuestOfferReward: Out of range value for column 'Emote2', 'Emote3', 'Emote4' in DB
Closed this issue · 0 comments
osleyder85 commented
TrinityCore - WowPacketParser
Detected build: V9_2_5_44232
Detected locale: enUS
Targeted database: Shadowlands
Wrong emotes are generated in the output sql file. When executing the SQL query in the Database it shows the following error:
-- Lazy Peons
UPDATE `quest_offer_reward` SET `Emote1`=4, `Emote2`=4294967295, `Emote3`=4294967295, `Emote4`=4294967295, `VerifiedBuild`=44232 WHERE `ID`=25136
> 1264 - Out of range value for column 'Emote2' at row 1
> Time: 0s
SQL query:
UPDATE `quest_offer_reward` SET `Emote1`=4, `Emote2`=4294967295, `Emote3`=4294967295, `Emote4`=4294967295, `VerifiedBuild`=44232 WHERE `ID`=25136; -- Galgar's Cactus Apple Surprise
ServerToClient: SMSG_QUEST_GIVER_OFFER_REWARD_MESSAGE (0x2A94) Length: 499 ConnIdx: 0 Time: 06/21/2022 11:13:05.722 Number: 23714
QuestGiverGUID: Full: 0x203D740020099100000007000031D618 Creature/0 R3933/S7 Map: 1 Entry: 9796 (Galgar) Low: 3266072
QuestGiverCreatureID: 9796
QuestID: 25136
[0] QuestFlags: 524288
[1] QuestFlags: 0
SuggestedPartyMembers: 0
EmotesCount: 4
Type: 4
Delay: 0
Type: -1
Delay: 0
Type: -1
Delay: 0
Type: -1
Delay: 0
AutoLaunched: False
Unused: False
(QuestRewards) ChoiceItemCount: 0
(QuestRewards) ItemCount: 1
(QuestRewards) [0] ID: 11584
(QuestRewards) [0] Quantity: 10
(QuestRewards) [1] ID: 0
(QuestRewards) [1] Quantity: 0
(QuestRewards) [2] ID: 0
(QuestRewards) [2] Quantity: 0
(QuestRewards) [3] ID: 0
(QuestRewards) [3] Quantity: 0
(QuestRewards) RewardMoney: 360
(QuestRewards) XP: 900
(QuestRewards) ArtifactXP: 0
(QuestRewards) ArtifactCategoryID: 0
(QuestRewards) Honor: 0
(QuestRewards) Title: 0
(QuestRewards) FactionFlags: 1
(QuestRewards) [0] FactionID: 76
(QuestRewards) [0] FactionValue: 7
(QuestRewards) [0] FactionOverride: 0
(QuestRewards) [0] FactionCapIn: 7
(QuestRewards) [1] FactionID: 0
(QuestRewards) [1] FactionValue: 0
(QuestRewards) [1] FactionOverride: 0
(QuestRewards) [1] FactionCapIn: 7
(QuestRewards) [2] FactionID: 0
(QuestRewards) [2] FactionValue: 0
(QuestRewards) [2] FactionOverride: 0
(QuestRewards) [2] FactionCapIn: 7
(QuestRewards) [3] FactionID: 0
(QuestRewards) [3] FactionValue: 0
(QuestRewards) [3] FactionOverride: 0
(QuestRewards) [3] FactionCapIn: 7
(QuestRewards) [4] FactionID: 0
(QuestRewards) [4] FactionValue: 0
(QuestRewards) [4] FactionOverride: 0
(QuestRewards) [4] FactionCapIn: 7
(QuestRewards) [0] SpellCompletionDisplayID: 0
(QuestRewards) [1] SpellCompletionDisplayID: 0
(QuestRewards) [2] SpellCompletionDisplayID: 0
(QuestRewards) SpellCompletionID: 0
(QuestRewards) [0] CurrencyID: 0
(QuestRewards) [0] CurrencyQty: 0
(QuestRewards) [1] CurrencyID: 0
(QuestRewards) [1] CurrencyQty: 0
(QuestRewards) [2] CurrencyID: 0
(QuestRewards) [2] CurrencyQty: 0
(QuestRewards) [3] CurrencyID: 0
(QuestRewards) [3] CurrencyQty: 0
(QuestRewards) SkillLineID: 0
(QuestRewards) NumSkillUps: 0
(QuestRewards) TreasurePickerID: 0
(QuestRewards) (ItemChoiceData) [0] LootItemType: 0 (Item)
(QuestRewards) (ItemChoiceData) [0] ItemID: 0 (0)
(QuestRewards) (ItemChoiceData) [0] HasItemBonus: False
(QuestRewards) (ItemChoiceData) [0] Quantity: 0
(QuestRewards) (ItemChoiceData) [1] LootItemType: 0 (Item)
(QuestRewards) (ItemChoiceData) [1] ItemID: 0 (0)
(QuestRewards) (ItemChoiceData) [1] HasItemBonus: False
(QuestRewards) (ItemChoiceData) [1] Quantity: 0
(QuestRewards) (ItemChoiceData) [2] LootItemType: 0 (Item)
(QuestRewards) (ItemChoiceData) [2] ItemID: 0 (0)
(QuestRewards) (ItemChoiceData) [2] HasItemBonus: False
(QuestRewards) (ItemChoiceData) [2] Quantity: 0
(QuestRewards) (ItemChoiceData) [3] LootItemType: 0 (Item)
(QuestRewards) (ItemChoiceData) [3] ItemID: 0 (0)
(QuestRewards) (ItemChoiceData) [3] HasItemBonus: False
(QuestRewards) (ItemChoiceData) [3] Quantity: 0
(QuestRewards) (ItemChoiceData) [4] LootItemType: 0 (Item)
(QuestRewards) (ItemChoiceData) [4] ItemID: 0 (0)
(QuestRewards) (ItemChoiceData) [4] HasItemBonus: False
(QuestRewards) (ItemChoiceData) [4] Quantity: 0
(QuestRewards) (ItemChoiceData) [5] LootItemType: 0 (Item)
(QuestRewards) (ItemChoiceData) [5] ItemID: 0 (0)
(QuestRewards) (ItemChoiceData) [5] HasItemBonus: False
(QuestRewards) (ItemChoiceData) [5] Quantity: 0
(QuestRewards) IsBoostSpell: False
QuestPackageID: 0
PortraitGiver: 0
PortraitGiverMount: 0
PortraitGiverModelSceneID: 0
PortraitTurnIn: 0
QuestTitle: Galgar's Cactus Apple Surprise
RewardText: Wonderful, $n! As promised, here is your cactus apple surprise plus a little something extra.
PortraitGiverText:
PortraitGiverName:
PortraitTurnInText:
PortraitTurnInName: