Sziasztok,
Néha találkozom ezzel viszont ilyen intenzíven nem.
Felraktam egy teljesen alap SF-t ( hungary ) egy módosított Samurai corral ( magam módosítottam )..
Viszont elég sok querry errort vág be a szerver, de ezzel nincs gond mert többnyire fixáltam őket, viszont
Ha felveszek egy kosztümöt .. bármilyen kosztümöt és a szervert leállítom ( normálisan adatvesztés nélkül )
Bármennyit játszottam a karakteren abba a helyzetbe - pozícióba fog visszakerülni ,ahol felvettem a kosztümöt
Csupán ez hivatkozik rá (fogalmam sincs ,de effectet raktam rájuk forrásban ,ha ez ütközőképp lenne rájuk )
SYSERR: Mar 24 12:12:24.642052 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42110, 28, 0, "Prémium kosztüm f", "Prémium kosztüm(kék)", 0, 0, 0, 2, 0, 0, 98561, 0, 0, 0, 0, 232, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42110, 0, 0 ) errno: 1264)
SYSERR: Mar 24 12:12:24.642285 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42111, 28, 0, "Prémium kosztüm w", "Prémium kosztüm(kék)", 0, 0, 0, 2, 0, 0, 98562, 0, 0, 0, 0, 232, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42111, 0, 0 ) errno: 1264)
SYSERR: Mar 24 12:12:24.642523 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42112, 28, 0, "Prémium kosztüm f", "Prémium kosztüm(nar.)", 0, 0, 0, 2, 0, 0, 98561, 0, 0, 0, 0, 220, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42112, 0, 0 ) errno: 1264)
SYSERR: Mar 24 12:12:24.642769 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42113, 28, 0, "Prémium kosztüm w", "Prémium kosztüm(nar.)", 0, 0, 0, 2, 0, 0, 98562, 0, 0, 0, 0, 220, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42113, 0, 0 ) errno: 1264)
SYSERR: Mar 24 12:12:24.643032 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42114, 28, 0, "Prémium kosztüm f", "Prémium kosztüm(zöld)", 0, 0, 0, 2, 0, 0, 98561, 0, 0, 0, 0, 208, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42114, 0, 0 ) errno: 1264)
SYSERR: Mar 24 12:12:24.643278 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42115, 28, 0, "Prémium kosztüm w", "Prémium kosztüm(zöld)", 0, 0, 0, 2, 0, 0, 98562, 0, 0, 0, 0, 208, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42115, 0, 0 ) errno: 1264)
SYSERR: Mar 24 12:12:24.643482 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42116, 28, 0, "Prémium kosztüm f", "Prémium kosztüm(lila)", 0, 0, 0, 2, 0, 0, 98561, 0, 0, 0, 0, 196, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42116, 0, 0 ) errno: 1264)
SYSERR: Mar 24 12:12:24.643763 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42117, 28, 0, "Prémium kosztüm w", "Prémium kosztüm(lila)", 0, 0, 0, 2, 0, 0, 98562, 0, 0, 0, 0, 196, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42117, 0, 0 ) errno: 1264)
SYSERR: Mar 24 12:12:24.644018 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42118, 28, 0, "Prémium kosztüm f", "Prémium kosztüm(vör.)", 0, 0, 0, 2, 0, 0, 98561, 0, 0, 0, 0, 184, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42118, 0, 0 ) errno: 1264)
SYSERR: Mar 24 12:12:24.644327 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'socket_pct' 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 (42119, 28, 0, "Prémium kosztüm w", "Prémium kosztüm(vör.)", 0, 0, 0, 2, 0, 0, 98562, 0, 0, 0, 0, 184, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42119, 0, 0 ) errno: 1264)
Néztem, az összes többivel is így van.
Üzenet összefésülés: 2018-03-24, 13:11:40
Megoldása :
bigint lenght = 10