• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

error of mysql connection in console

Thorn

Spriting since 2013
Joined
Sep 24, 2012
Messages
2,203
Solutions
1
Reaction score
921
Location
Chile
hello guys, i recently noticed this in my console, does anyone know why this happened? what does it mean? and how can it be solved??

Code:
[3/5/2017 19:23:29] mysql_commit() - MYSQL ERROR: Lost connection to MySQL server during query (2013)
[3/5/2017 19:23:29] mysql_real_query(): SELECT * FROM shop_history WHERE processed=0 - MYSQL ERROR: MySQL server has gone away (2006)
[3/5/2017 19:23:29] > WARNING: MYSQL Lost connection, attempting to reconnect...mysql_commit() - MYSQL ERROR: Lost connection to MySQL server during query (2013)
[3/5/2017 19:23:40] mysql_real_query(): SELECT * FROM shop_history WHERE processed=0 - MYSQL ERROR: MySQL server has gone away (2006)
[3/5/2017 19:23:44] > WARNING: MYSQL Lost connection, attempting to reconnect...mysql_real_query(): UPDATE `players` SET `lastlogin` = 1493832142, `lastip` = 1840989114, `level` = 173, `group_id` = 1, `health` = 5925, `healthmax` = 5925, `experience` = 84053478, `lookbody` = 68, `lookfeet` = 76, `lookhead` = 78, `looklegs` = 58, `looktype` = 128, `lookaddons` = 0, `lookmount` = 0, `maglevel` = 66, `mana` = 10045, `manamax` = 10050, `manaspent` = 461901, `soul` = 200, `town_id` = 6, `posx` = 1661, `posy` = 134, `posz` = 8, `cap` = 2650, `sex` = 1, `balance` = 0, `stamina` = 146884290, `skull` = 0, `skulltime` = 0, `promotion` = 1, `conditions` = '\0\0\0ÿÿÿÿ`ê\0\0\Z\0\0\0\0\0\0\0\0þ\0\0€\0ÿÿÿÿPÃ\0\0\Z\0\0\0\0\0\0\0\0þ\0@\0\0ÿÿÿÿp‚\0\Z\0\0\0\0\0\0\0\0\0\0\0˜:\0\0þ', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1493831267, `blessings` = 31, `pvp_blessing` = 1, `offlinetraining_time` = 43200, `offlinetraining_skill` = -1, `marriage` = 0, `guildnick` = '', `rank_id` = 0, `vocation` = 1 WHERE `id` = 84 LIMIT 1; - MYSQL ERROR: Lost connection to MySQL server during query (2013)
[3/5/2017 19:23:55] > WARNING: MYSQL Lost connection, attempting to reconnect...> Broadcasted message: "Information: Para hacer Bounty di !bounty".
 
Error 2013: If you're using your real IP instead of Localhost in your config.lua to connect to MySQL, change it.
Error 2006: In your config.lua change "maxPacketsPerSecond = x" to something that suits your needs better.
 
Error 2013: If you're using your real IP instead of Localhost in your config.lua to connect to MySQL, change it.
Error 2006: In your config.lua change "maxPacketsPerSecond = x" to something that suits your needs better.
wait but if i use localhost, players will still be able to login? i had my ip there, i should put localhost instead then?
and for maxpacketspersecond i have 50, should i increase it? to how much you suggest?
 
Back
Top