mysql error 1064 - Printable Version

mysql error 1064 - 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 1064 (/showthread.php?tid=657628)

mysql error 1064 - Heress - 12.08.2018

I have MySQL error #1064

Quote:

[09:34:12] [ERROR] CMySQLQuery::Execute[()] - (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

Code:
https://pastebin.com/Y3UcDWax

Can someone help?

Re: mysql error 1064 - KinderClans - 12.08.2018

pawn Код:

public OnPlayerConnect(playerid)
{
    new vardas [MAX_PLAYER_NAME], query[64];
    GetPlayerName(playerid, vardas, sizeof(vardas));
    format(query, sizeof(query), "SELECT `id` FROM `user` WHERE `vardas` = '%s'", vardas);
    mysql_function_query(manomysql, query, true, "OnUserCheck", "i", playerid);
    return 1;
}

Re: mysql error 1064 - Heress - 12.08.2018

Now it is another error
[10:34:03] [ERROR] CMySQLQuery::Execute[()] - (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 ''pass' at line 1

"pass' is part of my register password.When I registering, I create passoword (password) and where is something wrong

Re: mysql error 1064 - KinderClans - 12.08.2018

We're in 2018 but telepathy hasn't been invented yet. You need to show us the code.

Re: mysql error 1064 - Heress - 12.08.2018

My Code is in first post pastebin

now updated:
https://pastebin.com/rmBSbKpc

Re: mysql error 1064 - KinderClans - 12.08.2018

pawn Код:

format(query, sizeof(query), "INSERT INTO `user` (`vardas`, `slaptazodis`) VALUES ('%s', '%s')", vardas, inputtext);

Next time just show the code which gives you the error, not the whole gamemode...

Re: mysql error 1064 - Heress - 12.08.2018

error

Quote:

[10:57:16] [ERROR] CMySQLQuery::Execute[()] - (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

code: https://pastebin.com/eZfh0dRE

Re: mysql error 1064 - KinderClans - 12.08.2018

Seriously? How you think i can help you if you give me the full gamemode?

Re: mysql error 1064 - Heress - 12.08.2018

Quote:

public OnPlayerConnect(playerid)
{
new name [MAX_PLAYER_NAME], query[64];
GetPlayerName(playerid, name, sizeof(name));
format(query, sizeof(query), "SELECT `id` FROM `user` WHERE `username` = '%s'", name);
mysql_function_query(manomysql, query, true, "OnUserCheck", "i", playerid);
return 1;
}

What's wrong?

Re: mysql error 1064 - Heress - 12.08.2018

Someone?

Where is fail in there?
https://imgur.com/a/ke4RQGb

And why I still have syntax error?

Quote:

[14:17:36] [ERROR] CMySQLQuery::Execute[()] - (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

In mysql.log dont write where error is exactly...

Re: mysql error 1064 - Heress - 12.08.2018

someone know?

Re: mysql error 1064 - Heress - 13.08.2018

please it very important for me :/

I dont believe what all of in here dont know how to fix this syntax problem.... I have mistake in my MySQL codding and please help me solve it :/

Re: mysql error 1064 - Heress - 15.08.2018

I\'m still need help...