Problem MySQL saving, Bad Syntax

Problem MySQL saving, Bad Syntax - 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: Problem MySQL saving, Bad Syntax (/showthread.php?tid=398907)

Problem MySQL saving, Bad Syntax - andrew2695 - 11.12.2012

I'm getting errors when the Saving part is being called and I don't know where I did something wrong. Can you tell me what is wrong with my code? (Sorry for the 2 posts, I'm a beginner in MySQL and its not so easy as a expected.)

pawn Код:

new query[1500];

    format(query, sizeof(query), "UPDATE `accounts` SET Admin = %d, Skin = %d, Team = %d, InHand = %d, InBank = %d, Score = %d, Kills = %d, Deaths = %d, Regular = %d, Donator = %d, CitySpawn = %d, SpeedUnit = %d, Plate = %s, Color1 = %d, Color2 = %d, AutoCorrect = %d, Hours = %d, Minutes %d, Seconds = %s WHERE `ID` = %d",
    Info[playerid][aLevel],
    Info[playerid][Skin],
    Info[playerid][Team],
    GetPlayerCash(playerid),
    Info[playerid][InBank],
    GetPlayerScore(playerid),
    Info[playerid][Kills],
    Info[playerid][Deaths],
    Info[playerid][Regular],
    Info[playerid][Donator],
    Info[playerid][CitySpawn],
    Info[playerid][SpeedUnit],
    Info[playerid][Plate],
    Info[playerid][Color1],
    Info[playerid][Color2],
    Info[playerid][AutoCorrect],
    Info[playerid][Hours],
    Info[playerid][Minutes],
    Info[playerid][Seconds],
    Info[playerid][SQLid]);

    mysql_function_query(g_Handle, query, false, "SendQuery", "");

The console error:

The MySQL log:

Код HTML:

[17:01:23] >> mysql_query_callback( Connection handle: 1 )
[17:01:23] Passing query UPDATE `accounts` SET Admin = 0, Skin = 266, Team = 2, InHand = 0, InBank = 0, Score = 0, Kills = 0, Deaths = 0, Regular = 0, Donator = 0, CitySpawn = 0, SpeedUnit = 0, Plate = , Color1 = 0, Color2 = 0, AutoCorrect = 0, Hours = 0, Minutes 0, Seconds =  WHERE `ID` = 1 | 
[17:01:23] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[17:01:23] OnQueryError() - Called.

AW: Problem MySQL saving, Bad Syntax - Kevin54321 - 11.12.2012

pawn Код:

, Minutes %d,

Something is wrong ...
Hope you find it

Re: Problem MySQL saving, Bad Syntax - Azazelo - 11.12.2012

SpeedUnit = 0, Plate = , Color1 = 0

Plate are null

AW: Problem MySQL saving, Bad Syntax - Kevin54321 - 11.12.2012

Plate = , -> Plate = "",
So its empty

Greetz
~ Kevin

AW: Problem MySQL saving, Bad Syntax - Tommyx3 - 11.12.2012

Quote:

, Seconds = %s

change to

Quote:

, Seconds = %d

Re : Problem MySQL saving, Bad Syntax - andrew2695 - 11.12.2012

Thanks guys lol, I hate typos! But My plate is a string and when I try to save it I get Uknown Column 'PlateName' in 'field list'

Re: Re : Problem MySQL saving, Bad Syntax - Shaneisace - 12.12.2012

Quote:

Originally Posted by andrew2695

Thanks guys lol, I hate typos! But My plate is a string and when I try to save it I get Uknown Column 'PlateName' in 'field list'

also just to remind you if you are going to save %s into a Database, make sure to add '' around it or else it'll not work either

example: Something = '%s'