PDA

View Full Version : TrinityCore Custom quest bug



q8rakan
10-13-2016, 01:20 AM
hello, i am having problem with my custom quests the problem is when i take the quest that requires me to get items + killing boss ita buggs out when you relog or put the item for the quest in bank when i do that i couldnt complete the quest its shows me in questlog that the quest is complete but the npc shows me gray question mark any solution for that ..?

Vitrex
10-13-2016, 07:51 AM
I heard about this bug in old old core versions , can you explain how do you create your custom quest and how you handle it? maybe you're using some custom C++ scripts for that ?
explain more in depth.
Thanks.

q8rakan
10-13-2016, 02:57 PM
I heard about this bug in old old core versions , can you explain how do you create your custom quest and how you handle it? maybe you're using some custom C++ scripts for that ?
explain more in depth.
Thanks.

I use emudevs sql generation to create my quests and nope i dont use any C++ script for the quest

Vitrex
10-13-2016, 06:49 PM
What rev of core you are using at the moment?
Are you using official TC world database , cusomized, own etc. There can be a lot of reasons you occur this problem.

q8rakan
10-13-2016, 10:54 PM
What rev of core you are using at the moment?
Are you using official TC world database , cusomized, own etc. There can be a lot of reasons you occur this problem.

TrinityCore rev. 7c25f3cffd0c+ and yea TC world database TDB 335.61

q8rakan
10-21-2016, 01:32 AM
still having the problem anyone get a solution ?

Sylica
10-21-2016, 02:13 AM
The issue isn't with the database, the problem is in the sql generator. The fields there don't match the current TCDB 61.

q8rakan
10-21-2016, 03:16 AM
The issue isn't with the database, the problem is in the sql generator. The fields there don't match the current TCDB 61.

but still its the same as TDB 60 i mean the columns

Sylica
10-21-2016, 04:00 AM
but still its the same as TDB 60 i mean the columns

I'll make a custom quest with the generator to see if it gives me any issues. I'm still 70% sure its the generator. Lets debug the issue. Please post any errors or warnings that it gives you.

-- Update --
Can you post the structures with no data for me that are listed in the SQL query file? I'm currently not having any issues on my end. Hopefully we can find the problem and make a possible fix for it.
There should be 105 columns for quest_template.

q8rakan
10-21-2016, 04:49 AM
I'll make a custom quest with the generator to see if it gives me any issues. I'm still 70% sure its the generator. Lets debug the issue. Please post any errors or warnings that it gives you.

-- Update --
Can you post the structures with no data for me that are listed in the SQL query file? I'm currently not having any issues on my end. Hopefully we can find the problem and make a possible fix for it.
There should be 105 columns for quest_template.

CREATE TABLE `quest_template` (
`ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`QuestType` TINYINT(3) UNSIGNED NOT NULL DEFAULT '2',
`QuestLevel` SMALLINT(3) NOT NULL DEFAULT '1',
`MinLevel` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`QuestSortID` SMALLINT(6) NOT NULL DEFAULT '0',
`QuestInfoID` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`SuggestedGroupNum` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RequiredFactionId1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredFactionId2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredFactionValue1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredFactionValue2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardNextQuest` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardXPDifficulty` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardMoney` INT(11) NOT NULL DEFAULT '0',
`RewardBonusMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`RewardDisplaySpell` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardSpell` INT(11) NOT NULL DEFAULT '0',
`RewardHonor` INT(11) NOT NULL DEFAULT '0',
`RewardKillHonor` FLOAT NOT NULL DEFAULT '0',
`StartItem` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`RequiredPlayerKills` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID6` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`POIContinent` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`POIx` FLOAT NOT NULL DEFAULT '0',
`POIy` FLOAT NOT NULL DEFAULT '0',
`POIPriority` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardTitle` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardTalents` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardArenaPoints` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardFactionID1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue5` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride5` MEDIUMINT(8) NOT NULL DEFAULT '0',
`TimeAllowed` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`AllowableRaces` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`LogTitle` TEXT NULL,
`LogDescription` TEXT NULL,
`QuestDescription` TEXT NULL,
`AreaDescription` TEXT NULL,
`QuestCompletionLog` TEXT NULL,
`RequiredNpcOrGo1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGo2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGo3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGo4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId6` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`Unknown0` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`ObjectiveText1` TEXT NULL,
`ObjectiveText2` TEXT NULL,
`ObjectiveText3` TEXT NULL,
`ObjectiveText4` TEXT NULL,
`VerifiedBuild` SMALLINT(5) NULL DEFAULT '0',
PRIMARY KEY (`ID`)
)
COMMENT='Quest System'
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
idk if this what u want xD but ..

