MySQL UPDATE query error
#2

Is this even the same? Take a better look:

format(query,sizeof(query),"UPDATE factions SET Rank 1 = '%s' WHERE ID = %d",inputtext,EditingFacid);

[12:07:09] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE factions SET Rank 1 = asdasd WHERE ID = 53", callback: "(null)", format: "(null)"

[12:07:09] [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 '1 = azzaz WHERE ID = 53' at line 1


- Your query has ' ' around %s which is correct.
- While executing, it doesn't have ' ' around and it displays asdasd only.
- On triggering of the error, it displays azzaz.

It just makes no sense.
Reply


Messages In This Thread
MySQL UPDATE query error - by SandKing94 - 25.05.2015, 09:02
Re: MySQL UPDATE query error - by Konstantinos - 25.05.2015, 09:07
Re: MySQL UPDATE query error - by MikE1990 - 25.05.2015, 09:07
Re: MySQL UPDATE query error - by SandKing94 - 25.05.2015, 09:41
Re : MySQL UPDATE query error - by Mathieu371 - 25.05.2015, 09:47
Re: Re : MySQL UPDATE query error - by SandKing94 - 25.05.2015, 09:51
Re: MySQL UPDATE query error - by PowerPC603 - 25.05.2015, 11:07

Forum Jump:


Users browsing this thread: 1 Guest(s)