[Help]Error Loading in stuff into DB

[Agent Orange]

Hey guys im getting this error when i try loading in my quest

/* SQL 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 'entry,ZoneId,sort,flags,MinLevel,questlevel,Type,Requi */

can anyone help? thanks

[latruwski]

post the query you are trying to execute pls

[Agent Orange]

entry,ZoneId,sort,flags,MinLevel,questlevel,Type,RequiredRaces,RequiredClass,RequiredTradeskill,RequiredTradeskillValue,RequiredRepFaction,RequiredRepValue,LimitTime,SpecialFlags,PrevQuestId,NextQuestId,srcItem,SrcItemCount,Title,Details,Objectives,CompletionText,IncompleteText,EndText,ObjectiveText1,ObjectiveText2,ObjectiveText3,ObjectiveText4,ReqItemId1,ReqItemId2,ReqItemId3,ReqItemId4,ReqItemCount1,ReqItemCount2,ReqItemCount3,ReqItemCount4,ReqKillMobOrGOId1,ReqKillMobOrGOId2,ReqKillMobOrGOId3,ReqKillMobOrGOId4,ReqKillMobOrGOCount1,ReqKillMobOrGOCount2,ReqKillMobOrGOCount3,ReqKillMobOrGOCount4,ReqCastSpellId1,ReqCastSpellId2,ReqCastSpellId3,ReqCastSpellId4,RewChoiceItemId1,RewChoiceItemId2,RewChoiceItemId3,RewChoiceItemId4,RewChoiceItemId5,RewChoiceItemId6,RewChoiceItemCount1,RewChoiceItemCount2,RewChoiceItemCount3,RewChoiceItemCount4,RewChoiceItemCount5,RewChoiceItemCount6,RewItemId1,RewItemId2,RewItemId3,RewItemId4,RewItemCount1,RewItemCount2,RewItemCount3,RewItemCount4,RewRepFaction1,RewRepFaction2,RewRepFaction3,RewRepFaction4,RewRepFaction5,RewRepFaction6,RewRepValue1,RewRepValue2,RewRepValue3,RewRepValue4,RewRepValue5,RewRepValue6,RewRepLimit,RewMoney,RewXP,RewSpell,CastSpell,PointMapId,PointX,PointY,PointOpt,RewardMoneyAtMaxLevel,ExploreTrigger1,ExploreTrigger2,ExploreTrigger3,ExploreTrigger4,RequiredOneOfQuest,RequiredQuest1,RequiredQuest2,RequiredQuest3,RequiredQuest4,RemoveQuests,ReceiveItemId1,ReceiveItemId2,ReceiveItemId3,ReceiveItemId4,ReceiveItemCount1,ReceiveItemCount2,ReceiveItemCount3,ReceiveItemCount4,IsRepeatable,bonushonor,rewardtitleid,rewardtalents,suggestedplayers
80006,0,0,4,1,80,0,1791,1503,0,0,0,0,0,0,0,0,0,0,Welcome to WoWStarz,Welcome to WoWStarz!$BOur server has many things to offer,There is Custom quests, custom Items and Custom Zones. My job here is to welcome newcomers to WoWStarz server, and to give them a starters gift. ,Speak to me again to get a Reward.,Excellent! Lets get you your reward!,,Good Luck,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,88882,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50000000,90000000,0,0,0,0,0,0,250000,0,0,0,0,,0,0,0,0,,0,0,0,0,0,0,0,0,0,0,0,0,0

o and can you show me what you did to fix it because i have several other problems just like this exept with other stuff

[sasoritail]

Sure u've done it right?
I got this error because of something wrong in the SQL.
it was because there were things in there wich wasnt supported in 3.0.3 server's.
so i wonder if you got an error in the SQL file.
and one more thing:
the: , -.- you cant have a , beetween your sentences. it will ruin the whole thing!
then the SQL can think it's the next value. That's maybe one of ur problem's.
cant help u anymore sorry.

[kreegoth]

Do you have the part at the beginning that should say something like Insert into `quests` ?? just asking because i dont see it in the query you posted..

[Agent Orange]

no i dont. Where am i suppose to put that?

[hax0rz]

