Serverfile error ! syserr DB

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Neconectat
Avatar utilizator
AlynDE
Utilizator interzis !

Utilizator interzis !
Mesaje: 127
Membru din: 11 Apr 2017, 13:05
Status: Sunt bine mersi
Server Metin2: Sunt bine mersi
Regat: Shinsoo
Mulţumiri acordate: 29  
Mulţumiri primite: 44  
Contact:

Serverfile error ! syserr DB

Mesaj de 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
Ultima oară modificat 15 Mai 2019, 20:53 de către AlynDE, modificat de 2 ori în total.

Neconectat
Avatar utilizator
Jyn
Nivel 1

Nivel 1
Mesaje: 67
Membru din: 17 Apr 2018, 21:35
Localitate: Cluj Napoca
Status: Cat de cat
Regat: Shinsoo
Mulţumiri acordate: 17  
Mulţumiri primite: 35  

Re: Serverfile error ! syserr AUTH

Mesaj de 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

Neconectat
Avatar utilizator
[RaffaeL]
Software Developer

Software Developer
Mesaje: 3121
Membru din: 19 Mar 2016, 12:58
Reputație: ®™
▬▬▬▬▬▬▬▬▬▬▬▬▬▬
• Lider Helperi Experimentati
• Lider Helperi Avansati
• Lider Helperi
• Lider Trial Helperi
▬▬▬▬▬▬▬▬▬▬▬▬▬▬
• Super Ad Moderator J4M
▬▬▬▬▬▬▬▬▬▬▬▬▬▬
• Membru Club Permanent
▬▬▬▬▬▬▬▬▬▬▬▬▬▬
**********UITUC**********
Pentru ca...am uitat mai multe
decat altii vor sti vreodata.©
▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Server Metin2: ...
Mulţumiri acordate: 3  
Mulţumiri primite: 926  
Discord: [RaffaeL]#5956
Contact:

Re: Serverfile error ! syserr AUTH

Mesaj de [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;
Pentru acest mesaj, [RaffaeL] for the post:
AlynDE
Imagine
Imagine
Do everything, if you know what you're doing, else... Imagine
► Arată conținutul

Neconectat
Avatar utilizator
AlynDE
Utilizator interzis !

Utilizator interzis !
Mesaje: 127
Membru din: 11 Apr 2017, 13:05
Status: Sunt bine mersi
Server Metin2: Sunt bine mersi
Regat: Shinsoo
Mulţumiri acordate: 29  
Mulţumiri primite: 44  
Contact:

Re: Serverfile error ! syserr AUTH

Mesaj de 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

Neconectat
Avatar utilizator
AlynDE
Utilizator interzis !

Utilizator interzis !
Mesaje: 127
Membru din: 11 Apr 2017, 13:05
Status: Sunt bine mersi
Server Metin2: Sunt bine mersi
Regat: Shinsoo
Mulţumiri acordate: 29  
Mulţumiri primite: 44  
Contact:

Re: Serverfile error ! syserr DB

Mesaj de AlynDE » 16 Mai 2019, 19:21

Nimeni?

[ Postat de pe Android ] Imagine

Conectat
Avatar utilizator
Titan
Helper Avansat

Helper Avansat
Mesaje: 2629
Membru din: 01 Iun 2015, 15:09
Autentificat prin: Android
Mulţumiri acordate: 39  
Mulţumiri primite: 244  
Discord: Unknown.#3117
Contact:

Re: Serverfile error ! syserr DB  [Problemă Rezolvată]

Mesaj de Titan » 19 Mai 2019, 09:44

Prietene, mie mi se cam pare că ăla e syslog, nu syserr.
Pentru acest mesaj, Titan a primit 2 (de) mulţumiri
BeauDeCiudaReme
Salut, ai nevoie de un serverfiles clean sau la comandă, modificări ale serverfiles-ului existent sau suport? Mă poți contacta oricând.

Neconectat
Avatar utilizator
Galeto
Nou Venit

Nou Venit
Mesaje: 36
Membru din: 26 Apr 2019, 18:41
Mulţumiri acordate: 3  
Mulţumiri primite: 5  

Re: Serverfile error ! syserr DB

Mesaj de Galeto » 19 Mai 2019, 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

Închis

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