Yardım Hesabın navicattan tamamen silinmeme sorunu

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

McDynamic

MT Üye
MT Üye
Mesaj
297
Çözümler
14
Beğeni
221
Puan
744
Ticaret Puanı
0
Merhabalar. Denemiş olduğum fileste 1 2 karakterin isimleri süreleri sıfır olarak gözüküyordu başlatıncada öylece kalıyodu herneyse navicat uzerinde kalıntılar olduğunu düşünüyodum biraz araştırdım yazıcağım bölümlerden tamamen sildim sorun kalmadı fakat bu seferde silmiş olduğum nicki yeni hesapta denediğim bu ismi zaten başka karakter kullanıyor şeklinde hata aldım en ve son çare foruma konu açayım dedim. Umarım Yardımcı olursunuz...

Silmiş olduğum tablolar;
Kod:
Genişlet Daralt Kopyala 
Navicat > Account > Account
Navicat > Player > Player
Navicat > Player > Guild >
Navicat > Player > Player_index
Navicat > Player > İtem
Navicat > Player > Player_deleted

Edit: Whistle adminimizin söylediği Player_deleted tablosu tarafımca eklendi. Lazım olabilir aynı sorunu yaşayan olursa :)

Silinen karakterin ismini kullanamama.webp
 
Son düzenleme:
Tarihe göre sırala Oy skoruna göre sırala
Sagol kardesim bunuda ogrenmis olduk. Sorun bu baglam uzerine rahat ol ne varsa yaz. :) whistle incelemeye aldi cevap bekliyorum nedeni neymis diye kullanici adiyla karakter ismi ayni olmuyo bi engelleme yapilmis ama nerden yapilmis sizde bakarsaniz iyi olur.
 
Upvote 0 Downvote
Kaynak kodlarında kullanıcı adı ile karakter adını aynı anda kullanma engelini göremedim ben. Fakat şöyle bir seçenek gözüme çarptı. Oyunda karakter yaratmayı engelleyen bir şey.

Config.cpp'de g_BlockCharCreation şöyle bir değer varmış. Buna baksana configlerden kapalı mı?
filesinizdeki channel1, 2, 3, 4, 99 klasörlerinin içindeki CONFIG dosyalarına da bakın;
"block_char_creation" böyle bir değer var mı? Varsa bunu da false yapın..
 
Son düzenleme:
Upvote 0 Downvote
yok hocam hepsine baktım bulamadım. Fakat pack klasorundeki locale dosyasını açtım orda bu hatanın kullandığı komut şöyle;
Kod:
Genişlet Daralt Kopyala 
CREATE_EXIST_SAME_NAME
 
Upvote 0 Downvote
O çeviri dosyası normalde bu isimle bir oyuncu varsa o değeri döndürüyor. Bendeki frozenin kodlarına baktım işte bi g_BlockCharCreation seçenek vardı. Buda yeni karakter oluşturmayı configden kapatıyor. input_login.cpp'den bi bakar mısın? Yoksa senin linkini attığın sourceyi indireceğim..
Birde bana db'nin, channel1'in ve auth'un syserrlerini atar mısın? Ama karakter oluşturmaya çalış öyle at. ;)
 
Upvote 0 Downvote
İnput_login.cpp;
input login.webp


db ;
Kod:
Genişlet Daralt Kopyala 
SYSERR: Oct 28 22:08:25 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:08:30 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:08:34 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:08:39 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:08:44 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:08:49 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:08:54 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:08:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:04 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:09 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:14 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:19 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:24 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:29 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:34 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:39 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:44 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:49 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:54 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:09:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:04 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:09 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:14 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:19 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:24 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:29 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:34 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:39 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:44 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:49 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:54 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:10:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:04 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:09 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:14 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:19 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:24 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:29 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:34 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:39 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:44 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:49 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:54 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:11:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:04 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:09 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:14 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:19 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:24 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:29 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:34 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:39 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:44 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:49 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:54 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:12:59 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:04 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:09 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:14 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:19 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:23 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:33 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:38 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:43 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:48 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:53 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:13:58 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:03 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:08 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:13 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:18 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:23 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:33 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:38 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:43 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:48 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:53 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:14:58 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:15:03 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:15:08 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:15:14 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:15:18 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:15:23 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
SYSERR: Oct 28 22:15:28 :: ChildLoop: AsyncSQL: query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)

