Hey,
habe ein Problem mit meinem Server.
Den Fehler könnt ihr auf dem GIF sehen.
Es ist öfters so, dass ich keine Items im Inventar habe, bis ich mich einmal geportet habe.
In den syserr steht eigentlich soweit nichts wichtiges bis auf in der von DB:
Bitte melden Sie sich an, um dieses Bild zu sehen.
Bitte melden Sie sich an, um diesen Link zu sehen.
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.
LÖSUNG
Lag an der item.sql, weil dort die entsprechenden Spalten gefehlt haben.