23.10.2014, 12:29
Estou com esses erros
Como resolver? Nгo tenho praticidade com sql to bem no inicio e me deparei com esse problema.
Код:
[10:17:25] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "server2", password: "****", port: 3306, autoreconnect: true, pool_size: 0 [10:17:25] [DEBUG] CMySQLHandle::Create - creating new connection.. [10:17:25] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [10:17:25] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [10:17:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [10:17:25] [DEBUG] CMySQLConnection::Connect - connection was successful [10:17:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [10:17:25] [DEBUG] mysql_errno - connection: 1 [10:17:25] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "server2", password: "****", port: 3306, autoreconnect: true, pool_size: 0 [10:17:25] [DEBUG] CMySQLHandle::Create - creating new connection.. [10:17:25] [WARNING] CMySQLHandle::Create - connection already exists [10:17:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [10:17:25] [DEBUG] CMySQLConnection::Connect - connection was successful [10:17:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [10:17:25] [DEBUG] mysql_errno - connection: 1 [10:17:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [10:17:25] [DEBUG] CMySQLConnection::Connect - connection was successful [10:17:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [10:17:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [10:17:25] [DEBUG] CMySQLConnection::Connect - connection was successful [10:17:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [10:17:44] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1" [10:17:44] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = 'teste", callback: "ChecarConta", format: "i" [10:17:44] [DEBUG] CMySQLQuery::Execute[ChecarConta] - starting query execution [10:17:44] [DEBUG] CMySQLQuery::Execute[ChecarConta] - query was successfully executed within 0.559 milliseconds [10:17:44] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [10:17:44] [DEBUG] Calling callback "ChecarConta".. [10:17:44] [DEBUG] cache_get_data - connection: 1 [10:17:44] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [10:17:49] [DEBUG] mysql_format - connection: 1, len: 128, format: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `ModoAdmin`, `Money`, `Genero`, `Skin`, `Org`,`Cargo`,`Doenca`,`Ma..." [10:17:49] [ERROR] mysql_format - destination size is too small [10:17:49] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `M", callback: "CriarConta", format: "i" [10:17:49] [DEBUG] CMySQLQuery::Execute[CriarConta] - starting query execution [10:17:49] [ERROR] CMySQLQuery::Execute[CriarConta] - (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 '' at line 1 [10:17:49] [DEBUG] CMySQLQuery::Execute[CriarConta] - error will be triggered in OnQueryError [10:17:53] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `players` SET `Admin`=%d, `ModoAdmin`=%d,`Money`=%d, `Genero`=%d, `Skin`=%d,`Org`=%d,`Cargo`=%d,`Doenca`=%d, WHERE `ID`=%..." [10:17:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=0, `ModoAdmin`=0,`Money`=0, `Genero", callback: "(null)", format: "(null)" [10:17:53] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `players` SET `Matou`=%d,`Morreu`=%d,`Casado`=%d,`Level`=%d,`Respeito`=%d,`Aviso`=%d,`Banido`=%d, WHERE `ID`=%d" [10:17:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Matou`=0,`Morreu`=0,`Casado`=0,`Level`=0,`", callback: "(null)", format: "(null)" [10:17:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution [10:17:53] [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 'WHERE `ID`=0' at line 1 [10:17:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError [10:17:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution [10:17:53] [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 'WHERE `ID`=0' at line 1 [10:17:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
