Mysql Query Error - Printable Version

Mysql Query Error - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Mysql Query Error (/showthread.php?tid=209644)

Mysql Query Error - Anthonyx3' - 11.01.2011

pawn Код:

function SavePlayerStats(playerid)
{
    format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%d', `ppos_y` = '%d', `ppos_z` = '%d', `Level` = '%d' ` WHERE `user` = '%s'",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid));
    mysql_query(str);
    return 1;
}

I get a mysql query error for this:

pawn Код:

[Mon Jan 10 22:47:19 2011] Function: mysql_query executed: "UPDATE `Users` SET `Money` = '0', `Gender` = '1', `ppos_x` = '0', `ppos_y` = '0', `ppos_z` = '0', `Level` = '0' ` WHERE `user` = 'Tyrone_Williamss'" with result: "1".
[Mon Jan 10 22:47:19 2011] Error (0): Failed to exeute query. 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 '` WHERE `user` = 'Tyrone_Williamss'' at line 1.

Anyone notice a problem?

Re: Mysql Query Error - _rAped - 11.01.2011

You accidentally (I presume) added an extra `

pawn Код:

function SavePlayerStats(playerid)
{
    format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%df, `ppos_y` = '%f', `ppos_z` = '%f', `Level` = '%d' WHERE `user` = '%s';",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid));
    mysql_query(str);
    return 1;
}

Edit: Positions should be floats (%f).

Re: Mysql Query Error - Scenario - 11.01.2011

You are adding apostrophe's around your numerical variables (%d). You should be adding these; ` (same as the ~ key). You should also keep in mind you need to add apostrophe's around your string variables (%s); not `'s.

Re: Mysql Query Error - _rAped - 11.01.2011

Quote:

Originally Posted by RealCop228

You are adding apostrophe's around your numerical variables (%d). You should be adding these; ` (same as the ~ key). You should also keep in mind you need to add apostrophe's around your string variables (%s); not `'s.

Whatever you just stated doesn't count in this particular query. He did add apostrophe's around the string and if you decide to do it on integers has nothing to say.

Re: Mysql Query Error - Anthonyx3' - 11.01.2011

pawn Код:

Error (0): Failed to exeute query. Unknown column 'user' in 'where clause'.

Is my new error after your fix

Re: Mysql Query Error - _rAped - 11.01.2011

You prob forgot to capitalize user when making this query, I don't know your database structure.

pawn Код:

function SavePlayerStats(playerid)
{
    format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%df, `ppos_y` = '%f', `ppos_z` = '%f', `Level` = '%d' WHERE `User` = '%s';",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid));
    mysql_query(str);
    return 1;
}

Re: Mysql Query Error - Anthonyx3' - 11.01.2011

alright, now i run into this:

pawn Код:

Error (0): Failed to exeute query. 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.000000', `ppos_z` = '0.000000', `Level` = '0' WHERE `User` = 'Tyrone_Williamss' at line 1.

Re: Mysql Query Error - Retardedwolf - 11.01.2011

Lol,

pawn Код:

format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%f, `ppos_y` = '%f', `ppos_z` = '%f', `Level` = '%d' WHERE `User` = '%s';",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid)

Re: Mysql Query Error - Anthonyx3' - 11.01.2011

nvm, fixed it, you put an extra "d" in your last fix for me, thanks for help.

Re: Mysql Query Error - _rAped - 11.01.2011

That's my bad, accidently added a d instead of a ' somewhere. ^lol

pawn Код:

function SavePlayerStats(playerid)
{
    format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%f', `ppos_y` = '%f', `ppos_z` = '%f', `Level` = '%d' WHERE `User` = '%s';",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid));
    mysql_query(str);
    return 1;
}