Help needed. SQL error?

[TMG]

QUERY 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 ' 0, '', 'This is a test crime', 'Crime finished, You own!', 'Crime Failed, You a' at line 1
Query was

INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'Test Crime', '0', '((WILL*0.8)/2.5)+(LEVEL/4)', '', , 0, '', 'This is a test crime', 'Crime finished, You own!', 'Crime Failed, You are a failure', 'You got caught by the blue', 0, 'noob', 500);

Any idea what I can do to fix this?

[Orjan]

yes, before that zero, you have two commas, without a value, I assume it want a value there.

[TMG]

I dont really understand what to do now xD

[Orjan]

you have to insert a zero, a null or a '' there, depending on the field type

[TMG]

Okay, So far I understand, But I dont know where to insert that.
I suppose at the database, Yet I dont know where in the database.

[BlaineSch]

Orjan was refering to your query:

INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'Test Crime', '0', '((WILL*0.8)/2.5)+(LEVEL/4)', '', , 0, '', 'This is a test crime', 'Crime finished, You own!', 'Crime Failed, You are a failure', 'You got caught by the blue', 0, 'noob', 500)

INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'Test Crime', '0', '((WILL*0.8)/2.5)+(LEVEL/4)', '', -----HERE-----, 0, '', 'This is a test crime', 'Crime finished, You own!', 'Crime Failed, You are a failure', 'You got caught by the blue', 0, 'noob', 500)

Where " -----HERE-----" is needs to be a value of something, you can't leave it blank. In some of the fields you put '' but that one is blank which is why it's giving you an error you should put " -----HERE-----" as a blank string, throw in a numeric number (zero) or something so it doesn't give you an error

[TMG]

Oh okay! Got it fixed!
Thank you!