Serverfile error ! syserr DB

În cazul în care aveţi o nelămurire postaţi aici, de asemenea este locul unde puteţi găsi posibile rezolvări la problemele dvs.
Conectat
Avatar utilizator
AlynDE
Nivel 1
Nivel 1
Mesaje: 79
Membru din: 11 Apr 2017
Status: Sunt bine mersi
Server Metin2: Sunt bine mersi
Regat: Shinsoo
Mulțumiri acordate: 11
Mulțumiri primite: 3

Serverfile error ! syserr DB

Mesajde AlynDE » 15 Mai 2019, 19:56

*Problemă:Apare la infinit ! deja crap !
Tipologie server:
*Resursă folosită:...
*ServerFiles utilizat:pvm impact
*Syserr:


Poză:
*Detalii suplimentare: in 10 min se face de 500MB syserr !

May 15 20:49:40 :: connecting to MySQL server (player)
May 15 20:49:40 :: CREATING DIRECT_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: CREATING MAIN_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: CREATING ASYNC_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: OK
May 15 20:49:40 :: connecting to MySQL server (account)
May 15 20:49:40 :: CREATING DIRECT_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: CREATING MAIN_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: CREATING ASYNC_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: OK
May 15 20:49:40 :: connecting to MySQL server (common)
May 15 20:49:40 :: CREATING DIRECT_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: CREATING MAIN_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: CREATING ASYNC_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: OK
May 15 20:49:40 :: connecting to MySQL server (hotbackup)
May 15 20:49:40 :: CREATING DIRECT_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: CREATING MAIN_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: CREATING ASYNC_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: OK
May 15 20:49:40 :: ClientManager initialization..
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: InitializeLocalization() - LoadLocaleTable(count:13)
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE0)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE1)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE2)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE3)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE4)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE5)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE6)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE7)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[LOCALE] = germany
May 15 20:49:40 :: Changed g_stLocale euckr to euckr
May 15 20:49:40 :: SetLocale start
May 15 20:49:40 :: End setlocale latin1
May 15 20:49:40 :: locale[DB_NAME_COLUMN] = locale_name
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_90)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_45)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: GetParam 2000000000
May 15 20:49:40 :: GetParam 2100000000
May 15 20:49:40 :: ItemRange From File 2000000000 ~ 2100000000
May 15 20:49:40 :: ItemIDRange: Build: 2000000000 ~ 2100000000 start:2000000000
May 15 20:49:40 :: Init Success Start 2000000000 End 2100000000 Now 2000000000

Vă rugăm să scanaţi întotdeauna fişierele pe care le descărcaţi cu VirusTotal.
Ultima oară modificat 15 Mai 2019, 20:53 de către AlynDE, modificat de 2 ori în total.

Deconectat
Avatar utilizator
Jyn
Nivel 1
Nivel 1
Mesaje: 67
Membru din: 17 Apr 2018
Localitate: Baia Mare
Status: Cat de cat
Regat: Shinsoo
Mulțumiri acordate: 9
Mulțumiri primite: 5

Re: Serverfile error ! syserr AUTH

Mesajde Jyn » 15 Mai 2019, 20:11

Cauta si tu in sursa linia ce iti da eroarea aia,sa vezi de ce iti apare eroarea aia, si dupa iti dai seama ce nu ii bine, daca stii cv c++ normal.
Dar cred ca iti lipseste ceva tabel dupa ce scrie acolo, nu is sigur, presupun. Se traduce astfel query ul ala, selecteaza (coloanele) name, text DIN (tabelul) ..
Imagine

Conectat
Avatar utilizator
[RaffaeL]
Utilizatorul Lunii Aprilie
Utilizatorul Lunii Aprilie
Mesaje: 2505
Membru din: 19 Mar 2016
Localitate: Everywhere
Reputație: ==================
► Helper Experimentat J4M
► Membru Club Permanent
==================
►Uituc -> pentru ca...am uitat
mai multe decat
altii vor sti vreodata.
==================
Status: Incerc sa ajut,cum stiu,cum pot..pe toti
Server Metin2: ...
Mulțumiri acordate: 3
Mulțumiri primite: 571
Contact:

Re: Serverfile error ! syserr AUTH

Mesajde [RaffaeL] » 15 Mai 2019, 20:15

AlynDE scrie:*Problemă:Apare la infinit ! deja crap !
Tipologie server:
*Resursă folosită:...
*ServerFiles utilizat:pvm impact
*Syserr:SYSERR: May 15 19:52:15 :: ChildLoop: AsyncSQL: query failed: Unknown column 'text' in 'field list' (query: SELECT name, text FROM string errno: 1054)

Poză:
*Detalii suplimentare: in 10 min se face de 500MB syserr !

