Leeres Inventar bis ich mich einmal teleportiert habe

[Jon Snᴏw]

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:

 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,attrtyp e2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrv alue4,attrtype5,attrvalue5,attrtype6,attrvalue6,ap plytype0,applyvalue0,applytype1,applyvalue1,applyt ype2,applyvalue2,applytype3,applyvalue3,applytype4 ,applyvalue4,applytype5,applyvalue5,applytype6,app lyvalue6,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.

[Benhero]

query failed: Data truncated for column 'immuneflag' at row 1

Versuch mal die Tabelle zu Reparieren.

Grüße

[KAOS_187]

Item_Proto am arssch

[FetteRatte.]

man sollte eher sagen dass die folgenden items verkackt sind und außerdem ist es nicht nur die item_proto

query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id,window+0,pos,count,vnum,socket0,socket1,socket2 ,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtyp e2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrv alue4,attrtype5,attrvalue5,attrtype6,attrvalue6,ap plytype0,applyvalue0,applytype1,applyvalue1,applyt ype2,applyvalue2,applytype3,applyvalue3,applytype4 ,applyvalue4,applytype5,applyvalue5,applytype6,app lyvalue6,applytype7,applyvalue7 FROM item WHERE owner_id=2 AND (window < 3 or window = 5) errno: 1054)

applytype0 existiert nicht mal in player.item
hast du vllt eine veraltete version von nem schulterband system eingefügt?
ich weiss nämlihc dass man da noch die item tabelle erweitern musste

[Jon Snᴏw]

Originally Posted by Benhero

Versuch mal die Tabelle zu Reparieren.

Grüße

Originally Posted by KAOS_187

Item_Proto am arssch

Originally Posted by GucciMane.

man sollte eher sagen dass die folgenden items verkackt sind und außerdem ist es nicht nur die item_proto

query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id,window+0,pos,count,vnum,socket0,socket1,socket2 ,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtyp e2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrv alue4,attrtype5,attrvalue5,attrtype6,attrvalue6,ap plytype0,applyvalue0,applytype1,applyvalue1,applyt ype2,applyvalue2,applytype3,applyvalue3,applytype4 ,applyvalue4,applytype5,applyvalue5,applytype6,app lyvalue6,applytype7,applyvalue7 FROM item WHERE owner_id=2 AND (window < 3 or window = 5) errno: 1054)

applytype0 existiert nicht mal in player.item
hast du vllt eine veraltete version von nem schulterband system eingefügt?
ich weiss nämlihc dass man da noch die item tabelle erweitern musste

Vielen Dank für eure Hilfe.
Habs auch schon gestern gelöst gehabt.
Wie GucciMane schrieb, lag es an der item.sql.
Hab anfangs auch gedacht, dass es an der item_proto lag.