[SQL] Fix CharQuest:Raise Error properly

[Royalblade]

There was ofc already a fix for that error out there.. however if u had a fucked up table in the first palce you'd need to rebuild it...

thats what this query does:

Declare @Charid INT
Declare charq cursor for
select distinct charid from _Char where CharID !=0 

open charq
fetch next from charq into @CharID
while @@FETCH_STATUS =0 
BEGIN
-- main query here...
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,1,5,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',8388691,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,2,1,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',8388691,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,385,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',0,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,386,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16842753,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,387,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16842753,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,388,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16842753,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,389,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16842753,0)
Insert into _CharQuest (CharID,QuestID,Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2)
Values (@charid,397,8,0,'2013-07-16 18:35:00','2013-07-16 18:35:00',16777217,0)
-- end of mian query
fetch next from charq into @charid
END
close charq
deallocate charq

Table: _RefCharDefault_Quest.txt

1    16    3    QEV_ALL_BASIC_1    5
1    17    3    QEV_ALL_BASIC_2    8
1    18    3    QEV_ALL_BASIC_3    10
1    19    3    QEV_ALL_BASIC_4    16
1    20    3    QEV_ALL_BASIC_5    20
1    21    3    QEV_ALL_BASIC_6    24
1    22    3    QEV_ALL_BASIC_7    30
1    23    3    QEV_ALL_BASIC_8    32
1    24    3    QEV_ALL_BASIC_9    40
1    25    3    QEV_ALL_BASIC_10    42
1    26    3    QEV_ALL_BASIC_11    50
1    27    3    QEV_ALL_BASIC_12    60
1    28    3    QEV_ALL_BASIC_0    1
1    29    0    QTUTORIAL_CH    1
1    30    3    QEVENT_GUIDE    1

[MentaL]

[Eroticus]

(1 row(s) affected)
Msg 2627, Level 14, State 1, Line 24
Violation of PRIMARY KEY constraint 'PK__CharQuest'. Cannot insert duplicate key in object 'dbo._CharQuest'. The duplicate key value is (75580, 397).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 10
Violation of PRIMARY KEY constraint 'PK__CharQuest'. Cannot insert duplicate key in object 'dbo._CharQuest'. The duplicate key value is (75581, 1).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 12
Violation of PRIMARY KEY constraint 'PK__CharQuest'. Cannot insert duplicate key in object 'dbo._CharQuest'. The duplicate key value is (75581, 2).
The statement has been terminated.


>.<?

[Royalblade]

Truncate that table first lol

IF you cant do that.. then just don't do anything with sro.