Jon Snow 0 Posted October 12, 2017 Share Posted October 12, 2017 (edited) Hi i have a problem with my Server. You can see the bug in the gif down. often when i login, my inventory is empty, until i warp to a map. Than i get my items "back" . i can see them in my inventory. My DB syserr:https://metin2.download/picture/r3F9504x09DVmF8K988YXgTtGTP6KMUj/.gif.html Spoiler SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'immuneflag' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (72711, 16, 0, "È£°¢ ÆÈÂî", "Tigerknochenarmband", 0, 0, 0, 0, 0, 1, 8192, 128, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71, 30, 0, 0, 0, 0, 1200, 0, 0, 0 ) errno: 1265) SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'immuneflag' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (72712, 16, 0, "¿ë°¢ ÆÈÂî", "Drachenknochenarmband", 0, 0, 0, 0, 0, 1, 8192, 128, 106880, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 73, 30, 0, 0, 0, 0, 1200, 0, 0, 0 ) errno: 1265) SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'immuneflag' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (76011, 16, 0, "À°µµ(¼±¹°¿ë)", "Buch des Anführers", 0, 0, 0, 0, 0, 1, 0, 128, 237696, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 60, 0, 0, 0 ) errno: 1265) SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'weight' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (80003, 6, 0, "Àº±« (5¸¸³É)", "Silberbarren(50.000Yang)", 50500, 0, 250000, 0, 0, 1, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) errno: 1264) SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'weight' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (80004, 6, 0, "Àº±« (10¸¸³É)", "Silberbarren(100000Yang)", 101000, 0, 500000, 0, 0, 1, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) errno: 1264) SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'weight' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (80005, 6, 0, "±Ý±« (50¸¸³É)", "Goldbarren(500.000Yang)", 505000, 0, 2500000, 0, 0, 1, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) errno: 1264) SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'weight' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (80006, 6, 0, "±Ý±« (100¸¸³É)", "Goldbarren(1 Mill. Yang)", 1010000, 0, 5000000, 0, 0, 1, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) errno: 1264) SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'weight' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (80007, 6, 0, "±Ý±« (200¸¸³É)", "Goldbarren(2 Mill. Yang)", 2020000, 0, 10000000, 0, 0, 1, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) errno: 1264) SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'weight' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (80008, 6, 0, "±Ý µ¢¾î¸®", "Goldklumpen", 0, 0, 500000, 0, 0, 1, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) errno: 1264) SYSERR: Oct 12 22:40:23 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'weight' at row 1 (query: replace into item_proto (vnum, type, subtype, name, locale_name, gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5 ) values (90013, 3, 2, "¹öÆ°À̹ÌÁö", "Button-Abbild", 5000, 0, 5000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ) errno: 1264) SYSERR: Oct 12 22:40:23 :: Load: *DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry) SYSERR: Oct 12 22:41:10 :: ChildLoop: AsyncSQL: query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id,window+0,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6,applytype0,applyvalue0,applytype1,applyvalue1,applytype2,applyvalue2,applytype3,applyvalue3,applytype4,applyvalue4,applytype5,applyvalue5,applytype6,applyvalue6,applytype7,applyvalue7 FROM item WHERE owner_id=2 AND (window < 3 or window = 5) errno: 1054) SYSERR: Oct 12 22:41:10 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1 Und das geht über 20k Zeilen lang. Ich hoffe ihr könnt mir helfen. Edited August 24, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now