Yup there is 105 columns

Sylica
10-21-2016, 05:09 AM
CREATE TABLE `quest_template` (
`ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`QuestType` TINYINT(3) UNSIGNED NOT NULL DEFAULT '2',
`QuestLevel` SMALLINT(3) NOT NULL DEFAULT '1',
`MinLevel` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`QuestSortID` SMALLINT(6) NOT NULL DEFAULT '0',
`QuestInfoID` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`SuggestedGroupNum` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RequiredFactionId1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredFactionId2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredFactionValue1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredFactionValue2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardNextQuest` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardXPDifficulty` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardMoney` INT(11) NOT NULL DEFAULT '0',
`RewardBonusMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`RewardDisplaySpell` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardSpell` INT(11) NOT NULL DEFAULT '0',
`RewardHonor` INT(11) NOT NULL DEFAULT '0',
`RewardKillHonor` FLOAT NOT NULL DEFAULT '0',
`StartItem` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`RequiredPlayerKills` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID6` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`POIContinent` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`POIx` FLOAT NOT NULL DEFAULT '0',
`POIy` FLOAT NOT NULL DEFAULT '0',
`POIPriority` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardTitle` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardTalents` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardArenaPoints` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardFactionID1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue5` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride5` MEDIUMINT(8) NOT NULL DEFAULT '0',
`TimeAllowed` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`AllowableRaces` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`LogTitle` TEXT NULL,
`LogDescription` TEXT NULL,
`QuestDescription` TEXT NULL,
`AreaDescription` TEXT NULL,
`QuestCompletionLog` TEXT NULL,
`RequiredNpcOrGo1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGo2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGo3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGo4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredNpcOrGoCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemId6` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RequiredItemCount6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`Unknown0` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`ObjectiveText1` TEXT NULL,
`ObjectiveText2` TEXT NULL,
`ObjectiveText3` TEXT NULL,
`ObjectiveText4` TEXT NULL,
`VerifiedBuild` SMALLINT(5) NULL DEFAULT '0',
PRIMARY KEY (`ID`)
)
COMMENT='Quest System'
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;
idk if this what u want xD but ..

Yup there is 105 columns

It looks the same, but lets run a check though.


SELECT ID, QuestType, QuestLevel, MinLevel, QuestSortID, QuestInfoID, SuggestedGroupNum, RequiredFactionId1, RequiredFactionId2, RequiredFactionValue1, RequiredFactionValue2, RewardNextQuest, RewardXPDifficulty, RewardMoney, RewardBonusMoney, RewardDisplaySpell, RewardSpell, RewardHonor, RewardKillHonor, StartItem, Flags, RequiredPlayerKills, RewardItem1, RewardAmount1, RewardItem2, RewardAmount2, RewardItem3, RewardAmount3, RewardItem4, RewardAmount4, ItemDrop1, ItemDropQuantity1, ItemDrop2, ItemDropQuantity2, ItemDrop3, ItemDropQuantity3, ItemDrop4, ItemDropQuantity4, RewardChoiceItemID1, RewardChoiceItemQuantity1, RewardChoiceItemID2, RewardChoiceItemQuantity2, RewardChoiceItemID3, RewardChoiceItemQuantity3, RewardChoiceItemID4, RewardChoiceItemQuantity4, RewardChoiceItemID5, RewardChoiceItemQuantity5, RewardChoiceItemID6, RewardChoiceItemQuantity6, POIContinent, POIx, POIy, POIPriority, RewardTitle, RewardTalents, RewardArenaPoints, RewardFactionID1, RewardFactionValue1, RewardFactionOverride1, RewardFactionID2, RewardFactionValue2, RewardFactionOverride2, RewardFactionID3, RewardFactionValue3, RewardFactionOverride3, RewardFactionID4, RewardFactionValue4, RewardFactionOverride4, RewardFactionID5, RewardFactionValue5, RewardFactionOverride5, TimeAllowed, AllowableRaces, LogTitle, LogDescription, QuestDescription, AreaDescription, QuestCompletionLog, RequiredNpcOrGo1, RequiredNpcOrGo2, RequiredNpcOrGo3, RequiredNpcOrGo4, RequiredNpcOrGoCount1, RequiredNpcOrGoCount2, RequiredNpcOrGoCount3, RequiredNpcOrGoCount4, RequiredItemId1, RequiredItemId2, RequiredItemId3, RequiredItemId4, RequiredItemId5, RequiredItemId6, RequiredItemCount1, RequiredItemCount2, RequiredItemCount3, RequiredItemCount4, RequiredItemCount5, RequiredItemCount6, Unknown0, ObjectiveText1, ObjectiveText2, ObjectiveText3, ObjectiveText4, VerifiedBuild FROM quest_template;


