CMySQLConnection::Disconnect - connection was closed | Help
#1

Hi, I'm doing RP server to MySQL R39-5, and faced with such a problem, when you exit from the game is not overwritten by the new data, I use ORM for this. I do not know already what the problem is ...
Translated by translate.******.com
PHP Code:
public OnPlayerDisconnect(playeridreason)
{
    if (
P[playerid][_p_ormid]) {
        if (
P[playerid][_p_in_game] == true)
            
orm_update(P[playerid][_p_ormid]);
        
orm_destroy(P[playerid][_p_ormid]);
    }
    for (new 
0sizeof(P[]); i++)
        
P[playerid][E_PLAYER_DATAi] = 0;
    
TextDrawDestroy(Logo);
    return 
1;

MySQL.log
PHP Code:
[14:26:09] [DEBUGmysql_connect host"localhost"user"root"database"corso"password"****"port3306autoreconnecttruepool_size2
[14:26:09] [DEBUGCMySQLHandle::Create creating new connection..
[
14:26:09] [DEBUGCMySQLHandle::CMySQLHandle constructor called
[14:26:09] [DEBUGCMySQLHandle::Create connection created (id1)
[
14:26:09] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
14:26:09] [DEBUGCMySQLConnection::Connect connection was successful
[14:26:09] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[14:26:09] [DEBUGmysql_errno connection1
[14:26:09] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
14:26:09] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
14:26:09] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
14:26:09] [DEBUGCMySQLConnection::Connect connection was successful
[14:26:09] [DEBUGCMySQLConnection::Connect connection was successful
[14:26:09] [DEBUGCMySQLConnection::Connect connection was successful
[14:26:09] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[14:26:09] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[14:27:02] [DEBUGmysql_connect host"localhost"user"root"database"corso"password"****"port3306autoreconnecttruepool_size2
[14:27:02] [DEBUGCMySQLHandle::Create creating new connection..
[
14:27:02] [DEBUGCMySQLHandle::CMySQLHandle constructor called
[14:27:02] [DEBUGCMySQLHandle::Create connection created (id1)
[
14:27:02] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
14:27:02] [DEBUGCMySQLConnection::Connect connection was successful
[14:27:02] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[14:27:02] [DEBUGmysql_errno connection1
[14:27:02] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
14:27:02] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
14:27:02] [DEBUGCMySQLConnection::Connect establishing connection to database...
[
14:27:02] [DEBUGCMySQLConnection::Connect connection was successful
[14:27:02] [DEBUGCMySQLConnection::Connect connection was successful
[14:27:02] [DEBUGCMySQLConnection::Connect connection was successful
[14:27:02] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[14:27:02] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[14:27:02] [DEBUGCMySQLConnection::Connect auto-reconnect has been enabled
[14:27:45] [DEBUGorm_create table"accounts"connectionHandle1
[14:27:46] [DEBUGCOrm::Create creating new orm object..
[
14:27:46] [DEBUGCOrm::Create orm object created (id1)
[
14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316CD78varname"UID"
[14:27:46] [DEBUGorm_addvar_string orm_id1, var: 0316CD7Cvar_maxlen25varname"Name"
[14:27:46] [DEBUGorm_addvar_string orm_id1, var: 0316CDE0var_maxlen129varname"Password"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316CFE4varname"Access"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316CFE8varname"Skin"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316CFECvarname"Cash"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316CFF0varname"Job_Team"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316CFF4varname"Lic_Moto"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316CFF8varname"Lic_Car"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316CFFCvarname"Lic_Freight"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316D000varname"Lic_Boat"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316D004varname"Lic_Helicopter"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316D008varname"Lic_Aircraft"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316D00Cvarname"Lic_Business"
[14:27:46] [DEBUGorm_addvar_int orm_id1, var: 0316D010varname"Lic_Weapon"
[14:27:46] [DEBUGorm_setkey orm_id1varname"Name"
[14:27:46] [DEBUGorm_select orm_id1callback"OnMySQL_SelectAccount"format"d"
[14:27:46] [DEBUGorm_select generated query"SELECT `UID`,`Password`,`Access`,`Skin`,`Cash`,`Job_Team`,`Lic_M"
[14:27:46] [DEBUGCMySQLQuery::Execute[OnMySQL_SelectAccount] - starting query execution
[14:27:46] [DEBUGCMySQLQuery::Execute[OnMySQL_SelectAccount] - query was successfully executed within 294.226 milliseconds
[14:27:46] [DEBUGCMySQLResult::CMySQLResult() - constructor called
[14:27:46] [DEBUGCMySQLResult::GetRowData row'0'field'0'data"1"
[14:27:46] [DEBUGCMySQLResult::GetRowData row'0'field'1'data"0DFE0DAC1797504EA997FDB298D22BD872397AA63127F224CC1E7CB65F34F4736C9783F9C01F1C53359219754A33E71A5250D355EF9AF2827254442F1DBF0471"
[14:27:46] [DEBUGCMySQLResult::GetRowData row'0'field'2'data"7"
[14:27:46] [DEBUGCMySQLResult::GetRowData row'0'field'3'data"296"
[14:27:46] [DEBUGCMySQLResult::GetRowData row'0'field'4'data"588"
[14:27:46] [DEBUGCMySQLResult::GetRowData row'0'field'5'data"0"
[14:27:46] [DEBUGCMySQLResult::GetRowData row'0'field'6'data"0"
[14:27:46] [DEBUGCMySQLResult::GetRowData row'0'field'7'data"1"
[14:27:47] [DEBUGCMySQLResult::GetRowData row'0'field'8'data"0"
[14:27:47] [DEBUGCMySQLResult::GetRowData row'0'field'9'data"0"
[14:27:47] [DEBUGCMySQLResult::GetRowData row'0'field'10'data"0"
[14:27:47] [DEBUGCMySQLResult::GetRowData row'0'field'11'data"0"
[14:27:47] [DEBUGCMySQLResult::GetRowData row'0'field'12'data"0"
[14:27:47] [DEBUGCMySQLResult::GetRowData row'0'field'13'data"0"
[14:27:47] [DEBUGCalling callback "OnMySQL_SelectAccount"..
[
14:27:47] [DEBUGorm_errno orm_id1
[14:27:47] [DEBUGorm_setkey orm_id1varname"UID"
[14:27:47] [DEBUGCMySQLResult::~CMySQLResult() - deconstructor called
[14:28:14] [DEBUGorm_update orm_id1
[14:28:14] [DEBUGorm_update generated query"UPDATE `accounts` SET `Password`='0DFE0DAC1797504EA997FDB298D22B"
[14:28:14] [DEBUGCMySQLQuery::Execute[] - starting query execution
[14:28:15] [DEBUGCMySQLQuery::Execute[] - query was successfully executed within 244.418 milliseconds
[14:28:15] [DEBUGCMySQLQuery::Execute[] - no callback specifiedskipping result saving
[14:28:21] [DEBUGorm_update orm_id1
[14:28:21] [DEBUGorm_update generated query"UPDATE `accounts` SET `Password`='0DFE0DAC1797504EA997FDB298D22B"
[14:28:21] [DEBUGorm_destroy orm_id1
[14:28:21] [DEBUGCMySQLQuery::Execute[] - starting query execution
[14:28:21] [DEBUGCOrm::Destroy orm object destroyed (id1)
[
14:28:21] [DEBUGCMySQLQuery::Execute[] - query was successfully executed within 204.694 milliseconds
[14:28:21] [DEBUGCMySQLQuery::Execute[] - no callback specifiedskipping result saving
[14:28:27] [DEBUGmysql_close connection1
[14:28:28] [DEBUGCMySQLConnection::Disconnect connection was closed
[14:28:28] [DEBUGCMySQLConnection::Disconnect connection was closed
[14:28:28] [DEBUGCMySQLConnection::Disconnect connection was closed
[14:28:28] [DEBUGCMySQLConnection::Disconnect connection was closed
[14:28:28] [WARNINGCMySQLConnection::Disconnect no connection available
[14:28:28] [DEBUGCMySQLHandle::~CMySQLHandle deconstructor called 
I do not know why it can not connect to MySQL, please help ...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)