r40250 | SQL errors

[Mehti 81]

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?

[Chun-Chun 60]

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 .

 

[.InyaProduction 1721]

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

[Mehti 81]

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 .. ?

[Shogun 5755]

 

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

[Mehti 81]

 

 

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

[Shogun 5755]

`player_level` tinyint(4) DEFAULT NULL,

 

Make it unsigned

[Vanilla 1537]

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.