Reecey12345 Posted February 22, 2014 Share Posted February 22, 2014 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. Quote Link to comment Share on other sites More sharing options...
lucky3809 Posted February 22, 2014 Share Posted February 22, 2014 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Reecey12345 Posted February 22, 2014 Author Share Posted February 22, 2014 (edited) 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 Quote Link to comment Share on other sites More sharing options...
lucky3809 Posted February 22, 2014 Share Posted February 22, 2014 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? Quote Link to comment Share on other sites More sharing options...
Reecey12345 Posted February 22, 2014 Author Share Posted February 22, 2014 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. Quote Link to comment Share on other sites More sharing options...
Reecey12345 Posted February 22, 2014 Author Share Posted February 22, 2014 I fiddled around abit with the crime sql and ive managed to fix it:) thanks for the replys anyway. Quote Link to comment Share on other sites More sharing options...
Dave Posted February 23, 2014 Share Posted February 23, 2014 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. Quote Link to comment Share on other sites More sharing options...
Tangled Posted June 8, 2014 Share Posted June 8, 2014 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? Quote Link to comment Share on other sites More sharing options...
WildHosting Posted June 8, 2014 Share Posted June 8, 2014 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? Quote Link to comment Share on other sites More sharing options...
Samurai Legend Posted June 8, 2014 Share Posted June 8, 2014 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. Quote Link to comment Share on other sites More sharing options...
WildHosting Posted June 9, 2014 Share Posted June 9, 2014 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 :-) Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted June 10, 2014 Share Posted June 10, 2014 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 Quote Link to comment Share on other sites More sharing options...
Tangled Posted June 10, 2014 Share Posted June 10, 2014 (edited) 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 Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted June 10, 2014 Share Posted June 10, 2014 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 Quote Link to comment Share on other sites More sharing options...
GangLife Posted June 10, 2014 Share Posted June 10, 2014 This isn't a Mccodes problem, it's Ravan script. Stop repeating "mccodes" and confusing people trying to help you. :mad: Quote Link to comment Share on other sites More sharing options...
peterisgb Posted June 10, 2014 Share Posted June 10, 2014 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. Quote Link to comment Share on other sites More sharing options...
sniko Posted June 10, 2014 Share Posted June 10, 2014 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.