SA-MP Forums Archive
MySQL error, displayed on Samp-server, Can't see it. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL error, displayed on Samp-server, Can't see it. (/showthread.php?tid=316759)



MySQL error, displayed on Samp-server, Can't see it. - Dokins - 08.02.2012

pawn Код:
[16:38:00] mysql error 1064: 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 '' at line 1
I know where it is, but I honestly do not see the problem, I've changed it several times.

pawn Код:
new query[256];
    format(query, sizeof(query), "INSERT INTO `vehicles` (VehModel, VehOwner, VehSpawnX, VehSpawnY, VehSpawnZ,VehSpawnAngle, VehColour1, VehColour2, VehFuel, VehPlate, VehWep1,VehWepA1,VehWep2,VehWepA2, VehCash, VehArmour, VehFaction, VehFRank, VehOwned, VehFactioned) VALUES (%d,'nobody'//this part is the error.,%f,%f,%f,%f,%d,%d,%d,'%s',0, 0, 0, 0, 0, 0, %d, %d, 0, 1)", vmodel,scx, scy, scz,sca,colour1,colour2,VehFuel[vehicleid],plate,faction, rank);
    mysql_query(query);



Re: MySQL error, displayed on Samp-server, Can't see it. - Dokins - 08.02.2012

Resolved, string size was not long enough ** DELETE **