Yardım hildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket'

  • Konuyu açan Konuyu açan Tengrist
  • Açılış Tarihi Açılış Tarihi
  • Yanıt Yanıt 9
  • Gösterim Gösterim 157
Konu sahibi bu konuda soru soruyor. Sorusu ile ilgili bilgisi olanların yanıtlamasını bekliyor.

Tengrist

Yardımsever Üye
Yardımsever Üye
MT Üye
Mesaj
895
Çözümler
35
Beğeni
639
Puan
909
Ticaret Puanı
0
hatalar sys:
Genişlet Daralt Kopyala
SYSERR: Oct 15 00:21:02 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 6864356, y = 530916, z = 0, map_index = 704, exit_x = 6864356, exit_y = 530916, exit_map_index = 704, hp = 68814, mp = 4013, stamina = 820, random_hp = 2575, random_sp = 1318, title = 0, rebirt = 0, reborn = 0, playtime = 186, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 18701000000, exp = 0, stat_point = 344, skill_point = 119, sub_skill_point = 81, stat_reset_count = 0, ip = '192.168.1.102', part_main = 11699, part_hair = 0, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 355586, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729199751, horse_stamina = 200, horse_skill_point = 0, title_memleket = 250, kesilen_metin = 0, kesilen_patron = 2360, acilan_sandik = 3, metinHasar = 45584, patronHasar = 38195948, statistics_jinno_kills = 0, statistics_shinsoo_k
SYSERR: Oct 15 00:42:59 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1332463, y = 1069589, z = 0, map_index = 717, exit_x = 1332463, exit_y = 1069589, exit_map_index = 717, hp = 66570, mp = 3579, stamina = 820, random_hp = 4760, random_sp = 2499, title = 15, rebirt = 0, reborn = 0, playtime = 95, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 9110304022, exp = 0, stat_point = 360, skill_point = 119, sub_skill_point = 111, stat_reset_count = 0, ip = '192.168.1.102', part_main = 7692, part_hair = 570, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 100065, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729201066, horse_stamina = 200, horse_skill_point = 0, title_memleket = 254, kesilen_metin = 0, kesilen_patron = 0, acilan_sandik = 0, metinHasar = 0, patronHasar = 0, statistics_jinno_kills = 0, statistics_shinsoo_kills = 0, s
SYSERR: Oct 15 00:54:25 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1332478, y = 1071492, z = 0, map_index = 717, exit_x = 1332478, exit_y = 1071492, exit_map_index = 717, hp = 66566, mp = 3579, stamina = 820, random_hp = 4760, random_sp = 2499, title = 15, rebirt = 0, reborn = 0, playtime = 96, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 9110304022, exp = 0, stat_point = 360, skill_point = 119, sub_skill_point = 111, stat_reset_count = 0, ip = '192.168.1.102', part_main = 7692, part_hair = 570, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 100065, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729200095, horse_stamina = 200, horse_skill_point = 0, title_memleket = 254, kesilen_metin = 0, kesilen_patron = 0, acilan_sandik = 0, metinHasar = 0, patronHasar = 0, statistics_jinno_kills = 0, statistics_shinsoo_kills = 0, s
SYSERR: Oct 15 00:57:26 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1332478, y = 1071492, z = 0, map_index = 717, exit_x = 1332478, exit_y = 1071492, exit_map_index = 717, hp = 66570, mp = 3579, stamina = 820, random_hp = 4760, random_sp = 2499, title = 15, rebirt = 0, reborn = 0, playtime = 99, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 9110304022, exp = 0, stat_point = 360, skill_point = 119, sub_skill_point = 111, stat_reset_count = 0, ip = '192.168.1.102', part_main = 7692, part_hair = 570, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 100065, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729202002, horse_stamina = 200, horse_skill_point = 0, title_memleket = 254, kesilen_metin = 0, kesilen_patron = 0, acilan_sandik = 0, metinHasar = 0, patronHasar = 0, statistics_jinno_kills = 0, statistics_shinsoo_kills = 0, s
SYSERR: Oct 15 01:00:27 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1332478, y = 1071492, z = 0, map_index = 717, exit_x = 1332478, exit_y = 1071492, exit_map_index = 717, hp = 66570, mp = 3579, stamina = 820, random_hp = 4760, random_sp = 2499, title = 15, rebirt = 0, reborn = 0, playtime = 102, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 9110304022, exp = 0, stat_point = 360, skill_point = 119, sub_skill_point = 111, stat_reset_count = 0, ip = '192.168.1.102', part_main = 7692, part_hair = 570, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 100065, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729202002, horse_stamina = 200, horse_skill_point = 0, title_memleket = 254, kesilen_metin = 0, kesilen_patron = 0, acilan_sandik = 0, metinHasar = 0, patronHasar = 0, statistics_jinno_kills = 0, statistics_shinsoo_kills = 0,
SYSERR: Oct 15 01:03:28 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1332450, y = 1071163, z = 0, map_index = 717, exit_x = 1332450, exit_y = 1071163, exit_map_index = 717, hp = 66570, mp = 3579, stamina = 820, random_hp = 4760, random_sp = 2499, title = 15, rebirt = 0, reborn = 0, playtime = 105, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 9110304022, exp = 0, stat_point = 360, skill_point = 119, sub_skill_point = 111, stat_reset_count = 0, ip = '192.168.1.102', part_main = 7692, part_hair = 570, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 100065, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729202002, horse_stamina = 200, horse_skill_point = 0, title_memleket = 254, kesilen_metin = 0, kesilen_patron = 0, acilan_sandik = 0, metinHasar = 0, patronHasar = 0, statistics_jinno_kills = 0, statistics_shinsoo_kills = 0,
SYSERR: Oct 15 01:06:29 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1332450, y = 1071163, z = 0, map_index = 717, exit_x = 1332450, exit_y = 1071163, exit_map_index = 717, hp = 66570, mp = 3579, stamina = 820, random_hp = 4760, random_sp = 2499, title = 15, rebirt = 0, reborn = 0, playtime = 108, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 9110304022, exp = 0, stat_point = 360, skill_point = 119, sub_skill_point = 111, stat_reset_count = 0, ip = '192.168.1.102', part_main = 7692, part_hair = 570, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 100065, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729202002, horse_stamina = 200, horse_skill_point = 0, title_memleket = 254, kesilen_metin = 0, kesilen_patron = 0, acilan_sandik = 0, metinHasar = 0, patronHasar = 0, statistics_jinno_kills = 0, statistics_shinsoo_kills = 0,
SYSERR: Oct 15 01:10:53 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 6864356, y = 530916, z = 0, map_index = 704, exit_x = 6864356, exit_y = 530916, exit_map_index = 704, hp = 68814, mp = 4013, stamina = 820, random_hp = 2575, random_sp = 1318, title = 0, rebirt = 0, reborn = 0, playtime = 184, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 18701000000, exp = 0, stat_point = 344, skill_point = 119, sub_skill_point = 81, stat_reset_count = 0, ip = '192.168.1.102', part_main = 11699, part_hair = 0, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 355576, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729202848, horse_stamina = 200, horse_skill_point = 0, title_memleket = 250, kesilen_metin = 0, kesilen_patron = 2360, acilan_sandik = 3, metinHasar = 45584, patronHasar = 38195948, statistics_jinno_kills = 0, statistics_shinsoo_k
SYSERR: Oct 15 01:14:53 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1332628, y = 1071734, z = 0, map_index = 717, exit_x = 1332628, exit_y = 1071734, exit_map_index = 717, hp = 66570, mp = 3579, stamina = 820, random_hp = 4760, random_sp = 2499, title = 15, rebirt = 0, reborn = 0, playtime = 111, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 9110304022, exp = 0, stat_point = 360, skill_point = 119, sub_skill_point = 111, stat_reset_count = 0, ip = '192.168.1.102', part_main = 7692, part_hair = 570, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 100065, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729203112, horse_stamina = 200, horse_skill_point = 0, title_memleket = 254, kesilen_metin = 0, kesilen_patron = 0, acilan_sandik = 0, metinHasar = 0, patronHasar = 0, statistics_jinno_kills = 0, statistics_shinsoo_kills = 0,
SYSERR: Oct 15 01:17:54 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1332628, y = 1071734, z = 0, map_index = 717, exit_x = 1332628, exit_y = 1071734, exit_map_index = 717, hp = 66570, mp = 3579, stamina = 820, random_hp = 4760, random_sp = 2499, title = 15, rebirt = 0, reborn = 0, playtime = 111, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 9110304022, exp = 0, stat_point = 360, skill_point = 119, sub_skill_point = 111, stat_reset_count = 0, ip = '192.168.1.102', part_main = 7692, part_hair = 570, part_acce = 0, part_wing = 16064, last_play = NOW(), skill_group = 1, alignment = 100065, horse_level = 30, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1729203431, horse_stamina = 200, horse_skill_point = 0, title_memleket = 254, kesilen_metin = 0, kesilen_patron = 0, acilan_sandik = 0, metinHasar = 0, patronHasar = 0, statistics_jinno_kills = 0, statistics_shinsoo_kills = 0,
SYSERR: Oct 15 01:28:49 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'title_memleket' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 1332661, y = 1072037, z = 0, map_index = 717, exit_x = 1332661, exit_y = 1072037, exit_map_index = 717, hp = 66570, mp = 3579, stamina = 820, random_hp = 4760, random_sp = 2499, title = 15, rebirt = 0, reborn = 0, playtime = 95, level = 120, level_step = 0, st = 4, ht = 4, dx = 4, iq = 4, gold = 9110304022, exp = 0, stat_point = 360, skill_point