If successful, should show this : Found rows: 9,464

Have you tried clearing your client cache and re-accepting the quest?
When doing the quest, does the server output errors?
Do you have custom items/drops?

Can you post the script you made for me to test? Just going through all the debugs I do when working with MySQL.

MrPixelMC
10-21-2016, 07:10 AM
hello, i am having problem with my custom quests the problem is when i take the quest that requires me to get items + killing boss ita buggs out when you relog or put the item for the quest in bank when i do that i couldnt complete the quest its shows me in questlog that the quest is complete but the npc shows me gray question mark any solution for that ..?

After you relog, if you put the required items in bank and then get them back, does the question mark turn yellow (meaning you are able to complete the quest)?
If so, I've seen this bug happen too, not sure what is causing it but most likely it's got to do with core, I think.

q8rakan
10-21-2016, 04:53 PM
It looks the same, but lets run a check though.


SELECT ID, QuestType, QuestLevel, MinLevel, QuestSortID, QuestInfoID, SuggestedGroupNum, RequiredFactionId1, RequiredFactionId2, RequiredFactionValue1, RequiredFactionValue2, RewardNextQuest, RewardXPDifficulty, RewardMoney, RewardBonusMoney, RewardDisplaySpell, RewardSpell, RewardHonor, RewardKillHonor, StartItem, Flags, RequiredPlayerKills, RewardItem1, RewardAmount1, RewardItem2, RewardAmount2, RewardItem3, RewardAmount3, RewardItem4, RewardAmount4, ItemDrop1, ItemDropQuantity1, ItemDrop2, ItemDropQuantity2, ItemDrop3, ItemDropQuantity3, ItemDrop4, ItemDropQuantity4, RewardChoiceItemID1, RewardChoiceItemQuantity1, RewardChoiceItemID2, RewardChoiceItemQuantity2, RewardChoiceItemID3, RewardChoiceItemQuantity3, RewardChoiceItemID4, RewardChoiceItemQuantity4, RewardChoiceItemID5, RewardChoiceItemQuantity5, RewardChoiceItemID6, RewardChoiceItemQuantity6, POIContinent, POIx, POIy, POIPriority, RewardTitle, RewardTalents, RewardArenaPoints, RewardFactionID1, RewardFactionValue1, RewardFactionOverride1, RewardFactionID2, RewardFactionValue2, RewardFactionOverride2, RewardFactionID3, RewardFactionValue3, RewardFactionOverride3, RewardFactionID4, RewardFactionValue4, RewardFactionOverride4, RewardFactionID5, RewardFactionValue5, RewardFactionOverride5, TimeAllowed, AllowableRaces, LogTitle, LogDescription, QuestDescription, AreaDescription, QuestCompletionLog, RequiredNpcOrGo1, RequiredNpcOrGo2, RequiredNpcOrGo3, RequiredNpcOrGo4, RequiredNpcOrGoCount1, RequiredNpcOrGoCount2, RequiredNpcOrGoCount3, RequiredNpcOrGoCount4, RequiredItemId1, RequiredItemId2, RequiredItemId3, RequiredItemId4, RequiredItemId5, RequiredItemId6, RequiredItemCount1, RequiredItemCount2, RequiredItemCount3, RequiredItemCount4, RequiredItemCount5, RequiredItemCount6, Unknown0, ObjectiveText1, ObjectiveText2, ObjectiveText3, ObjectiveText4, VerifiedBuild FROM quest_template;


