Çözüldü asynchsql socket3 sorunum

Bu konu çözüme ulaştırılmıştır. Çözüm için konuya yazılan tüm yorumları okumayı unutmayın. Eğer konudaki yorumlar sorununuzu çözmediyse yeni bir konu açabilirsiniz.
Durum
İçerik kilitlendiği için mesaj gönderimine kapatıldı.
Legandalith

Legandalith

Üye
Üye
Mesaj
135
Çözümler
5
Beğeni
140
Puan
769
Ticaret Puanı
0
Merhaba gene ben ve gene bir sorum;

Oyunu kapatıp reboot atıp geri açınca oyundaki her şey siliniyor level, item vs. Aynı zamanda karakterde açamıyorum. Sorun veritabanında evet ama nasıl düzeltebileceğimi bilmiyorum

syserr
Kod: 
SYSERR: May  6 07:48:15.222102 :: pid_init:
Start of pid: 97507

SYSERR: May  6 07:53:00.877151 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'lValue' at row 1 (query: REPLACE INTO quest  (dwPID, szName, szState, lValue) VALUES(4, 'main_quest_lv1', '__status', 3698185638) errno: 1264)
SYSERR: May  6 07:55:27.874879 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000001, 4, 2, 4, 1, 189, 1, 1, 1, 72, 22, 71, -6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:32.874957 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000005, 4, 1, 4, 1, 189, 1, 1, 1, 72, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:32.875028 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000003, 4, 1, 2, 1, 189, 1, 1, 1, 72, 13, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:32.875109 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000002, 4, 1, 1, 1, 189, 1, 1, 1, 72, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:32.875305 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000004, 4, 1, 3, 1, 189, 1, 1, 1, 72, -1, 71, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:37.876175 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000008, 4, 1, 12, 1, 189, 1, 1, 1, 72, 20, 71, -7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:42.875869 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000010, 4, 1, 14, 1, 189, 1, 1, 1, 72, -3, 71, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:42.876078 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000009, 4, 1, 13, 1, 189, 1, 1, 1, 72, 17, 71, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.875193 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000017, 4, 1, 31, 1, 189, 1, 1, 1, 72, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.875205 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000012, 4, 1, 21, 1, 189, 1, 1, 1, 72, 1, 71, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.875398 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000014, 4, 1, 23, 1, 189, 1, 1, 1, 72, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.875601 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000021, 4, 1, 45, 1, 189, 1, 1, 1, 72, 14, 71, -5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.875777 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000015, 4, 1, 24, 1, 189, 1, 1, 1, 72, -6, 71, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.875949 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000011, 4, 1, 20, 1, 189, 1, 1, 1, 72, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.876136 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000016, 4, 1, 30, 1, 189, 1, 1, 1, 72, 30, 71, -10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.876323 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000018, 4, 1, 32, 1, 189, 1, 1, 1, 72, -23, 71, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.876480 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000020, 4, 1, 34, 1, 189, 1, 1, 1, 72, 29, 71, -7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 07:55:47.876689 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000019, 4, 1, 33, 1, 189, 1, 1, 1, 72, 25, 71, -4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:17:25.364509 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000002, 12, 3, 17, 1, 189, 1, 1, 1, 72, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:26:01.560877 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(50000022, 4, 1, 0, 1, 158, 1, 1, 1) errno: 1364)
SYSERR: May  6 08:26:06.560875 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(50000023, 4, 1, 1, 1, 159, 1, 1, 1) errno: 1364)
SYSERR: May  6 08:26:11.560880 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000024, 4, 1, 2, 1, 159, 1, 1, 1, 14, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:26:11.561090 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000025, 4, 2, 4, 1, 189, 1, 1, 1, 72, -13, 71, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:30:24.167182 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'lValue' at row 1 (query: REPLACE INTO quest  (dwPID, szName, szState, lValue) VALUES(11, 'main_quest_lv1', '__status', 3698185638) errno: 1264)
SYSERR: May  6 08:30:41.461659 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'last_play' doesn't have a default value
query: INSERT INTO player  (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair, gold, playtime, skill_level, quickslot) VALUES(0, 12, 'Legandalithg', 1, 6, 4, 3, 3, 0, 0, 0, 957360, 255296, 0, 760, 260, 0, 0, 0, 800, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
SYSERR: May  6 08:30:41.461886 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index  SET pid2=0 WHERE id=12
SYSERR: May  6 08:34:30.564914 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000006, 3, 1, 5, 1, 15009) errno: 1364)
SYSERR: May  6 08:34:30.565088 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(30000004, 3, 1, 3, 1, 72727, 0, 0, 100000) errno: 1364)
SYSERR: May  6 08:34:30.565217 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000008, 3, 1, 7, 1, 14009) errno: 1364)
SYSERR: May  6 08:34:30.565437 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(30000009, 3, 1, 8, 1, 16009, 24, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:34:30.565562 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(30000012, 3, 1, 11, 1, 11609, 1, 0, 0) errno: 1364)
SYSERR: May  6 08:34:30.565677 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000010, 3, 1, 9, 1, 17009) errno: 1364)
SYSERR: May  6 08:34:30.565795 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(30000011, 3, 1, 10, 1, 19, 1, 0, 0) errno: 1364)
SYSERR: May  6 08:34:30.565907 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000001, 3, 1, 0, 1, 50052) errno: 1364)
SYSERR: May  6 08:34:30.566018 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000007, 3, 1, 6, 1, 13009) errno: 1364)
SYSERR: May  6 08:34:30.566129 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000013, 3, 1, 12, 1, 12489) errno: 1364)
SYSERR: May  6 08:34:30.566250 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(30000005, 3, 1, 4, 1, 72723, 0, 0, 1000000) errno: 1364)
SYSERR: May  6 08:34:45.566117 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000003, 3, 1, 2, 200, 27006) errno: 1364)
SYSERR: May  6 08:34:45.566266 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000002, 3, 1, 1, 200, 27003) errno: 1364)
SYSERR: May  6 08:35:16.564945 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000022, 11, 1, 8, 1, 16009) errno: 1364)
SYSERR: May  6 08:35:16.565105 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(30000018, 11, 1, 4, 1, 72723, 0, 0, 1000000) errno: 1364)
SYSERR: May  6 08:35:16.565285 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(30000019, 11, 1, 5, 1, 15009, 33, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:35:16.565444 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000021, 11, 1, 7, 1, 14009) errno: 1364)
SYSERR: May  6 08:35:16.565559 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000023, 11, 1, 9, 1, 17009) errno: 1364)
SYSERR: May  6 08:35:16.565726 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(30000027, 11, 1, 13, 1, 12209, 19, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:35:16.565841 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000014, 11, 1, 0, 1, 50052) errno: 1364)
SYSERR: May  6 08:35:16.565965 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(30000025, 11, 2, 4, 1, 3009, 1, 0, 0) errno: 1364)
SYSERR: May  6 08:35:16.566112 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(30000020, 11, 1, 6, 1, 13009, 3, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:35:16.566218 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(30000024, 11, 1, 10, 1, 19, 1, 0, 0) errno: 1364)
SYSERR: May  6 08:35:16.566342 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(30000017, 11, 1, 3, 1, 72727, 0, 0, 100000) errno: 1364)
SYSERR: May  6 08:35:16.566495 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(30000026, 11, 1, 12, 1, 11209, 1, 0, 0, 23, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:35:25.564967 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000015, 11, 1, 1, 200, 27003) errno: 1364)
SYSERR: May  6 08:35:25.565191 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(30000016, 11, 1, 2, 200, 27006) errno: 1364)
SYSERR: May  6 08:36:45.567756 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000025, 4, 1, 0, 1, 189, 1, 1, 1, 72, -13, 71, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:41:46.564839 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6) VALUES(50000025, 4, 2, 4, 1, 189, 1, 1, 1, 72, -13, 71, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) errno: 1364)
SYSERR: May  6 08:43:01.564770 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(70000001, 4, 1, 0, 1, 53013, 1622875079, 0, 0) errno: 1364)
SYSERR: May  6 08:43:32.564751 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(70000003, 4, 1, 2, 1, 71021) errno: 1364)
SYSERR: May  6 08:43:42.564880 :: ChildLoop: AsyncSQL: query failed: Field 'socket0' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum) VALUES(70000005, 4, 1, 16, 1, 71121) errno: 1364)
SYSERR: May  6 08:45:54.565241 :: ChildLoop: AsyncSQL: query failed: Field 'socket3' doesn't have a default value (query: REPLACE INTO item  (id, owner_id, `window`, pos, count, vnum, socket0, socket1, socket2) VALUES(70000007, 4, 1, 3, 1, 27989, 2, 0, 0) errno: 1364)