böyle bir hata alıyorum memleket sisteminin dbsi ile alakalı nasıl çözebilirim
 
Navicattan ilgili tabloya sağ tıklayıp "Design Table" kısmına gir ve title_memleket sütununun veri tipini veya kapasitesini arttır.
 
Navicattan ilgili tabloya sağ tıklayıp "Design Table" kısmına gir ve title_memleket sütununun veri tipini veya kapasitesini arttır.
Tiny int 3 olarak kayıtlıydı arttırdım hocam bunu değişkeni vs değiştim, diğer benzer alt yapıdaki title sistemiyle aynı yaptım ama bonusları vs almama rağmen karakterin üstünde memleketi yazmıyor
 
Bu sorunun mysql ile alakası olduğunu sanmıyorum.
Sistemin kendisini ve çalışma şeklini pek bilmiyorum. Ancak sorunun kaynağına ilişkin çemberi daraltmak için test amaçlı aşağıdaki yöntemleri deneyebilirsin.

input_login.cpp - ::EnterGame fonksiyonunun içine ve en altına:
C++:
Genişlet Daralt Kopyala
ch->ChatPacket(CHAT_TYPE_INFO, "SERVER: %d", ch->GetMemleket());

Daha sonra InstanceBase.cpp içindeki ::SetWeapon veya ::SetArmor fonksiyonları içine şunu ekle:
C++:
Genişlet Daralt Kopyala
TraceError("Client: %d", GetMemleket());

Sonuç: eğer oyuna girdiğinde chat ekranında memleket no doğru yazıyorsa server tarafı sağlamdır. Beraberinde (silah veya zırh değiştikten sonra)
client syserr.txt içinde de memleket id doğru bir şekilde yazıyorsa server-client aktarımı sorunsuzdur.

Geriye iki alternatif kalıyor. PythonTextail.cpp veya python tarafı. Bu kısımlara dikkat etmeni öneririm.
 
Geri
Üst