If successful, should show this : Found rows: 9,464

Have you tried clearing your client cache and re-accepting the quest?
When doing the quest, does the server output errors?
Do you have custom items/drops?

Can you post the script you made for me to test? Just going through all the debugs I do when working with MySQL.

yup the one u sent works without error but its shows me more than that rows cause of my custom quests i think

and yup i tried to delete cache and relog to fix it but nope didnt at the first and which script?

- - - Updated - - -


After you relog, if you put the required items in bank and then get them back, does the question mark turn yellow (meaning you are able to complete the quest)?
If so, I've seen this bug happen too, not sure what is causing it but most likely it's got to do with core, I think.

exactly that is my problem

MrPixelMC
10-21-2016, 06:06 PM
exactly that is my problem
It's a TC issue I believe, I'm not really sure what causes it or how to fix it, though.

q8rakan
10-21-2016, 06:17 PM
It's a TC issue I believe, I'm not really sure what causes it or how to fix it, though.

I dont know maybe its the core itself but i will try to check the source codes..

Sylica
10-21-2016, 09:58 PM
yup the one u sent works without error but its shows me more than that rows cause of my custom quests i think

and yup i tried to delete cache and relog to fix it but nope didnt at the first and which script?

Don't know if I asked yet, but what kind of quest is it?

I ran into an issue with a few types of quest types, and want to get some more information from you, so I might be able to make a possible fix.

One I have logged, is a kill quest to retrieve an item, some but not all objective quests.

q8rakan
10-21-2016, 10:37 PM
Don't know if I asked yet, but what kind of quest is it?

I ran into an issue with a few types of quest types, and want to get some more information from you, so I might be able to make a possible fix.

One I have logged, is a kill quest to retrieve an item, some but not all objective quests.

Its a quest need to kill few bosses + farming items but its take long time to do it like the boss respawn every 4 hours and the chance of the item drop low and yes i use custom boss and custom items in the quest

Sylica
10-21-2016, 11:55 PM
Its a quest need to kill few bosses + farming items but its take long time to do it like the boss respawn every 4 hours and the chance of the item drop low and yes i use custom boss and custom items in the quest

Yea, but I can't reproduce this at all on queue and I think this might be random. Tested this on multiple revisions of TrinityCore clean database and core. 2 of 50 custom quests I made had some issues at some point, so I dropped them and required them again with out problems.

Here are some ways of fixing these problems.

Try compiling a clean core and database
Try trace logging all process that are executed by the server
Check all queries to make sure correct flags and data are present

MrPixelMC
10-22-2016, 12:54 AM
Yea, but I can't reproduce this at all on queue and I think this might be random. Tested this on multiple revisions of TrinityCore clean database and core. 2 of 50 custom quests I made had some issues at some point, so I dropped them and required them again with out problems.

Here are some ways of fixing these problems.

Try compiling a clean core and database
Try trace logging all process that are executed by the server
Check all queries to make sure correct flags and data are present


Were you using custom items in your quest? It seems like it happens randomly (most likely it's not random though, just an unknown reason), but only happens with custom items. It's happened to me before too.

q8rakan
10-22-2016, 01:30 AM
Yea, but I can't reproduce this at all on queue and I think this might be random. Tested this on multiple revisions of TrinityCore clean database and core. 2 of 50 custom quests I made had some issues at some point, so I dropped them and required them again with out problems.

Here are some ways of fixing these problems.

Try compiling a clean core and database
Try trace logging all process that are executed by the server
Check all queries to make sure correct flags and data are present


Okay gonna test that

Sylica
10-22-2016, 04:08 AM
Were you using custom items in your quest? It seems like it happens randomly (most likely it's not random though, just an unknown reason), but only happens with custom items. It's happened to me before too.

I wouldn't say an unknown reason, since there is a reason for what is happening. After doing some testing on this for 6+ hours or so with my project team, this seems to happen 4% of the time which is still very low percentage. Still don't think anything custom would cause this. I still have a good feeling is might be related to syncing of the database to server.