INSERT INTO quests (
entry,ZoneId,sort,flags,MinLevel,questlevel,Type,RequiredRaces,RequiredClass,RequiredTradeskill,RequiredTradeskillValue,RequiredRepFaction,RequiredRepValue,LimitTime,SpecialFlags,PrevQuestId,NextQuestId,srcItem,SrcItemCount,Title,Details,Objectives,CompletionText,IncompleteText,EndText,ObjectiveText1,ObjectiveText2,ObjectiveText3,ObjectiveText4,ReqItemId1,ReqItemId2,ReqItemId3,ReqItemId4,ReqItemCount1,ReqItemCount2,ReqItemCount3,ReqItemCount4,ReqKillMobOrGOId1,ReqKillMobOrGOId2,ReqKillMobOrGOId3,ReqKillMobOrGOId4,ReqKillMobOrGOCount1,ReqKillMobOrGOCount2,ReqKillMobOrGOCount3,ReqKillMobOrGOCount4,ReqCastSpellId1,ReqCastSpellId2,ReqCastSpellId3,ReqCastSpellId4,RewChoiceItemId1,RewChoiceItemId2,RewChoiceItemId3,RewChoiceItemId4,RewChoiceItemId5,RewChoiceItemId6,RewChoiceItemCount1,RewChoiceItemCount2,RewChoiceItemCount3,RewChoiceItemCount4,RewChoiceItemCount5,RewChoiceItemCount6,RewItemId1,RewItemId2,RewItemId3,RewItemId4,RewItemCount1,RewItemCount2,RewItemCount3,RewItemCount4,RewRepFaction1,RewRepFaction2,RewRepFaction3,RewRepFaction4,RewRepFaction5,RewRepFaction6,RewRepValue1,RewRepValue2,RewRepValue3,RewRepValue4,RewRepValue5,RewRepValue6,RewRepLimit,RewMoney,RewXP,RewSpell,CastSpell,PointMapId,PointX,PointY,PointOpt,RewardMoneyAtMaxLevel,ExploreTrigger1,ExploreTrigger2,ExploreTrigger3,ExploreTrigger4,RequiredOneOfQuest,RequiredQuest1,RequiredQuest2,RequiredQuest3,RequiredQuest4,RemoveQuests,ReceiveItemId1,ReceiveItemId2,ReceiveItemId3,ReceiveItemId4,ReceiveItemCount1,ReceiveItemCount2,ReceiveItemCount3,ReceiveItemCount4,IsRepeatable,bonushonor,rewardtitleid,rewardtalents,suggestedplayers)

Values (80006,0,0,4,1,80,0,1791,1503,0,0,0,0,0,0,0,0,0,0,Welcome to WoWStarz,Welcome to WoWStarz!$BOur server has many things to offer,There is Custom quests, custom Items and Custom Zones. My job here is to welcome newcomers to WoWStarz server, and to give them a starters gift. ,Speak to me again to get a Reward.,Excellent! Lets get you your reward!,,Good Luck,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,88882,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50000000,90000000,0,0,0,0,0,0,250000,0,0,0,0,,0,0,0,0,,0,0,0,0,0,0,0,0,0,0,0,0,0);

Try that now

[latruwski]

no i dont. Where am i suppose to put that?

check the solution posted that should do the trick

and if it wont work try the same query but put the values between ' ' (single quotes)

[Agent Orange]

i now get

* SQL 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 'to WoWStarz,Welcome to WoWStarz!$BOur server has many  */

[illegalalien]

run this it worked in mine so it should work in yours :P

INSERT INTO quests (
entry,ZoneId,sort,flags,MinLevel,questlevel,Type,RequiredRaces,RequiredClass,RequiredTradeskill,RequiredTradeskillValue,RequiredRepFaction,RequiredRepValue,LimitTime,SpecialFlags,PrevQuestId,NextQuestId,srcItem,SrcItemCount,Title,Details,Objectives,CompletionText,IncompleteText,EndText,ObjectiveText1,ObjectiveText2,ObjectiveText3,ObjectiveText4,ReqItemId1,ReqItemId2,ReqItemId3,ReqItemId4,ReqItemCount1,ReqItemCount2,ReqItemCount3,ReqItemCount4,ReqKillMobOrGOId1,ReqKillMobOrGOId2,ReqKillMobOrGOId3,ReqKillMobOrGOId4,ReqKillMobOrGOCount1,ReqKillMobOrGOCount2,ReqKillMobOrGOCount3,ReqKillMobOrGOCount4,ReqCastSpellId1,ReqCastSpellId2,ReqCastSpellId3,ReqCastSpellId4,RewChoiceItemId1,RewChoiceItemId2,RewChoiceItemId3,RewChoiceItemId4,RewChoiceItemId5,RewChoiceItemId6,RewChoiceItemCount1,RewChoiceItemCount2,RewChoiceItemCount3,RewChoiceItemCount4,RewChoiceItemCount5,RewChoiceItemCount6,RewItemId1,RewItemId2,RewItemId3,RewItemId4,RewItemCount1,RewItemCount2,RewItemCount3,RewItemCount4,RewRepFaction1,RewRepFaction2,RewRepFaction3,RewRepFaction4,RewRepFaction5,RewRepFaction6,RewRepValue1,RewRepValue2,RewRepValue3,RewRepValue4,RewRepValue5,RewRepValue6,RewRepLimit,RewMoney,RewXP,RewSpell,CastSpell,PointMapId,PointX,PointY,PointOpt,RewardMoneyAtMaxLevel,ExploreTrigger1,ExploreTrigger2,ExploreTrigger3,ExploreTrigger4,RequiredOneOfQuest,RequiredQuest1,RequiredQuest2,RequiredQuest3,RequiredQuest4,RemoveQuests,ReceiveItemId1,ReceiveItemId2,ReceiveItemId3,ReceiveItemId4,ReceiveItemCount1,ReceiveItemCount2,ReceiveItemCount3,ReceiveItemCount4,IsRepeatable,bonushonor,rewardtitleid,rewardtalents,suggestedplayers)

