Serverfile error ! syserr DB

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

Utilizator interzis !
Mesaje: 124
Membru din: 11 Apr 2017, 13:05
Server: Sunt bine mersi
Regat: Shinsoo
Aprecieri: 27  
Mulţumiri: 776  
 Contact:
Vezi detalii
Medalii

*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.
Afișează semnătura
Sus
Avatar utilizator
Jyn
Nivel 1

Nivel 1
Mesaje: 67
Membru din: 17 Apr 2018, 21:35
Regat: Shinsoo
Aprecieri: 46  
Mulţumiri: 104  
Medalii

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
Afișează semnătura
Sus
Avatar utilizator
[RaffaeL]
Software Developer

Software Developer
Mesaje: 3223
Membru din: 19 Mar 2016, 12:58
Server: ...
Aprecieri: 15  
Mulţumiri: 2502  
  Rezolvări prob.: 2
Discord: Copiază ID
 Contact:
Vezi detalii
Medalii

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
https://www.youtube.com/watch?v=GhYkCIETEto
Do everything, if you know what you're doing, else... Imagine
Ma gasesti si aici: Discord https://discord.gg/5J5GnyZVSR
Afișează semnătura
Sus
Avatar utilizator
AlynDE
Utilizator interzis !

Utilizator interzis !
Mesaje: 124
Membru din: 11 Apr 2017, 13:05
Server: Sunt bine mersi
Regat: Shinsoo
Aprecieri: 27  
Mulţumiri: 776  
 Contact:
Vezi detalii
Medalii

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
Afișează semnătura
Sus
Avatar utilizator
AlynDE
Utilizator interzis !

Utilizator interzis !
Mesaje: 124
Membru din: 11 Apr 2017, 13:05
Server: Sunt bine mersi
Regat: Shinsoo
Aprecieri: 27  
Mulţumiri: 776  
 Contact:
Vezi detalii
Medalii

Nimeni?

[ Postat de pe Android ] Imagine
Afișează semnătura
Sus
Avatar utilizator
Titan
Metin Master

Metin Master
Mesaje: 2783
Membru din: 01 Iun 2015, 15:09
Server: In curand.
Regat: Chunjo
Aprecieri: 42  
Mulţumiri: 377  
  Rezolvări prob.: 3
Discord: Copiază ID
 Contact:
Vezi detalii
Medalii

Prietene, mie mi se cam pare că ăla e syslog, nu syserr.
Pentru acest mesaj, Titan a primit 2 (de) mulţumiri
BeauDeCiuda • Reme
Imagine
Afișează semnătura
Sus
Avatar utilizator
Galeto
Nou Venit

Nou Venit
Mesaje: 36
Membru din: 26 Apr 2019, 18:41
Aprecieri: 2  
Mulţumiri: 8  
Medalii

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
Sus
Închis
error Syserr ServerFile >DB
Răspunsuri
1 Vizualizări
164
Citește mai mult
Syserr Serverfile DB !!!!! Error
Răspunsuri
2 Vizualizări
194
Citește mai mult
syserr error.. log ch1
Răspunsuri
1 Vizualizări
470
Citește mai mult
syserr error
Răspunsuri
0 Vizualizări
248
Citește mai mult

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

  • Informaţie

  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 19 vizitatori

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