dbyi tekrar compile etmeye çalıştığımda şu hatayı aldım ;
Ekran görüntüsü 2021-05-06 072002.png


Edit: databaseyi compile edebildim fakat item kaybolma sorunum devam ediyor(item tablosu boş)
 
Son düzenleme:
Çözüm
Legandalith
Sorunu çözdüm, bu sorunu yaşayan başka arkadaşlarımız olursa çözümünü dile getireyim, socketlerin silah ve zırhlara eklenen taş slotlarıyla ilgili olduğunu öğrendim. Altyapı filesini tamamen kendim yapmadığım için eklenen sistemlerden emin değildim biraz araştırma sonucu bu sonuca vardım. Veritabanında socket hatası aldıktan sonra veritabanında item.sql ve item_award.sql arasındaki farklara baktım birisinde socket0,socket1,socket2 varken (normal bildiğimiz 3 taş), diğer sqlde bu socket5e kadar gidiyordu. İlk başta ikisini de socket0,socket1,socket2 olarak tekrar düzenleyip sorgulattım fakat sorunum çözülmedi. Daha sonra 6 taş sisteminin scriptlerine baktım benim sistemim ile karşılaştığımda bazı cpp dosyalarının 3 taş için bazı cpp...
Tarihe göre sırala Oy skoruna göre sırala
Tabloları düzenleyin ve socket3’e varsayılan bir değer tanımlayın
 
