Having Problems With My Crimes

[xRudeboiix]

I have tried adding some crimes to my game but keep getting an error message like this:

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, '1', 'You Walk To The Bus Station And Start To Search For Cash', 'You Find S' at line 1

Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'Search For Cash', '2', '((WILL*n)/5)+(LEVEL/5) ', '11', , 0, '1', 'You Walk To The Bus Station And Start To Search For Cash', 'You Find Some Cash That Was Dropped By An Old Man', '', '', , '', )

Anyway to fix this?

[Seker]

I have tried adding some crimes to my game but keep getting an error message like this:

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, '1', 'You Walk To The Bus Station And Start To Search For Cash', 'You Find S' at line 1

Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'Search For Cash', '2', '((WILL*n)/5)+(LEVEL/5) ', '11', , 0, '1', 'You Walk To The Bus Station And Start To Search For Cash', 'You Find Some Cash That Was Dropped By An Old Man', '', '', , '', )

Anyway to fix this?

 

First off:

 

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, '1', 'You Walk To The Bus Station And Start To Search For Cash', 'You Find S' at line 1
Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( 'Search For Cash', '2', '((WILL*n)/5)+(LEVEL/5) ', '11', , 0, '1', 'You Walk To The Bus Station And Start To Search For Cash', 'You Find Some Cash That Was Dropped By An Old Man', '', '', , '', )

 

Secondly, count the commas in your query. I see at least 2 too many.

[xRudeboiix]

should i take the commas out? if so then do i replace them with anything else?

[KyleMassacre]

if my count is correct I see 14 columns and 12 things being inserted and looks to me another error (your original) is your success crystals. so take a look in that general location