Mysql Error
#1

PHP код:
format(querysizeof(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')"idxyzexitxexityexitzinteriorpricedraw); 
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/'
Reply


Messages In This Thread
Mysql Error - by nezo2001 - 08.06.2015, 12:41
Re: Mysql Error - by nezo2001 - 09.06.2015, 10:20
Re: Mysql Error - by Sithis - 09.06.2015, 11:45
Re: Mysql Error - by mamorunl - 09.06.2015, 11:58
Re: Mysql Error - by nezo2001 - 10.06.2015, 14:01
Re: Mysql Error - by mamorunl - 10.06.2015, 14:06
Re: Mysql Error - by nezo2001 - 10.06.2015, 14:12

Forum Jump:


Users browsing this thread: 1 Guest(s)