Mysql error - Printable Version

Mysql 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)
+--- Thread: Mysql error (/showthread.php?tid=617155)

Mysql error - MerryDeer - 16.09.2016

Hi,

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

I sometimes get this error. I use string about 20000, very big. I'am saving strings, that i'am self generating like data and player name, no illegal symbols that can make syntax bad.

Re: Mysql error - oMa37 - 16.09.2016

Show us your query.

Re: Mysql error - Slawiii - 16.09.2016

is there are a string

you need to put %s btw ''

like

Код:

new query[70];
mysql_format(mysql, query, sizeof query, "UPDATE `users` SET `name` = '%s' WHERE `userid` = %d", name, userid);
mysql_tquery(mysql, query);

Re: Mysql error - MerryDeer - 16.09.2016

Yes i know, but there is problem i not always get that error what is very strange

Re: Mysql error - Quinncell - 16.09.2016

totally off topic but,

Do you know how many threads you've made on the first page?A lot!Can you at least try to figure out something by yourself instead of making a thread for every stupid problem you have..

Re: Mysql error - Slawiii - 16.09.2016

i think its not a problem

Re: Mysql error - MerryDeer - 16.09.2016

I think i found, there is saving like that row=" i always do row='%s' from where " ?