Jump to content
×
×
  • Create New...
  • 0

r40250 | SQL errors


Mehti

Question

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

7 answers to this question

Recommended Posts

  • 0

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

  • 0

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

  • 0
  • Premium
 
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
  • Love 1

 

 

Link to comment
Share on other sites

  • 0

 

 

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

 

7NQIi.png

 

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;
Link to comment
Share on other sites

  • 0

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.

  • Love 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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


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.