SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 07/07/2016, 11:31 AM   #1
Johhnyllll
Huge Clucker
 
Johhnyllll's Avatar
 
Join Date: Sep 2014
Posts: 253
Reputation: 12
Default CMySQLConnection::Disconnect - connection was closed | Help

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 ...
Johhnyllll is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[WARNING] CMySQLConnection::Disconnect - no connection available CSCripMa Scripting Help 0 12/02/2016 04:00 AM
[WARNING] CMySQLConnection::Disconnect - no connection available CrazyChoco Scripting Help 2 29/12/2015 07:17 PM
Server closed connection sscarface Scripting Help 2 27/05/2015 09:32 PM
Server Closed Connection ViktorRageWall Server Support 11 21/03/2012 06:49 PM
Server Closed The Connection.. matty34 Help Archive 6 11/08/2009 11:25 AM


All times are GMT. The time now is 03:57 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.