Am urmatoarea problema !

Înainte de a posta o problemă, caută în acest forum și poate găsești rezolvare.
Închis
Avatar utilizator
maryan184378
Utilizator interzis !

Utilizator interzis !
Mesaje: 322
Membru din: 11 Aug 2014, 22:25
Server: Metin2Asura
Regat: Jinno
Aprecieri: 2  
Mulţumiri: 39  
Medalii

*Problemă:Problema depozit tot ce bag in el si dau sa intru inapoi nu mai exista dispare , rezolvare? si dupa relog face la fel vreo rezolvare?
Tipologie server(PvM / PvP):PvM
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat:Un sv eren2
*Syserr:
SYSERR: Dec 28 11:00:40 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, transmutation, socket0, socket1, socket2, attrtype0, attrvalue0,attrtype1, attrvalue1,attrtype2, attrvalue2,attrtype3, attrvalue3,attrtype4, attrvalue4,attrtype5, attrvalue5,attrtype6, attrvalue6,applytype0, applyvalue0,applytype1, applyvalue1,applytype2, applyvalue2,applytype3, applyvalue3,applytype4, applyvalue4,applytype5, applyvalue5,applytype6, applyvalue6,applytype7, applyvalue7)VALUES(10000004, 1, 3, 30, 1, 6079, 0, 1, 1, 1, 72, 60, 71, -39, 16, 10, 22, 20, 5, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 696238152) errno: 1136)
SYSERR: Dec 28 11:03:29 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: REPLACE INTO quest (dwPID, szName, szState, lValue) VALUES(0, '[OwN]Herry', '', 0) errno: 1317)
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: query failed: Query execution was interrupted (query: UPDATE player SET job = 8, voice = 0, dir = 0, x = 2114825, y = 3549366, z = 0, map_index = 247, exit_x = 2114825, exit_y = 3549366, exit_map_index = 247, hp = 16128, mp = 2741, stamina = 910, random_hp = 4998, random_sp = 2261, playtime = 188, level = 120, level_step = 3, st = 6, ht = 6, dx = 2, iq = 2, gold = 3028709, gaya = 0, exp = 455413, stat_point = 315, skill_point = 119, sub_skill_point = 111, stat_reset_count = 0, ip = '192.168.1.102', part_main = 21089, part_hair = 0, part_acce = 0, last_play = NOW(), skill_group = 0, alignment = 1085, horse_level = 21, horse_riding = 0, horse_hp = 35, horse_hp_droptime = 1546250432, horse_stamina = 120, horse_skill_point = 0, t_choosed = 6, t_available = '0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, transmutation, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(10000001, 31308, 2, 0, 1, 21089, 0, 1, 1, 1, 1, 2000, 9, 20, 23, 10, 39, 10, 53, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002)
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, transmutation, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(10000001, 31308, 2, 0, 1, 21089, 0, 1, 1, 1, 1, 2000, 9, 20, 23, 10, 39, 10, 53, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002)
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, transmutation, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(10000001, 31308, 2, 0, 1, 21089, 0, 1, 1, 1, 1, 2000, 9, 20, 23, 10, 39, 10, 53, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002)
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, transmutation, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(10000001, 31308, 2, 0, 1, 21089, 0, 1, 1, 1, 1, 2000, 9, 20, 23, 10, 39, 10, 53, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002)
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, transmutation, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(10000001, 31308, 2, 0, 1, 21089, 0, 1, 1, 1, 1, 2000, 9, 20, 23, 10, 39, 10, 53, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002)
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, transmutation, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(10000001, 31308, 2, 0, 1, 21089, 0, 1, 1, 1, 1, 2000, 9, 20, 23, 10, 39, 10, 53, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002)
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: retrying
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: REPLACE INTO item (id, owner_id, window, pos, count, vnum, transmutation, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7) VALUES(10000001, 31308, 2, 0, 1, 21089, 0, 1, 1, 1, 1, 2000, 9, 20, 23, 10, 39, 10, 53, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 2002)
SYSERR: Dec 28 11:03:29 :: ChildLoop: AsyncSQL: retrying
Poză:nu am
*Detalii suplimentare:
Imagine
Afișează semnătura
Sus
Avatar utilizator
Nicolescu Radu
Membru Club

Membru Club
Mesaje: 1728
Membru din: 11 Noi 2017, 09:50
Server: Eruris2
Regat: Jinno
Aprecieri: 0
Mulţumiri: 96  
 Contact:
Vezi detalii
Medalii

Incearca asta :
In sursa DB in fisierul ClientManager.cpp cauti functia :

Cod: Selectaţi tot

"REPLACE INTO item%s (id, owner_id, window, pos, count, vnum, bind, transmutation, socket0, socket1, socket2, "
2 linii mai sus gasesti char szQuery[512] si modifici cu

Cod: Selectaţi tot

char szQuery[QUERY_MAX_LEN];
► Daca crezi ca te-am ajutat , sau iti place mesajul meu nu uita sa dai un LIKE !◄
Afișează semnătura
Sus
Avatar utilizator
maryan184378
Utilizator interzis !

Utilizator interzis !
Mesaje: 322
Membru din: 11 Aug 2014, 22:25
Server: Metin2Asura
Regat: Jinno
Aprecieri: 2  
Mulţumiri: 39  
Medalii

Nicolescu Radu scrie:Incearca asta :
In sursa DB in fisierul ClientManager.cpp cauti functia :

Cod: Selectaţi tot

"REPLACE INTO item%s (id, owner_id, window, pos, count, vnum, bind, transmutation, socket0, socket1, socket2, "
2 linii mai sus gasesti char szQuery[512] si modifici cu

Cod: Selectaţi tot

char szQuery[QUERY_MAX_LEN];
Multumesc dar am facut deja asta !
Imagine
Afișează semnătura
Sus
Avatar utilizator
maryan184378
Utilizator interzis !

Utilizator interzis !
Mesaje: 322
Membru din: 11 Aug 2014, 22:25
Server: Metin2Asura
Regat: Jinno
Aprecieri: 2  
Mulţumiri: 39  
Medalii

Am gasit eu solutia trebuia schimba-te liniile asa !
FIXARE PENTRU CINE MAI VREA ! :
#ifdef __CHANGELOOK_SYSTEM__
char szQuery[512 + 27];
#else
char szQuery[512];
#endif

snprintf(szQuery, sizeof(szQuery),
"REPLACE INTO item%s ("
"id, "
"owner_id, "
"window, "
"pos, "
"count, "
"vnum, "
#ifdef __CHANGELOOK_SYSTEM__
"transmutation, "
#endif
"socket0, "
"socket1, "
"socket2, "
"attrtype0, "
"attrvalue0, "
"attrtype1, "
"attrvalue1, "
"attrtype2, "
"attrvalue2, "
"attrtype3, "
"attrvalue3, "
"attrtype4, "
"attrvalue4, "
"attrtype5, "
"attrvalue5, "
"attrtype6, "
"attrvalue6"
") VALUES("
"%u, "
"%u, "
"%d, "
"%d, "
"%u, "
"%u, "
#ifdef __CHANGELOOK_SYSTEM__
"%u, "
#endif
"%ld, "
"%ld, "
"%ld, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d, "
"%d"
")"
,
GetTablePostfix(),
p->id,
p->owner,
p->window,
p->pos,
p->count,
p->vnum,
#ifdef __CHANGELOOK_SYSTEM__
p->transmutation,
#endif
p->alSockets[0],
p->alSockets[1],
p->alSockets[2],
p->aAttr[0].bType, p->aAttr[0].sValue,
p->aAttr[1].bType, p->aAttr[1].sValue,
p->aAttr[2].bType, p->aAttr[2].sValue,
p->aAttr[3].bType, p->aAttr[3].sValue,
p->aAttr[4].bType, p->aAttr[4].sValue,
p->aAttr[5].bType, p->aAttr[5].sValue,
p->aAttr[6].bType, p->aAttr[6].sValue
);

CDBManager::instance().ReturnQuery(szQuery, QID_ITEM_SAVE, pkPeer->GetHandle(), NULL);
}
#ifdef __AUCTION__
else if (p->window == AUCTION)
{
sys_err("invalid window. how can you enter this route?");
return ;
}
#endif
else
{
if (g_test_server)
sys_log(0, "QUERY_ITEM_SAVE => PutItemCache() owner %d id %d vnum %d ", p->owner, p->id, p->vnum);

PutItemCache(p);
}
}
Imagine
Afișează semnătura
Sus
Avatar utilizator
Filipino
Metin Master

Metin Master
Mesaje: 2789
Membru din: 03 Sep 2014, 21:02
Server: ▬▬▬▬▬▬
Aprecieri: 39  
Mulţumiri: 785  
Discord: Copiază ID
Medalii

rezolvat
Imagine
Afișează semnătura
Sus
Închis

Înapoi la “Probleme rezolvate”

  • Informaţie

  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Semrush [Bot] și 29 vizitatori

+ Anunțul tău aici + Anunțul tău aici + Anunțul tău aici + Anunțul tău aici