MySQL error
#7

Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
Seems like %q specifier replaces with '' instead of \', at least that's what it printed for a single apostrophe.

Just use mysql_format and '%e' and you'll have no problems.

---

As for strtok and non-threaded queries, consider use better methods (sscanf and threaded queries).
Код:
		format(string,sizeof(string),"INSERT INTO `logs_admin` (`Nombre`,`Administrador`,`Tipo`,`Motivo`,`Tiempo`,`IP`,`IP_Administrador`) VALUES ('%e','%e','1','%e','%e','%e','%e')",GetPlayerNameRP(playerid2),GetPlayerNameRP(playerid),(result),time,plr2IP,plrIP);
        mysql_query(1, string);
Код:
[17:38:14] [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 ''e' at line 1
[17:38:14] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
Reply


Messages In This Thread
MySQL error - by arkerooz - 10.10.2016, 16:48
Re: MySQL error - by HydraHumza - 10.10.2016, 16:59
Respuesta: Re: MySQL error - by arkerooz - 10.10.2016, 17:02
Re: MySQL error - by Konstantinos - 10.10.2016, 17:10
Respuesta: Re: MySQL error - by arkerooz - 10.10.2016, 17:29
Re: MySQL error - by Konstantinos - 10.10.2016, 17:36
Respuesta: Re: MySQL error - by arkerooz - 10.10.2016, 17:42
Re: MySQL error - by Konstantinos - 10.10.2016, 17:45
Re: MySQL error - by azzerking - 10.10.2016, 17:51
Respuesta: Re: MySQL error - by arkerooz - 10.10.2016, 19:23

Forum Jump:


Users browsing this thread: 1 Guest(s)