splinecl

I am having issues completing the quest "CLUCK!". select * from mangos0.quest_template q where q.entry=3861; It is being triggered by emoting "/chicken" repeatedly at chickens in Westfall. At some point the chicken becomes a quest giver. To complete the quest "CLUCK!" you need to have "Special Chicken Feed" in your inventory, which can be bought from "Farmer Saldean" in Westfall. select * from mangos0.item_template i where i.entry=11109; But for some reason it is not possible to complete the quest, even with the correct items in your inventory. I have attached a screenshot shoving the quest dialog and the item in the inventory.

When trying to turn in the quest "Ammo for Rumbleshot" it took a very long time, over a minute, of me standing around next to the quest turn in NPC "Hegnar Rumbleshot", before the golden quest "?" icon appeared over his head and I could turn in the quest. In the server log I saw this message at the time where I could finally turn in the quest: WORLD: Received opcode CMSG_QUESTGIVER_STATUS_QUERY - for Player Rune (Guid: 6) to Creature (Entry: 1243 Guid: 265) How come this update took so long? If I didn't know that this was actually the correct quest turn in NPC, I would probably just have run past him. Is there any way to tune how often this status query is done? I have attached a screenshot of my standing next to the NPC with the quest and quest item.

There are a bunch of collections of "Water Barrel" and "Food Crate" that spawn on top of each other. I believe the correct behaviour should be spawning as object pools instead. One instance of this issue was fixed in relation to this post: But there are multiple instance of this issue. # guid, id, map, position_x, position_y, position_z '30758', '3719', '0', '-9729.42', '656.299', '31.8338' '29275', '3658', '0', '-9729.42', '656.299', '31.8338' '32313', '3658', '0', '-9500.53', '81.368', '57.4601' '32754', '3719', '0', '-9500.53', '81.368', '57.4601' '30839', '3719', '0', '-9458.53', '8.58518', '56.9626' '30677', '3658', '0', '-9458.53', '8.58518', '56.9626' '30687', '3719', '0', '-9258.88', '355.379', '76.693' '29276', '3658', '0', '-9258.88', '355.379', '76.693' '10677', '3719', '0', '-5569.67', '-462.497', '402.397' '1462', '3658', '0', '-5569.67', '-462.497', '402.397' '29306', '3719', '0', '-5470.22', '-636.681', '393.521' '29609', '3658', '0', '-5470.22', '-636.681', '393.521' These can be found with the following query: SELECT go1.guid, go1.id, go1.map, go1.position_x, go1.position_y, go1.position_z FROM mangos0.gameobject go1 JOIN mangos0.gameobject go2 ON (go1.position_x = go2.position_x AND go1.position_y = go2.position_y AND go1.position_z = go2.position_z AND go1.guid <> go2.guid) WHERE go1.id IN (3658 , 3719) AND go2.id IN (3658 , 3719) order by go1.position_x;

During mangosd startup I noticed the following sql error in the log: 2018-09-23 20:57:23 ERROR:SQL: SELECT group_instance.leaderGuid, instance FROM group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL 2018-09-23 20:57:23 ERROR:query ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS' at line 1 I am runnig on MySQL 8.0. It seems like the table name "groups" is a reserved word in MySQL 8.0 so the query fails. https://forums.mysql.com/read.php?101,665004,665004 ( 'GROUPS', 'Reserved', 'added in 8.0' ), EDIT: Seeing the a similar issue here: 2018-09-23 20:57:24 Loading Spell Chain Data... 2018-09-23 20:57:24 ERROR:SQL: SELECT spell_id, prev_spell, first_spell, rank, req_spell FROM spell_chain 2018-09-23 20:57:24 ERROR:query ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', req_spell FROM spell_chain' at line 1 The word "rank" is also reserved in MySQL 8.0 ( 'RANK', 'Reserved', 'added in 8.0' ), This query seems to work if you use an alias for the table name SELECT spell_id, prev_spell, first_spell, sc.rank, req_spell FROM spell_chain as sc