Çözüldü asynchsql socket3 sorunum

Legandalith · 6 Mayıs 2021

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 ;

Edit: databaseyi compile edebildim fakat item kaybolma sorunum devam ediyor(item tablosu boş)

Whistle · 6 Mayıs 2021

Tabloları düzenleyin ve socket3’e varsayılan bir değer tanımlayın

Legandalith · 6 Mayıs 2021

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

Ara

Çözüldü asynchsql socket3 sorunum

Legandalith

MT Üye

Legandalith

Whistle

Ruhsuz :/

Legandalith

MT Üye

Benzer konular