Values (80007,0,0,4,1,80,0,1791,1503,0,0,0,0,0,0,0,0,0,0,'Welcome to WoWStarz','Welcome to WoWStarz!$BOur server has many things to offer,There is Custom quests, custom Items and Custom Zones. My job here is to welcome newcomers to WoWStarz server, and to give them a starters gift.' ,'Speak to me again to get a Reward.','Excellent! Lets get you your reward!','','Good Luck','','','','',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,88882,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50000000,90000000,0,0,0,0,0,0,250000,0,0,0,0,'',0,0,0,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0);

in sql syntax you need to surround any words in ' ' if you dont itll give you an error also you cant have ,,,,, it HAS to have something in between each , , either a null value or just empty qoutes ie... ,'','','',

hope i make myself clear :P

[latruwski]

run this it worked in mine so it should work in yours :P

INSERT INTO quests (
entry,ZoneId,sort,flags,MinLevel,questlevel,Type,RequiredRaces,RequiredClass,RequiredTradeskill,RequiredTradeskillValue,RequiredRepFaction,RequiredRepValue,LimitTime,SpecialFlags,PrevQuestId,NextQuestId,srcItem,SrcItemCount,Title,Details,Objectives,CompletionText,IncompleteText,EndText,ObjectiveText1,ObjectiveText2,ObjectiveText3,ObjectiveText4,ReqItemId1,ReqItemId2,ReqItemId3,ReqItemId4,ReqItemCount1,ReqItemCount2,ReqItemCount3,ReqItemCount4,ReqKillMobOrGOId1,ReqKillMobOrGOId2,ReqKillMobOrGOId3,ReqKillMobOrGOId4,ReqKillMobOrGOCount1,ReqKillMobOrGOCount2,ReqKillMobOrGOCount3,ReqKillMobOrGOCount4,ReqCastSpellId1,ReqCastSpellId2,ReqCastSpellId3,ReqCastSpellId4,RewChoiceItemId1,RewChoiceItemId2,RewChoiceItemId3,RewChoiceItemId4,RewChoiceItemId5,RewChoiceItemId6,RewChoiceItemCount1,RewChoiceItemCount2,RewChoiceItemCount3,RewChoiceItemCount4,RewChoiceItemCount5,RewChoiceItemCount6,RewItemId1,RewItemId2,RewItemId3,RewItemId4,RewItemCount1,RewItemCount2,RewItemCount3,RewItemCount4,RewRepFaction1,RewRepFaction2,RewRepFaction3,RewRepFaction4,RewRepFaction5,RewRepFaction6,RewRepValue1,RewRepValue2,RewRepValue3,RewRepValue4,RewRepValue5,RewRepValue6,RewRepLimit,RewMoney,RewXP,RewSpell,CastSpell,PointMapId,PointX,PointY,PointOpt,RewardMoneyAtMaxLevel,ExploreTrigger1,ExploreTrigger2,ExploreTrigger3,ExploreTrigger4,RequiredOneOfQuest,RequiredQuest1,RequiredQuest2,RequiredQuest3,RequiredQuest4,RemoveQuests,ReceiveItemId1,ReceiveItemId2,ReceiveItemId3,ReceiveItemId4,ReceiveItemCount1,ReceiveItemCount2,ReceiveItemCount3,ReceiveItemCount4,IsRepeatable,bonushonor,rewardtitleid,rewardtalents,suggestedplayers)

Values (80007,0,0,4,1,80,0,1791,1503,0,0,0,0,0,0,0,0,0,0,'Welcome to WoWStarz','Welcome to WoWStarz!$BOur server has many things to offer,There is Custom quests, custom Items and Custom Zones. My job here is to welcome newcomers to WoWStarz server, and to give them a starters gift.' ,'Speak to me again to get a Reward.','Excellent! Lets get you your reward!','','Good Luck','','','','',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,88882,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50000000,90000000,0,0,0,0,0,0,250000,0,0,0,0,'',0,0,0,0,'',0,0,0,0,0,0,0,0,0,0,0,0,0);

in sql syntax you need to surround any words in ' ' if you dont itll give you an error also you cant have ,,,,, it HAS to have something in between each , , either a null value or just empty qoutes ie... ,'','','',

hope i make myself clear :P

Oh nice to post it I told him to use single quotes but well... maybe now he does understand what i was trying to say

[Agent Orange]

It worked thanks