[Guide] Delete Invalid Hatching TacticsID

[witchymoo]

Hi I'd like to share something related to "Hatching TacticsID" error. I think there's a lot of ways posted here, but I figure to post one as an alternative way

This is the error, some of you probably got the same:


The boring part:

USE [SRO_VT_SHARD]
GO
SET NOCOUNT ON;
DECLARE @invalidTacticsID INT;
DECLARE RefNest_Cursor CURSOR FOR SELECT DISTINCT dwTacticsID FROM Tab_RefNest AS T WHERE NOT EXISTS (SELECT * FROM Tab_RefTactics AS R WHERE T.dwTacticsID = R.dwTacticsID) ORDER BY dwTacticsID ASC;
OPEN RefNest_Cursor;
FETCH NEXT FROM RefNest_Cursor INTO @invalidTacticsID;
WHILE @@FETCH_STATUS = 0
BEGIN
	DELETE FROM Tab_RefNest WHERE dwTacticsID = @invalidTacticsID;
	PRINT 'dwTacticsID: ' + CAST(@invalidTacticsID AS VARCHAR) + ' deleted from Tab_RefNest.';
	FETCH NEXT FROM RefNest_Cursor INTO @invalidTacticsID;
END;
CLOSE RefNest_Cursor;
DEALLOCATE RefNest_Cursor;
GO

And reload your GameServer to see if the error still appears

Good luck and have fun, hope this helps a little bit.

[hossamxt]

Nice work

[ILowe]

nice
-----
How to resolve this?

[witchymoo]

never had that one but you can try .

Look for "Remove the annoying Quest:RaiseEvent Error" offset.

good luck

[denise456]

TRUNCATE TABLE _CharQuest
UPDATE _RefCharDefault_Quest
SET Service = 0

Originally Posted by ILowe

nice
-----
How to resolve this?

[witchymoo]

Um, not so sure about that cause my [_RefCharDefault_Quest] are all active.

 Spoiler

But just try that and see how it goes.

[blapanda]

Usually people advice to disable the chinese tutorial quest (QTUTORIAL_CH), which seems to cause bugs by time to time (and somehow the F1 bug as well, dunno if that is true).

Anyways, they don't have a huge impact onto the gameplay.

[witchymoo]

Ah, about Belt F1 slots 1-4 bug, I put this in my [_AddNewChar] in the last line of quest section (before _StaticAvatar)

UPDATE [_CharQuest] SET [Status] = '5', StartTime = '2013-10-31 00:00:00', EndTime = '2013-10-31 00:00:00', QuestData1 = 31458135, QuestData2 = 0 WHERE (CharID = @NewCharID AND QuestID IN (1,2))

and viola, belt F1 slots 1-4 cleared for the new char

[iWillKiller]

useful query , thanks witchy

[Dev.Ahmed_Elnashary]

Woow Keep Going Bro <3

[Syloxx]

DELETE Tab_RefHive WHERE dwHiveID NOT IN (SELECT dwHiveID FROM Tab_RefNest)
DELETE Tab_RefTactics WHERE dwTacticsID NOT IN (SELECT dwTacticsID FROM Tab_RefNest)

huh why using cursor? o.O

[Laag#82]

nice Work

[synsroadmin]

nice work