SYSERR: May 15 19:52:15 :: ChildLoop: AsyncSQL: query failed: Unknown column 'text' in 'field list' (query: SELECT name, text FROM string errno: 1054)


Repara tabela string, sau ruleaza acest query in db player:

Cod: Selectaţi tot

DROP TABLE IF EXISTS `string`;
CREATE TABLE `string`  (
  `name` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `text` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  PRIMARY KEY (`name`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_german1_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
Imagine
Imagine
► Arată conținutul

► Arată conținutul

Conectat
Avatar utilizator
AlynDE
Nivel 1
Nivel 1
Mesaje: 79
Membru din: 11 Apr 2017
Status: Sunt bine mersi
Server Metin2: Sunt bine mersi
Regat: Shinsoo
Mulțumiri acordate: 11
Mulțumiri primite: 3

Re: Serverfile error ! syserr AUTH

Mesajde AlynDE » 15 Mai 2019, 20:51

EDIT ! VAD CA MAI APARE CEVA IN DB SERVERFILE !

May 15 20:49:40 :: connecting to MySQL server (player)
May 15 20:49:40 :: CREATING DIRECT_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: CREATING MAIN_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: CREATING ASYNC_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: OK
May 15 20:49:40 :: connecting to MySQL server (account)
May 15 20:49:40 :: CREATING DIRECT_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: CREATING MAIN_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: CREATING ASYNC_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: OK
May 15 20:49:40 :: connecting to MySQL server (common)
May 15 20:49:40 :: CREATING DIRECT_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: CREATING MAIN_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: CREATING ASYNC_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: OK
May 15 20:49:40 :: connecting to MySQL server (hotbackup)
May 15 20:49:40 :: CREATING DIRECT_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: CREATING MAIN_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: CREATING ASYNC_SQL
May 15 20:49:40 :: AsyncSQL: locale euckr
May 15 20:49:40 :: OK
May 15 20:49:40 :: ClientManager initialization..
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: --mysql_set_character_set(euckr)
May 15 20:49:40 :: InitializeLocalization() - LoadLocaleTable(count:13)
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE0)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE1)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE2)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE3)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE4)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE5)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE6)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL_TYPE7)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: locale[LOCALE] = germany
May 15 20:49:40 :: Changed g_stLocale euckr to euckr
May 15 20:49:40 :: SetLocale start
May 15 20:49:40 :: End setlocale latin1
May 15 20:49:40 :: locale[DB_NAME_COLUMN] = locale_name
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_90)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_DAMAGE_BY_LEVEL_UNDER_45)] = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
May 15 20:49:40 :: locale[UNKNOWN_KEY(SKILL_POWER_BY_LEVEL)] = 0 5 6 8 10 12 14 16 18 20 22 24
May 15 20:49:40 :: GetParam 2000000000
May 15 20:49:40 :: GetParam 2100000000
May 15 20:49:40 :: ItemRange From File 2000000000 ~ 2100000000
May 15 20:49:40 :: ItemIDRange: Build: 2000000000 ~ 2100000000 start:2000000000
May 15 20:49:40 :: Init Success Start 2000000000 End 2100000000 Now 2000000000

Conectat
Avatar utilizator
AlynDE
Nivel 1
Nivel 1
Mesaje: 79
Membru din: 11 Apr 2017
Status: Sunt bine mersi
Server Metin2: Sunt bine mersi
Regat: Shinsoo
Mulțumiri acordate: 11
Mulțumiri primite: 3

Re: Serverfile error ! syserr DB

Mesajde AlynDE » 16 Mai 2019, 19:21

Nimeni?

[ Postat de pe Android ] Imagine

Deconectat
Avatar utilizator
Titan
Helper Avansat
Helper Avansat
Mesaje: 2247
Membru din: 01 Iun 2015
Mulțumiri acordate: 28
Mulțumiri primite: 156
Contact:

Re: Serverfile error ! syserr DB

Mesajde Titan » Ieri, , 09:44

Prietene, mie mi se cam pare că ăla e syslog, nu syserr.
Salut, ai nevoie de un serverfiles clean sau la comandă, modificări ale serverfiles-ului existent sau suport? Mă poți contacta oricând.





Conectat
Avatar utilizator
Galeto
Nou Venit
Nou Venit
Mesaje: 16
Membru din: 26 Apr 2019
Mulțumiri acordate: 0
Mulțumiri primite: 0

Re: Serverfile error ! syserr DB

Mesajde Galeto » Ieri, , 11:44

ce ai dat tu acolo ii syslog, ii normal sa fie de 500mb
poti face un boolean sa ia valoarea din config pentru a dezactiva syslog daca doresti


Înapoi la “Probleme şi Întrebări”

Cine este conectat

Utilizatori ce ce navighează pe acest forum: [r00t1ng] și 4 vizitatori