Jump to content

SYSERR - Cannot find item by (x number)


Recommended Posts

  • Premium

Hello!

 

I am trying to set up a server, but I have run into a bit of a serious problem and have found no fix for it after searching all over, google, m2dev, forums etc..

 

To break it down:

 

Player picks up drop from mob - right click to equip, item disappears, syserr shows attached error.

Player buys item from shop, right click to equip, item disappears, syserr shows attached error.

GM does /item (vnum), right click to equip, item disappears, syserr shows attached error.

 

Note: this does not happen with all items, a very small percentage of items actually equip and work as intended.

 

Syserr Log from Client:

Spoiler

1020 14:21:29333 :: CRaceData::RegisterMotionData - LoadMotionData(c_szFileName=d:/ymir work/pc/shaman/skill/hosin.msa) ERROR
1020 14:21:29333 :: CRaceData::RegisterMotionData - LoadMotionData(c_szFileName=d:/ymir work/pc/shaman/skill/boho.msa) ERROR
1020 14:21:29333 :: CRaceData::RegisterMotionData - LoadMotionData(c_szFileName=d:/ymir work/pc/shaman/skill/gicheon.msa) ERROR
1020 14:21:29333 :: CRaceData::RegisterMotionData - LoadMotionData(c_szFileName=d:/ymir work/pc/shaman/skill/jeongeop.msa) ERROR
1020 14:21:29333 :: CRaceData::RegisterMotionData - LoadMotionData(c_szFileName=d:/ymir work/pc/shaman/skill/kwaesok.msa) ERROR
1020 14:21:36861 :: Cannot find item by 1666866283
1020 14:21:36861 :: Cannot find item by 1666866283
1020 14:21:36862 :: Cannot find item by 1666866283
1020 14:21:38328 :: Cannot find item by 1666261761
1020 14:21:38328 :: Cannot find item by 1666261761
1020 14:21:38328 :: Cannot find item by 1666261761
1020 14:21:38328 :: Cannot find item by 5
1020 14:21:38328 :: Cannot find item by 5
1020 14:21:40457 :: Cannot find item by 1666261761
1020 14:21:40457 :: Cannot find item by 1666261761
1020 14:21:40457 :: Cannot find item by 1666261761
1020 14:21:40457 :: Cannot find item by 5
1020 14:21:40457 :: Cannot find item by 5
1020 14:21:40489 :: Cannot find item by 1666261981
1020 14:21:40489 :: Cannot find item by 1666261981
1020 14:21:40489 :: Cannot find item by 1666261981
1020 14:21:40489 :: Cannot find item by 3
1020 14:21:40489 :: Cannot find item by 3
1020 14:21:40555 :: Cannot find item by 1666261761
1020 14:21:40555 :: Cannot find item by 1666261761
1020 14:21:40555 :: Cannot find item by 1666261761
1020 14:21:40555 :: Cannot find item by 5
1020 14:21:40555 :: Cannot find item by 5
1020 14:21:20370 :: Cannot find item by 1666865698
1020 14:21:20370 :: Cannot find item by 1666865698
1020 14:21:20370 :: Cannot find item by 1666865698
1020 14:21:23340 :: Cannot find item by 1666865640
1020 14:21:23340 :: Cannot find item by 1666865640
1020 14:21:23340 :: Cannot find item by 1666865640
1020 14:21:23603 :: Cannot find item by 1666865640
1020 14:21:23604 :: Cannot find item by 1666865640
1020 14:21:23604 :: Cannot find item by 1666865640
1020 14:21:24510 :: Cannot find item by 1666865640
1020 14:21:24510 :: Cannot find item by 1666865640
1020 14:21:24510 :: Cannot find item by 1666865640
1020 14:21:24511 :: Cannot find item by 1666865637
1020 14:21:24511 :: Cannot find item by 1666865637
1020 14:21:24511 :: Cannot find item by 1666865637
1020 14:21:24512 :: Cannot find item by 1666865637
1020 14:21:24512 :: Cannot find item by 1666865637
1020 14:21:24512 :: Cannot find item by 1666865637
1020 14:21:25435 :: Cannot find item by 1666865637
1020 14:21:25435 :: Cannot find item by 1666865637
1020 14:21:25435 :: Cannot find item by 1666865637
1020 14:21:25632 :: Cannot find item by 1666865637
1020 14:21:25632 :: Cannot find item by 1666865637
1020 14:21:25633 :: Cannot find item by 1666865637
1020 14:22:26228 :: Cannot find item by 1666865637
1020 14:22:26228 :: Cannot find item by 1666865637
1020 14:22:26228 :: Cannot find item by 1666865637
1020 14:22:26229 :: Cannot find item by 1666865637
1020 14:22:26229 :: Cannot find item by 1666865637
1020 14:22:26229 :: Cannot find item by 1666865637
1020 14:22:26230 :: Cannot find item by 1666865637
1020 14:22:26230 :: Cannot find item by 1666865637
1020 14:22:26230 :: Cannot find item by 1666865637
1020 14:22:26231 :: Cannot find item by 1666865637
1020 14:22:26231 :: Cannot find item by 1666865637
1020 14:22:26231 :: Cannot find item by 1666865637
1020 14:22:26232 :: Cannot find item by 1666865637
1020 14:22:26232 :: Cannot find item by 1666865637
1020 14:22:26232 :: Cannot find item by 1666865637
1020 14:22:26522 :: Cannot find item by 1666865637
1020 14:22:26522 :: Cannot find item by 1666865637
1020 14:22:26523 :: Cannot find item by 1666865637
1020 14:22:26721 :: Cannot find item by 1666865637
1020 14:22:26721 :: Cannot find item by 1666865637
1020 14:22:26721 :: Cannot find item by 1666865637
1020 14:22:27020 :: Cannot find item by 1666865637
1020 14:22:27020 :: Cannot find item by 1666865637
1020 14:22:27020 :: Cannot find item by 1666865637
1020 14:22:27021 :: Cannot find item by 1666865637
1020 14:22:27021 :: Cannot find item by 1666865637
1020 14:22:27021 :: Cannot find item by 1666865637
1020 14:22:27022 :: Cannot find item by 1666865637
1020 14:22:27022 :: Cannot find item by 1666865637
1020 14:22:27022 :: Cannot find item by 1666865637
1020 14:22:28405 :: Cannot find item by 1666866283
1020 14:22:28405 :: Cannot find item by 1666866283
1020 14:22:28405 :: Cannot find item by 1666866283
1020 14:22:28538 :: Cannot find item by 1666865637
1020 14:22:28538 :: Cannot find item by 1666865637
1020 14:22:28538 :: Cannot find item by 1666865637
1020 14:22:29250 :: Cannot find item by 1666866283
1020 14:22:29250 :: Cannot find item by 1666866283
1020 14:22:29250 :: Cannot find item by 1666866283
1020 14:22:29514 :: Cannot find item by 1666261981
1020 14:22:29514 :: Cannot find item by 1666261981
1020 14:22:29514 :: Cannot find item by 1666261981
1020 14:22:29514 :: Cannot find item by 3
1020 14:22:29514 :: Cannot find item by 3
1020 14:22:29545 :: Cannot find item by 1666261761
1020 14:22:29545 :: Cannot find item by 1666261761
1020 14:22:29545 :: Cannot find item by 1666261761
1020 14:22:29545 :: Cannot find item by 5
1020 14:22:29545 :: Cannot find item by 5
1020 14:22:29691 :: Cannot find item by 1666261981
1020 14:22:29691 :: Cannot find item by 1666261981
1020 14:22:29692 :: Cannot find item by 1666261981
1020 14:22:29692 :: Cannot find item by 3
1020 14:22:29692 :: Cannot find item by 3
1020 14:22:29973 :: Cannot find item by 1666261761
1020 14:22:29973 :: Cannot find item by 1666261761
1020 14:22:29974 :: Cannot find item by 1666261761
1020 14:22:29974 :: Cannot find item by 5
1020 14:22:29974 :: Cannot find item by 5
1020 14:22:30632 :: Cannot find item by 1666261981
1020 14:22:30632 :: Cannot find item by 1666261981
1020 14:22:30633 :: Cannot find item by 1666261981
1020 14:22:30633 :: Cannot find item by 3
1020 14:22:30633 :: Cannot find item by 3
1020 14:22:31193 :: Cannot find item by 1666261761
1020 14:22:31193 :: Cannot find item by 1666261761
1020 14:22:31193 :: Cannot find item by 1666261761
1020 14:22:31193 :: Cannot find item by 5
1020 14:22:31194 :: Cannot find item by 5
1020 14:22:31953 :: Cannot find item by 1666261761
1020 14:22:31953 :: Cannot find item by 1666261761
1020 14:22:31953 :: Cannot find item by 1666261761
1020 14:22:31953 :: Cannot find item by 5
1020 14:22:31953 :: Cannot find item by 5
1020 14:22:31955 :: Cannot find item by 1666261761
1020 14:22:31955 :: Cannot find item by 1666261761
1020 14:22:31955 :: Cannot find item by 1666261761
1020 14:22:31955 :: Cannot find item by 5
1020 14:22:31955 :: Cannot find item by 5
1020 14:22:31956 :: Cannot find item by 1666261761
1020 14:22:31956 :: Cannot find item by 1666261761
1020 14:22:31956 :: Cannot find item by 1666261761
1020 14:22:31956 :: Cannot find item by 5
1020 14:22:31956 :: Cannot find item by 5
1020 14:22:31957 :: Cannot find item by 1666261761
1020 14:22:31957 :: Cannot find item by 1666261761
1020 14:22:31957 :: Cannot find item by 1666261761
1020 14:22:31957 :: Cannot find item by 5
1020 14:22:31957 :: Cannot find item by 5
1020 14:22:33967 :: Cannot find item by 1666261761
1020 14:22:33967 :: Cannot find item by 1666261761
1020 14:22:33967 :: Cannot find item by 1666261761
1020 14:22:33967 :: Cannot find item by 6
1020 14:22:33967 :: Cannot find item by 6
1020 14:22:33999 :: Cannot find item by 1666261980
1020 14:22:33999 :: Cannot find item by 1666261980
1020 14:22:33999 :: Cannot find item by 1666261980
1020 14:22:34000 :: Cannot find item by 4
1020 14:22:34000 :: Cannot find item by 4
1020 14:22:34163 :: Cannot find item by 1666261980
1020 14:22:34163 :: Cannot find item by 1666261980
1020 14:22:34163 :: Cannot find item by 1666261980
1020 14:22:34163 :: Cannot find item by 4
1020 14:22:34163 :: Cannot find item by 4
1020 14:22:34197 :: Cannot find item by 1666261761
1020 14:22:34197 :: Cannot find item by 1666261761
1020 14:22:34197 :: Cannot find item by 1666261761
1020 14:22:34197 :: Cannot find item by 6
1020 14:22:34197 :: Cannot find item by 6
1020 14:22:37737 :: Cannot find item by 1666261756
1020 14:22:37737 :: Cannot find item by 1666261756
1020 14:22:37737 :: Cannot find item by 1666261756
1020 14:22:37737 :: Cannot find item by 6
1020 14:22:37737 :: Cannot find item by 6
1020 14:22:37738 :: Cannot find item by 1666261756
1020 14:22:37738 :: Cannot find item by 1666261756
1020 14:22:37738 :: Cannot find item by 1666261756
1020 14:22:37738 :: Cannot find item by 6
1020 14:22:37738 :: Cannot find item by 6
1020 14:22:37739 :: Cannot find item by 1666261756
1020 14:22:37739 :: Cannot find item by 1666261756
1020 14:22:37739 :: Cannot find item by 1666261756
1020 14:22:37739 :: Cannot find item by 6
1020 14:22:37739 :: Cannot find item by 6
1020 14:22:56769 :: Cannot find item by 1666261756
1020 14:22:56769 :: Cannot find item by 1666261756
1020 14:22:56769 :: Cannot find item by 1666261756
1020 14:22:56769 :: Cannot find item by 6
1020 14:22:56769 :: Cannot find item by 6
1020 14:22:06703 :: Cannot find item by 1666272159
1020 14:22:06703 :: Cannot find item by 1666272159
1020 14:22:06703 :: Cannot find item by 1666272159
1020 14:23:53346 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:23:01978 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:23:03791 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:23:04004 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:23:17817 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:23:18461 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:23:19466 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:23:21429 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:23:23064 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:23:23377 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:24:26577 :: Phase Game does not handle this header (header: 140, last: 21, 140)
1020 14:24:38749 :: Cannot find item by 1666261655
1020 14:24:38749 :: Cannot find item by 1666261655
1020 14:24:38749 :: Cannot find item by 1666261655
1020 14:24:38749 :: Cannot find item by 7
1020 14:24:38749 :: Cannot find item by 7
1020 14:24:38750 :: Cannot find item by 1666261655
1020 14:24:38750 :: Cannot find item by 1666261655
1020 14:24:38750 :: Cannot find item by 1666261655
1020 14:24:38750 :: Cannot find item by 7
1020 14:24:38750 :: Cannot find item by 7
1020 14:24:38752 :: Cannot find item by 1666261655
1020 14:24:38752 :: Cannot find item by 1666261655
1020 14:24:38752 :: Cannot find item by 1666261655
1020 14:24:38752 :: Cannot find item by 7
1020 14:24:38752 :: Cannot find item by 7
1020 14:24:41643 :: Cannot find item by 1666261655
1020 14:24:41643 :: Cannot find item by 1666261655
1020 14:24:41643 :: Cannot find item by 1666261655
1020 14:24:41643 :: Cannot find item by 7
1020 14:24:41643 :: Cannot find item by 7
1020 14:24:41875 :: Cannot find item by 1666261655
1020 14:24:41875 :: Cannot find item by 1666261655
1020 14:24:41875 :: Cannot find item by 1666261655
1020 14:24:41875 :: Cannot find item by 7
1020 14:24:41875 :: Cannot find item by 7

 

Syserr Log from Server (to not make this thread 15 pages, I am posting only the first line, please let me know if I need to post the rest of the syserr from server, although the following lines are similar to the one attached)

Same AsyncSQL for both mob_proto, item_proto.

Spoiler

SYSERR: Oct 20 12:35:25 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'type' at row 1 (query: REPLACE INTO mob_proto (vnum, name, locale_name, type, `rank`, battle_type, level, scale, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, sungma_st, sungma_dx, sungma_ht, sungma_iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, sungma_exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_fist, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_claw, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, resist_bleeding, att_elec, att_fire, att_ice, att_wind, att_earth, att_dark, resist_dark, resist_ice, resist_earth, dam_multiply, summon, drain_sp, skill_level0, skill_vnum0, skill_level1, skill

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now


×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.