MySQL Syntax 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)
+---- Forum: Help Archive (
https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL Syntax error. (
/showthread.php?tid=175032)
MySQL Syntax error. -
Toni - 08.09.2010
Hi there, I have a msql syntax error, that I can't seem to figure out.
This is the error in the mysql_log.txt.
Код:
[Tue Sep 07 19:51:28 2010] -------------------------
[Tue Sep 07 19:51:28 2010] Logging Started
[Tue Sep 07 19:51:28 2010] -------------------------
[Tue Sep 07 19:51:28 2010] Connected (0) to root @ localhost via TCP/IP.
[Tue Sep 07 19:51:28 2010] MySQL Version 5.1.36-community-log.
[Tue Sep 07 19:51:28 2010] Function: mysql_query executed: "SELECT * FROM `bizzinfo`" with result: "0".
[Tue Sep 07 19:51:28 2010] Function: mysql_store_result executed with result: "1"
[Tue Sep 07 19:51:28 2010] Function: mysql_num_rows executed with result: "".
[Tue Sep 07 19:51:28 2010] Function: mysql_free_result executed.
[Tue Sep 07 19:51:28 2010] Function: mysql_query executed: "INSERT INTO `bizzinfo` (BizzName, Owner, Price, PayAmount, EntX, EntY, EntZ) VALUES ('A Test', 'For Sale', 20000, 5000, 0.000000, 0.000000, 0.000000" with result: "1".
[Tue Sep 07 19:51:28 2010] Error (0): Failed to exeute query. 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 '' at line 1.
And this is the script.
pawn Код:
function CreateBusiness(Bizzname[], price, Float:EnterX, Float:EnterY, Float:EnterZ)
{
format(str, sizeof(str), "INSERT INTO `bizzinfo` (BizzName, Owner, Price, PayAmount, EntX, EntY, EntZ) VALUES ('%s', 'For Sale', %d, 5000, %f, %f, %f", Bizzname, price, EnterX, EnterY, EnterZ);
mysql_query(str);
return 1;
}
Please and thanks.
Код:
This forum requires that you wait 120 seconds between posts. Please try again in 15 seconds.
¬¬
Re: MySQL Syntax error. -
DiddyBop - 08.09.2010
Use g_stylezz plugin, his debugging is better to read.
@ topic, you missing a ")" At end of VALUES
Re: MySQL Syntax error. -
Toni - 08.09.2010
Oh!
Thanks, lol didn't see that x)