27.12.2015, 19:18
(
Последний раз редактировалось Banditul18; 28.12.2015 в 18:04.
)
How to resolve this error?
On register works perfectly, but when relog.....
Код:
[20:00:28] [DEBUG] mysql_connect - host: "127.0.0.1", user: "port_2531", database: "port_2531", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [20:00:28] [DEBUG] CMySQLHandle::Create - creating new connection.. [20:00:28] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [20:00:28] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [20:00:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:00:28] [DEBUG] CMySQLConnection::Connect - connection was successful [20:00:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:00:28] [DEBUG] mysql_errno - connection: 1 [20:00:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:00:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:00:28] [DEBUG] CMySQLConnection::Connect - connection was successful [20:00:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:00:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:00:28] [DEBUG] CMySQLConnection::Connect - connection was successful [20:00:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:00:28] [DEBUG] CMySQLConnection::Connect - connection was successful [20:00:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:01:28] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `IP`, `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1" [20:01:28] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `IP`, `Password`, `ID` FROM `players` WHERE `Username` = ", callback: "OnAccountCheck", format: "i" [20:01:28] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution [20:01:28] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.274 milliseconds [20:01:28] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:01:28] [DEBUG] Calling callback "OnAccountCheck".. [20:01:28] [DEBUG] cache_get_data - connection: 1 [20:01:28] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:01:31] [DEBUG] mysql_format - connection: 1, len: 300, format: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `VIP`,`Kills`,`Deaths`,`Score`, `Money`) VALUES ('%e', '%s', '%s',..." [20:01:31] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `V", callback: "OnAccountRegister", format: "i" [20:01:31] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution [20:01:32] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - query was successfully executed within 39.767 milliseconds [20:01:32] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:01:32] [DEBUG] Calling callback "OnAccountRegister".. [20:01:32] [DEBUG] cache_insert_id - connection: 1 [20:01:32] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:02:30] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `IP`, `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1" [20:02:30] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `IP`, `Password`, `ID` FROM `players` WHERE `Username` = ", callback: "OnAccountCheck", format: "i" [20:02:30] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution [20:02:30] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.607 milliseconds [20:02:30] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:02:30] [DEBUG] Calling callback "OnAccountCheck".. [20:02:30] [DEBUG] cache_get_data - connection: 1 [20:02:30] [DEBUG] cache_get_field_content - row: 0, field_name: "IP", connection: 1, max_len: 16 [20:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "IP", data: "109.98.164.64" [20:02:30] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Admin", connection: 1 [20:02:33] [WARNING] cache_get_field_content_int - no active cache [20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VIP", connection: 1 [20:02:33] [WARNING] cache_get_field_content_int - no active cache [20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Money", connection: 1 [20:02:33] [WARNING] cache_get_field_content_int - no active cache [20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Kills", connection: 1 [20:02:33] [WARNING] cache_get_field_content_int - no active cache [20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Deaths", connection: 1 [20:02:33] [WARNING] cache_get_field_content_int - no active cache [20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Score", connection: 1 [20:02:33] [WARNING] cache_get_field_content_int - no active cache [20:03:19] [DEBUG] mysql_format - connection: 1, len: 100, format: "UPDATE `players` SET `IP`='%s', `Admin`=%d, `VIP`=%d, `Kills`=%d, `Deaths`=%d, `Score`=%d, `Money`=%d WHERE `ID`=%d" [20:03:19] [ERROR] mysql_format - destination size is too small [20:03:19] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `IP`='109.98.164.64', `Admin`=0, `VIP`=0, `", callback: "(null)", format: "(null)" [20:03:19] [DEBUG] CMySQLQuery::Execute[] - starting query execution [20:03:19] [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 '' at line 1 [20:03:19] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError