[GameMode] Simple MySQL R39-3 v1.0
#16

How to resolve this error?
Код:
[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
On register works perfectly, but when relog.....
Reply


Messages In This Thread
Simple MySQL R39-3 v1.0 - by JeaSon - 01.04.2015, 18:35
Re: Simple MySQL R9-3 v1.0 - by Alex Magaсa - 01.04.2015, 18:53
Re: Simple MySQL R9-3 v1.0 - by Younes44 - 01.04.2015, 19:26
Re: Simple MySQL R9-3 v1.0 - by Abagail - 01.04.2015, 20:16
Re: Simple MySQL R9-3 v1.0 - by JeaSon - 02.04.2015, 03:36
Re: Simple MySQL R9-3 v1.0 - by SpikY_ - 02.04.2015, 14:13
Re : Re: Simple MySQL R9-3 v1.0 - by nicolaskettler - 02.04.2015, 14:17
Re: Re : Re: Simple MySQL R9-3 v1.0 - by JeaSon - 02.04.2015, 14:43
Re: Simple MySQL R9-3 v1.0 - by MohanedZzZ - 02.04.2015, 15:31
Re : Re: Re : Re: Simple MySQL R9-3 v1.0 - by nicolaskettler - 02.04.2015, 16:11
MohanedZzZ - by JeaSon - 03.04.2015, 04:05
Re: Simple MySQL R9-3 v1.0 - by LazyB0y - 09.04.2015, 13:11
Re: Simple MySQL R39-3 v1.0 - by yvoms - 08.11.2015, 18:17
Re: Simple MySQL R39-3 v1.0 - by JeaSon - 09.11.2015, 05:30
[No subject] - by yvoms - 09.11.2015, 11:21
Re: Simple MySQL R39-3 v1.0 - by Banditul18 - 27.12.2015, 19:18
Re: Simple MySQL R39-3 v1.0 - by Loinal - 22.09.2016, 19:05
Re: Simple MySQL R39-3 v1.0 - by Slawiii - 23.09.2016, 10:50
[No subject] - by Loinal - 24.11.2016, 17:12
Re: Simple MySQL R39-3 v1.0 - by Tenka - 05.12.2016, 09:36
Re: Simple MySQL R39-3 v1.0 - by Loinal - 10.12.2016, 19:17
Re: Simple MySQL R39-3 v1.0 - by Loinal - 11.12.2016, 16:58
Re: Simple MySQL R39-3 v1.0 - by Loinal - 13.12.2016, 16:50
Re: Simple MySQL R39-3 v1.0 - by iLearner - 13.12.2016, 16:59
Re: Simple MySQL R39-3 v1.0 - by Eddye - 14.12.2016, 01:29
Re: Simple MySQL R39-3 v1.0 - by Loinal - 15.12.2016, 07:03
Re: Simple MySQL R39-3 v1.0 - by Loinal - 15.12.2016, 16:21
Re: Simple MySQL R39-3 v1.0 - by Loinal - 05.01.2017, 14:20
Re: Simple MySQL R39-3 v1.0 - by PhoneixViper - 05.01.2017, 14:56

Forum Jump:


Users browsing this thread: 1 Guest(s)