[Ascent][Help Please] Error In Quest Sql Ascent

[Thunder2121]

I have created my own quest and it says i have an error in my syntax. I can't seem to find the problem, Can someone please check this out for me?

INSERT INTO `quests` VALUES ("8675309", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "Getting To Know The GM's", "You Can Find Any GM Sitting Around At Your Local Maxi-Mini - Mall. If None Are There, Just Make A Ticket! But Make Sure YOu Check The Mall First XD", "Speak To Any GM On The World Of SquirrelCraft And Explain What Quest You Are On", "Huhh? Waht? Here Take This And Go Put My Top Down I Think Its Raining... Hic", "What The Bloody Hell Are You Doin' Back Here Already! Leave My Sight", "You Heard Him", "", "", "", "", "991201", "0", "0", "0", "1", "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", "7", "8", "0", "0", "1", "1", "0", "0", "0", "0", "0", "0", "0", "300000", "1200", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "", "0", "0", "0", "", "0", "0", "0", "0");

Thanks.

 

[Cruceo]

Ok, I'll actually help you with this one, because for the first time in history, it actually looks like you're trying. I'll explain this so you learn what it is, and how to fix it in the future; not just now.

Basically, your syntax for entering something is incorrect. It needs to follow this format:

insert into __where__ (___column names___) values (__values__);

Unfortunately, for the quests, you're going to need EVERY SINGLE column name to match those values you have.

Right now, you have:

insert into __where__ values (__values);

You missed the columns those values go into.

It'll take a little time to get the column names all written down (IN ORDER!!!!) to match the values you have right now, but it will work once you do, if you did it right.

 

[Thunder2121]

Thank you so much!! ill get started right away

 

[Cruceo]

No problem.

I'll be glad to help you if you're actually trying to LEARN and not be spoon-fed information.

 

[Thunder2121]

Ha thanks.