mySQL saving
#3

The connection is successful, yes.

There are errors in mysql_log
Код:
[19:11:20] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "deathmatch", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[19:11:20] [DEBUG] CMySQLHandle::Create - creating new connection..
[19:11:20] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[19:11:20] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[19:11:20] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[19:11:20] [DEBUG] CMySQLConnection::Connect - connection was successful
[19:11:20] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[19:11:20] [DEBUG] mysql_errno - connection: 1
[19:11:20] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[19:11:20] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[19:11:21] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[19:11:21] [WARNING] cache_get_field_content_int - no active cache
[19:11:21] [DEBUG] CMySQLConnection::Connect - connection was successful
[19:11:21] [DEBUG] CMySQLConnection::Connect - connection was successful
[19:11:21] [DEBUG] CMySQLConnection::Connect - connection was successful
[19:11:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[19:11:21] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Members", connection: 1
[19:11:21] [WARNING] cache_get_field_content_int - no active cache
[19:11:21] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Type", connection: 1
[19:11:21] [WARNING] cache_get_field_content_int - no active cache
[19:11:21] [DEBUG] cache_get_field_content - row: 0, field_name: "Name", connection: 1, max_len: 255
[19:11:21] [WARNING] cache_get_field_content - no active cache
[19:11:21] [DEBUG] cache_get_field_content - row: 0, field_name: "Rank1", connection: 1, max_len: 64
[19:11:21] [WARNING] cache_get_field_content - no active cache
[19:11:21] [DEBUG] cache_get_field_content - row: 0, field_name: "Rank2", connection: 1, max_len: 64
[19:11:21] [WARNING] cache_get_field_content - no active cache
[19:11:21] [DEBUG] cache_get_field_content - row: 0, field_name: "Rank3", connection: 1, max_len: 64
[19:11:21] [WARNING] cache_get_field_content - no active cache
[19:11:21] [DEBUG] cache_get_field_content - row: 0, field_name: "Rank4", connection: 1, max_len: 64
[19:11:21] [WARNING] cache_get_field_content - no active cache
[19:11:21] [DEBUG] cache_get_field_content - row: 0, field_name: "Leader", connection: 1, max_len: 24
[19:11:21] [WARNING] cache_get_field_content - no active cache
[19:11:21] [DEBUG] cache_get_field_content - row: 0, field_name: "Color", connection: 1, max_len: 7
[19:11:21] [WARNING] cache_get_field_content - no active cache
[19:11:30] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[19:11:30] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = 'Dexter' ", callback: "OnAccountCheck", format: "i"
[19:11:30] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[19:11:30] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.809 milliseconds
[19:11:30] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:11:30] [DEBUG] Calling callback "OnAccountCheck"..
[19:11:30] [DEBUG] cache_get_data - connection: 1
[19:11:30] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:11:33] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[19:11:33] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `Name` = 'Dexter' LIMIT 1", callback: "OnAccountLoad", format: "i"
[19:11:33] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution
[19:11:33] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.538 milliseconds
[19:11:33] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:11:33] [DEBUG] Calling callback "OnAccountLoad"..
[19:11:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Admin", connection: 1
[19:11:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[19:11:33] [ERROR] cache_get_field_content_int - invalid datatype
[19:11:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VIP", connection: 1
[19:11:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[19:11:33] [ERROR] cache_get_field_content_int - invalid datatype
[19:11:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Money", connection: 1
[19:11:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[19:11:33] [ERROR] cache_get_field_content_int - invalid datatype
[19:11:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Group", connection: 1
[19:11:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[19:11:33] [ERROR] cache_get_field_content_int - invalid datatype
[19:11:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "GroupRank", connection: 1
[19:11:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[19:11:33] [ERROR] cache_get_field_content_int - invalid datatype
[19:11:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Kills", connection: 1
[19:11:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[19:11:33] [ERROR] cache_get_field_content_int - invalid datatype
[19:11:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Deaths", connection: 1
[19:11:33] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[19:11:33] [ERROR] cache_get_field_content_int - invalid datatype
[19:11:34] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Score", connection: 1
[19:11:34] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[19:11:34] [ERROR] cache_get_field_content_int - invalid datatype
[19:11:34] [DEBUG] cache_get_field_content_int - row: 0, field_name: "HighKS", connection: 1
[19:11:34] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[19:11:34] [ERROR] cache_get_field_content_int - invalid datatype
[19:11:34] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
Reply


Messages In This Thread
mySQL saving - by NealPeteros - 02.01.2018, 09:57
Re: mySQL saving - by MEW273 - 02.01.2018, 10:00
Re: mySQL saving - by NealPeteros - 02.01.2018, 10:14
Re: mySQL saving - by NealPeteros - 02.01.2018, 21:50
Re: mySQL saving - by GTLS - 03.01.2018, 07:44
Re: mySQL saving - by NealPeteros - 03.01.2018, 09:56
Re: mySQL saving - by NealPeteros - 05.01.2018, 09:21
Re: mySQL saving - by NealPeteros - 06.01.2018, 07:53
Re: mySQL saving - by NealPeteros - 06.01.2018, 08:09
Re: mySQL saving - by MEW273 - 06.01.2018, 08:10

Forum Jump:


Users browsing this thread: 1 Guest(s)