SA-MP Forums Archive
simple 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: simple error (/showthread.php?tid=618586)


simple error - StR_MaRy - 07.10.2016

why i get this error in mysql_log what is wrong

Код HTML:
[23:55:24 10/07/16] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'StR_Marian a folosit /fly' in 'field list' (Query: "INSERT INTO `*******rfeed` (`Text`,`Date`) VALUES (`StR_Marian a folosit /fly`,`07/10/2016 - 23:55:24`)")
and this is a pic with my structure from `*******rfeed`

http://imgur.com/a/2y8Oa

and the script is

Код HTML:
new *******rfeed[500];
		format(*******rfeed, sizeof(*******rfeed), "%s a folosit /fly", sendername);
		mysql_format(handle, gQuery, sizeof(gQuery), "INSERT INTO `*******rfeed` (`Text`,`Date`) VALUES (`%e`,`%e`)", *******rfeed, GetDate());
		mysql_tquery(handle, gQuery, "", "");


Re: simple error - Vince - 07.10.2016

There is a difference between ` (backtick) and ' (apostrophe). The first denotes an identifier (database, table, column, etc) the second denotes a literal string.

Re: simple error - StR_MaRy - 07.10.2016

thx man