channel1;
Kod:
Genişlet Daralt Kopyala 
SYSERR: Oct 28 22:09:37 :: heart_idle: losing 198 seconds. (lag occured)
SYSERR: Oct 28 22:09:53 :: GetServerLocation: location error name  mapindex 0 0 x 0 empire 3

Diğerleri boş hocam filesin heryerinden hata fışkırdı loglar fln slotlar olsun ne ararsan var :D
 
En son bir moderatör tarafından düzenlenmiş:
Upvote 0 Downvote
db'nin hatasını şöyle çöz;
Kod:
Genişlet Daralt Kopyala 
query failed: Unknown column 'socket3' in 'field list' (query: SELECT id,login,vnum,count,socket0,socket1,socket2,socket3,socket4,socket5,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 1054)
Burada socket3 sütünunu bulamadığını söylüyor. item_award tablosuna gir ve socket3, socket4 ve socket5 sütunlarını ekle. Fileste 6 taş sistemi olduğunu için bu yüzden hata veriyor.

Kod:
Genişlet Daralt Kopyala 
heart_idle: losing 198 seconds. (lag occured)
bunu tam bilmiyorum ama sunucu kaynaklı galiba. Oyunu başlatınca hemen başlamıyor fark ettiyseniz bekleme süresi var. Buda onu yazıyor. Yabancı forumlarda böyle demişlerdi.

Sizin şu karakter sorunuyla ilgili bir kayıt yok. Uzaktan bilgisayarınıza bağlanıp bi bakmak istiyorum aslında. Müsahit zamanda öm ile teamwier bilgilerini atar mısınız?
 
Upvote 0 Downvote
Filesi tamamen kaldırma kararı aldım hocam inan bi ton log verdi atmadığım bi sayfa vardı dolu dolu geldi orda :) evet stabil değil game start verince yaklaşık 5 dk civarı bi meşgul ediyor diski. Bence konu kapatılabilir çözüme ulaşmasakta faydalı bilgiler çıktı ortaya sayenizde :)
 
Upvote 0 Downvote
Konu açık kalsın. Çözüme ulaşmayan konuları açık bırakıyoruz. İlla bir sorun vardır. Bilen birisi yardımcı olacaktır diye düşünüyorum. :)
 
Upvote 0 Downvote
Sen şu filesi komple uplayıp bana atar mısın? Hırs yaptım ya bi bakayım. Ama sizin elinizdekileri atın bana files + source pack.
 
Upvote 0 Downvote
Sizin files'te de öyledir hocam bütün filesler'de var galiba ama sebebi muallak tabi :) attım özelden gerçi hiçbişey yapmadım direk alıp denedim bunu ilk defa fark ettim :)
 
Upvote 0 Downvote
1-)Navicattaki item.sqlye sağ tıklayıp dump sql file seçeneği ile masaüstüne çıkartıp içindeki tüm itemleri silip navicata yükle. Sonra reboot atıp tekrar denermisin ? Direkt navicattan CTRL A komutuyla silmeyi denersen , tekrardan item.sql ye giriş yaptıgında silmeyebilir.

2. Yöntem olarak ise , item.sql ye benzer id stünları bulunan sql tablolarınıda sil.
 
Upvote 0 Downvote

Benzer konular

ezentere
Yardım Başka hesabın offline shopundaki itemleri görüyorum
Yanıt
5
Gösterim
732
ezentere
ezentere
N
  • Kilitli
  • Çözüldü
Çözüldü Navicat item proto ve refine proto ekleme sorunu
Yanıt
2
Gösterim
994
NIGHTMT2
N
servet7777
Yardım PET BUGU NAVİCATTAN new_petsystem İSİMİ CEKMİYOR MOB_PROTOTAN CEKİYO
Yanıt
2
Gösterim
550
servet7777
servet7777
M
  • Kilitli
  • Çözüldü
Çözüldü protoları navicattan cekiyor txt yaptım
Yanıt
3
Gösterim
945
msevgil
M
WhiteZombieWZ
  • Kilitli
  • Çözüldü
Çözüldü Server'a Silah-İtem vb Ekleyemiyorum
Yanıt
3
Gösterim
602
Kaiser
Kaiser
Geri
Üst