iderx 0 Posted July 9, 2022 Share Posted July 9, 2022 This is what im gettin in ch12 SysErr after i get kicked out after attacking mobs\spiders and i cant reconnect to that map (i tried entering the desert with another character but it also just kicked me out and i couldnt log in with that character, the only temporery solution i found is to after every channel dies when i try to farm stuff , i restart the server and i do it just like this over and over ) Quote SYSERR: Jul 9 04:33:04 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1657420384, 0, 2160000281, 'SET_SOCKET', '', '', 30270) errno: 1264) SYSERR: Jul 9 04:33:04 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 1657420384, 0, 2160000277, 'SET_SOCKET', '', '', 30270) errno: 1264) SYSERR: Jul 9 04:33:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 0, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264) SYSERR: Jul 9 04:33:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 58856, 280654, 618133, 2180001756, 'DS_ACTIVATE', 'LEFT TIME(5760)', '25.50.94.43', 164040) errno: 1264) SYSERR: Jul 9 04:33:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 2, 1, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264) SYSERR: Jul 9 04:34:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 5700, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264) SYSERR: Jul 9 04:35:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 5640, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264) This is what im getting in Ch99 SysErr Quote SYSERR: Jul 9 04:32:18 :: regen_load: No mob data by vnum 20400 SYSERR: Jul 9 04:32:18 :: SpawnMob: SpawnMob: no mob data for vnum 20400 SYSERR: Jul 9 04:33:41 :: SpawnMob: SpawnMob: no mob data for vnum 20400 SYSERR: Jul 9 04:35:11 :: SpawnMob: SpawnMob: no mob data for vnum 20400 SYSERR: Jul 9 04:36:41 :: SpawnMob: SpawnMob: no mob data for vnum 20400 and this is what im getting in Db SysErr Quote SYSERR: Jul 9 04:35:35 :: Process: FDWATCH: peer null in event: ident 21 And this is what i found in SysLog inside Ch12 folder Quote SYSERR: Jul 9 04:35:08 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'what' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 0, 5640, 0, 2180001756, 'SET_SOCKET', '', '', 164040) errno: 1264) Jul 9 04:35:14 :: SpawnMob: cannot create monster at non-exist sectree 405100 x 656600 (map 61) And after i get kicked out of the server i checked the Server\Machine and typed ps Before i got kicked out, all channels were working and i could see them on when i typed ps, but after i got kicked out Ch12 wasn't on the list when i typed ps (later after i got kicked out on other channels i also checked and ch22 ch32 and ch42 also died\turned off\Crashed and had the same error that ch12 had) I dont really know what is wrong with this Im playing on Terenzo files Link to comment Share on other sites More sharing options...
Active+ Member m2Ciaran 404 Posted July 9, 2022 Active+ Member Share Posted July 9, 2022 (edited) Debug the core and show results How To Use GDB for your game.core for Debug - Guides & HowTo - Metin2 Dev Edited July 9, 2022 by m2Ciaran 1 Link to comment Share on other sites More sharing options...
Premium WeedHex 636 Posted July 9, 2022 Premium Share Posted July 9, 2022 CH12? Maybe you are in overflow. Needed gdb! #ps afxu Would be better however 1 Link to comment Share on other sites More sharing options...
thax 4 Posted July 9, 2022 Share Posted July 9, 2022 2 hours ago, iderx said: Im playing on Terenzo files mob_proto > 2001 (young spider) > set hp more than 0 1 1 Link to comment Share on other sites More sharing options...
iderx 0 Posted July 9, 2022 Author Share Posted July 9, 2022 1 hour ago, thax said: set hp more than 0 Earlier, i was farming for about 15 seconds max and bam it crashed Set hp for 2002 (Poison Spider had 0 ) in mob_proto in navicat and it looks like the problem has been fixed for now. I was farming spiders for about 5 min and it didnt crash once. Thanks a lot Link to comment Share on other sites More sharing options...
Premium Syreldar 1883 Posted July 9, 2022 Premium Share Posted July 9, 2022 (edited) SELECT `locale_name`, `max_hp` FROM `player`.`mob_proto` WHERE `max_hp` = 0 AND (`type` = 0 OR `type` = 2); This makes you see all the monsters and metins that have a bugged max_hp value in your proto, so you can fix them manually. but, If you want to temporarily fix them all automatically, you can run this: UPDATE `player`.`mob_proto` SET `max_hp` = 100 WHERE `max_hp` = 0 AND (`type` = 0 OR `type` = 2); Edited July 9, 2022 by Syreldar "Nothing's free in this life. Ignorant people have an obligation to make up for their ignorance by paying those who help them. Either you got the brains or cash, if you lack both you're useless." Syreldar Link to comment Share on other sites More sharing options...
iderx 0 Posted July 9, 2022 Author Share Posted July 9, 2022 thanks I checked and i do not have any more bugged values Looks like everything is working as it should 1 hour ago, Syreldar said: SELECT `locale_name`, `max_hp` FROM `player`.`mob_proto` WHERE `max_hp` = 0 AND (`type` = 0 OR `type` = 2); This makes you see all the monsters and metins that have a bugged max_hp value in your proto, so you can fix them manually. but, If you want to temporarily fix them all automatically, you can run this: UPDATE `player`.`mob_proto` SET `max_hp` = 100 WHERE `max_hp` = 0 AND (`type` = 0 OR `type` = 2); 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