[MerryDeer]

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.

[oMa37]

Show us your query.

[Slawiii]

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);

[MerryDeer]

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

[Quinncell]

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..

[Slawiii]

i think its not a problem

[MerryDeer]

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