Upvote 0 Downvote
Sorunu çözdüm, bu sorunu yaşayan başka arkadaşlarımız olursa çözümünü dile getireyim, socketlerin silah ve zırhlara eklenen taş slotlarıyla ilgili olduğunu öğrendim. Altyapı filesini tamamen kendim yapmadığım için eklenen sistemlerden emin değildim biraz araştırma sonucu bu sonuca vardım. Veritabanında socket hatası aldıktan sonra veritabanında item.sql ve item_award.sql arasındaki farklara baktım birisinde socket0,socket1,socket2 varken (normal bildiğimiz 3 taş), diğer sqlde bu socket5e kadar gidiyordu. İlk başta ikisini de socket0,socket1,socket2 olarak tekrar düzenleyip sorgulattım fakat sorunum çözülmedi. Daha sonra 6 taş sisteminin scriptlerine baktım benim sistemim ile karşılaştığımda bazı cpp dosyalarının 3 taş için bazı cpp dosyaları da 6 taş için düzenlenmiş yani sanki başlanmış ama yarıda bırakılmış gibiydi. 6 taş sisteminde ne yapılması gerekiyorsa tam tersini yaptım yani tekrar 3 taş sistemine geri döndüm db ve oyunu tekrar buildledim ve sorunum çözüldü. Bu sorunu yaşayan arkadaşlar aynı yolu izlerlerse büyük ihtimal problemleri çözülmüş olur. Konu kapanabilir
 
Upvote 0 Downvote
Çözüm
Durum
İçerik kilitlendiği için mesaj gönderimine kapatıldı.

Benzer konular

A
Yardım Toplu Pm Sistemi Build Hata
Yanıt
1
Gösterim
23
hasanmacit
hasanmacit
T
Yardım Oyuna giriş yaparken client atıyor
Yanıt
0
Gösterim
43
TEmreAta
T
T
  • Kilitli
  • Çözüldü
Çözüldü Binek Kostüm Sistemi
Yanıt
1
Gösterim
60
TEmreAta
T
A
  • Kilitli
  • Çözüldü
Çözüldü Bugtan kurtulma sistemi
Yanıt
2
Gösterim
60
asilords
A
cacaa
  • Kilitli
  • Çözüldü
Çözüldü GetGlobalPosition hatası
Yanıt
1
Gösterim
46
cacaa
cacaa
Geri
Üst