Mysql Error - Printable Version

Mysql 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: Mysql Error (/showthread.php?tid=577026)

Mysql Error - nezo2001 - 08.06.2015

PHP код:



format(query, sizeof(query), "INSERT INTO houses (id, EntranceX, EntranceY, EntranceZ, ExitX, ExitY, ExitZ, InsideInt, owner, owned, price, text) VALUES ('%i', '%f', '%f', '%f', '%f', '%f', '%f', '%i', None, false, '%i', '%s')", id, x, y, z, exitx, exity, exitz, interior, price, draw);

log:

Код:

[14:03:34] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:03:35] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:03:35] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:03:35] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:20:06] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:20:07] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:20:07] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:20:07] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '127.0.0.1' (10061)
[14:30:25] [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 ''1022.479980' at line 1

But it connected and loaded players' info from the other table?!

Server log (debugg):

Код:

[14:37:29] [Query]: '/INSERT INTO houses (id, EntranceX, EntranceY, EntranceZ, ExitX, ExitY, ExitZ, InsideInt, owner, owned, price, text) VALUES ('1', '1419.790649', '-1623.835815', '13.546875', '225.630996', '1022.479980/'

Re: Mysql Error - nezo2001 - 09.06.2015

Bump!

Re: Mysql Error - Sithis - 09.06.2015

You have a forward slash in the syntax.

Re: Mysql Error - mamorunl - 09.06.2015

Also the words 'None' and 'false' are not between quotes.

Re: Mysql Error - nezo2001 - 10.06.2015

Ok I've fixed all of these and the same error, the error is after ExitY ?!

Re: Mysql Error - mamorunl - 10.06.2015

Your query length is probably too short. Make the variable longer.

Re: Mysql Error - nezo2001 - 10.06.2015

Worked Thank You