Mehti 76 Posted March 28, 2014 Share Posted March 28, 2014 Hello Folks ! I using the r40250 gf, Vanilla 2.1, and self compiled core.. I saw sql errors, i know these bugs are important. Example when /shutdown server some players level go down. (this is a one example..) Here Syserr Logs Examples: same 30x SYSERR: Mar 28 12:12:52 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'player_level' at row 1 (query: INSERT INTO quest_reward_log VALUES('anti',58,128,2,2925162614,0,NOW()) errno: 1264) SYSERR: Mar 28 12:12:55 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'player_level' at row 1 (query: INSERT INTO quest_reward_log VALUES('anti',58,128,2,0,0,NOW()) errno: 1264) same 30x Have more same errors like this: SYSERR: Mar 28 12:38:51 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'level' at row 1 (query: REPLACE INTO levellog (name, level, time, playtime) VALUES('Sai', 147, NOW(), 401) errno: 1264) Have more same errors like this: SYSERR: Mar 28 18:31:32 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 47, 1104300, 1788500, 0, 'WARP', 'CommunityManager MapIdx 301 DestMapIdx0 DestX873100 DestY242600 Empire1', '46.2.210.244') errno: 1406) SYSERR: Mar 25 08:57:29 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 47, 1088040, 1652193, 0, 'WARP', 'CommunityManager MapIdx 303 DestMapIdx0 DestX969600 DestY278400 Empire1', '188.3.32.42') errno: 1406) Have more ....! SYSERR: Mar 28 01:15:19 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 47, 1105459, 1781272, 0, 'WARP', 'CommunityManager MapIdx 301 DestMapIdx0 DestX1107000 DestY1733000 Empire1', '46.2.210.244') errno: 1406) SYSERR: Mar 28 01:16:35 :: EquipTo: EquipTo: item already exist (this: #17189 Amethyst Earrings+9 cell: 6 Amethyst Earrings+9) SYSERR: Mar 28 01:43:07 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 47, 1104709, 1729398, 0, 'WARP', 'CommunityManager MapIdx 301 DestMapIdx0 DestX1104800 DestY1788800 Empire1', '46.2.210.244') errno: 1406) and other one : SYSERR: Mar 27 21:57:13 :: ChildLoop: MySQL connection was reconnected. querying locale set SYSERR: Mar 27 22:27:46 :: ChildLoop: MySQL connection was reconnected. querying locale set what are these? how to fix ? Do you have any suggestion? Link to comment Share on other sites More sharing options...
Chun-Chun 60 Posted March 29, 2014 Share Posted March 29, 2014 Dont use anymore /shutdown.... I stopeed using it ages ago, because it's 80% chance that some players would lose some items/lvl, etc. ( Not sure if it's a bug that can be solved, but i never searched for a way to fix it if i can shut it down from the console). Shut down the server from the console. It's not that hard . Link to comment Share on other sites More sharing options...
Former Staff .InyaProduction 1124 Posted March 29, 2014 Former Staff Share Posted March 29, 2014 Server down from the console has a much bigger chance for loss of items. In bad cases you will undo the last 15 minutes of the game and i already saw players loosing items they switched in the last 10 minutes 1 Link to comment Share on other sites More sharing options...
Mehti 76 Posted March 29, 2014 Author Share Posted March 29, 2014 Dont use anymore /shutdown.... I stopeed using it ages ago, because it's 80% chance that some players would lose some items/lvl, etc. ( Not sure if it's a bug that can be solved, but i never searched for a way to fix it if i can shut it down from the console). Shut down the server from the console. It's not that hard . When use /shutdown starting sync and it finish in 10 sec.. If you close with ssh, you lost db last cache.. Anyone have same bugs ? like query failed .. ? Link to comment Share on other sites More sharing options...
Premium Shogun 4591 Posted March 29, 2014 Premium Share Posted March 29, 2014 SYSERR: Mar 28 12:12:55 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'player_level' at row 1 (query: INSERT INTO quest_reward_log VALUES('anti',58,128,2,0,0,NOW()) errno: 1264) same 30x SYSERR: Mar 28 12:38:51 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'level' at row 1 (query: REPLACE INTO levellog (name, level, time, playtime) VALUES('Sai', 147, NOW(), 401) errno: 1264) Change the structure of both tables those fields are probably 8 bit signed (-125 to 125) make it unsigned and it should work. Have more same errors like this: SYSERR: Mar 28 18:31:32 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 47, 1104300, 1788500, 0, 'WARP', 'CommunityManager MapIdx 301 DestMapIdx0 DestX873100 DestY242600 Empire1', '46.2.210.244') errno: 1406) Increase the length of the "hint" field in log.log 1 Link to comment Share on other sites More sharing options...
Mehti 76 Posted March 29, 2014 Author Share Posted March 29, 2014 (edited) SYSERR: Mar 28 12:12:55 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'player_level' at row 1 (query: INSERT INTO quest_reward_log VALUES('anti',58,128,2,0,0,NOW()) errno: 1264) same 30x SYSERR: Mar 28 12:38:51 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'level' at row 1 (query: REPLACE INTO levellog (name, level, time, playtime) VALUES('Sai', 147, NOW(), 401) errno: 1264) Change the structure of both tables those fields are probably 8 bit signed (-125 to 125) make it unsigned and it should work. Have more same errors like this: SYSERR: Mar 28 18:31:32 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'hint' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip) VALUES('CHARACTER', NOW(), 47, 1104300, 1788500, 0, 'WARP', 'CommunityManager MapIdx 301 DestMapIdx0 DestX873100 DestY242600 Empire1', '46.2.210.244') errno: 1406) Increase the length of the "hint" field in log.log already i tried log.log not work :/ And its correct ? DROP TABLE IF EXISTS `quest_reward_log`; CREATE TABLE `quest_reward_log` ( `quest_name` varchar(32) DEFAULT NULL, `player_id` int(10) unsigned DEFAULT NULL, `player_level` tinyint(4) DEFAULT NULL, `reward_type` enum('EXP','ITEM') DEFAULT NULL, `reward_value1` int(10) unsigned DEFAULT NULL, `reward_value2` int(11) DEFAULT NULL, `time` datetime DEFAULT NULL, KEY `player_id` (`player_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=big5 ROW_FORMAT=DYNAMIC; Edited August 15, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium Shogun 4591 Posted March 29, 2014 Premium Share Posted March 29, 2014 `player_level` tinyint(4) DEFAULT NULL, Make it unsigned Link to comment Share on other sites More sharing options...
Vanilla 1455 Posted March 29, 2014 Share Posted March 29, 2014 You don't need to change to unsigned and hope for it to work. You can even make greater changes from tinyint to int so you won't have any problems. 1 We are the tortured. We're not your friends. As long as we're not visible. We are unfixable. 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