Crime Database Error

[Reecey12345]

So when i make one crime it works totally fine, when i try to make another i get this error:

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', '', '', '', '', , '', )' at line 1

Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( '', '', '((WILL*0.8)/2.5)+(LEVEL/4)', '', , 0, '1', '', '', '', '', , '', )

Could someone fix this? I'm using an original MCCodes V2 testing it on a PAID domain & host, crons are also running.

Any help appreciated.

[lucky3809]

So when i make one crime it works totally fine, when i try to make another i get this error:

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', '', '', '', '', , '', )' at line 1

Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( '', '', '((WILL*0.8)/2.5)+(LEVEL/4)', '', , 0, '1', '', '', '', '', , '', )

Could someone fix this? I'm using an original MCCodes V2 testing it on a PAID domain & host, crons are also running.

Any help appreciated.

Your insert is very wrong you have comma's in the wrong place if there is nothing else followed by the comma such a field it is not needed such you have this at the end : '', ) should be just the quotes '') in those empty spaces you should add those very same quotes in them as well.

 

Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( '', '', '((WILL*0.8)/2.5)+(LEVEL/4)', '','', 0, '1', '', '', '', '','','')

It also seems that it's not inserting your fields such name of crime and brave ect..

Edited February 22, 2014 by lucky3809

[Reecey12345]

This is an error i get in the game, i didnt insert it, MCCodes automatically does it when installing and usually this works totally fine.

If it is the problem anyway could i get a working one to enter?

Edited February 22, 2014 by Reecey12345

[lucky3809]

Last time I installed mccodes it did not come with crime insert while installing, it only inserted crimes only, when you add the crime through staff panel.

If it's not a legit copy, (not saying it isn't) it will most likely have more than that as an error. Did you modify a file recently to insert the crimes?

[Reecey12345]

I have installed MCCodes many times before, it was around 2 year ago I bought them and at the time when i gave them a try everything worked perfectly, unsure what the error could be now as i havent modified them, they should be the same as when i bought.

Oh and if you mean it adds all the crimes for you? i didnt mean that, i meant it inserts the sqls for you thats all.

[Reecey12345]

I fiddled around abit with the crime sql and ive managed to fix it:) thanks for the replys anyway.

[Dave]

I fiddled around abit with the crime sql and ive managed to fix it:) thanks for the replys anyway.

Would be good to post up your solution just in case others have the same problem.

[Tangled]

I just recently purchased mccodes v2 and my crimes sql is empty. I tried creating crimes via staff panel and it keeps telling me my fields are empty. I'm new to this can someone help please?

[WildHosting]

Don't leave any fields empty when creating a crime. Also you may need to go to the dbsql file and insert the crimes database, this may have not inserted on it own which it should have anyway?

[Samurai Legend]

I just recently purchased mccodes v2 and my crimes sql is empty. I tried creating crimes via staff panel and it keeps telling me my fields are empty. I'm new to this can someone help please?

Mail me on Samurai Assault, I can help you out.

[WildHosting]

Mail me on Samurai Assault, I can help you out.

Offtopic but mailbox.php doesn't exist on your game buddy so he can't mail you :-)

[KyleMassacre]

I just recently purchased mccodes v2 and my crimes sql is empty. I tried creating crimes via staff panel and it keeps telling me my fields are empty. I'm new to this can someone help please?

By default staff_crimes makes you put in a crystal value and a money value on creation of crimes which I think is a bad idea to begin with and basing the exp gain off the success money (for every $8 is 1 exp)

and ns ill quit now since I think I went a bit off topic:o

[Tangled]

thanks Kyle, I /we (my staff) figured that out finally last nite. Funny bout the time I got a response here they figured it out. I sure appreciate the help tho.

Edited June 10, 2014 by Tangled

[KyleMassacre]

thanks Kyle, I /we (my staff) figured that out finally last nite. Funny bout the time I got a response here they figured it out. I sure appreciate the help tho.

Cool! I just didn't get to your response in time my bad

[GangLife]

This isn't a Mccodes problem, it's Ravan script. Stop repeating "mccodes" and confusing people trying to help you. :mad:

[peterisgb]

This isn't a Mccodes problem, it's Ravan script. Stop repeating "mccodes" and confusing people trying to help you. :mad:

 

Mccodes and Ravan is the Same Script. Just Ravans is stolen code.

[sniko]

Mccodes and Ravan is the Same Script. Just Ravans is stolen code.

It's not a 100% straight clone, IIRC.

They've included some (paid? and) free modules, as well as a unnecessary encryption of the source.