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

MySQL Error Saving Player

Stylust

Banned User
Joined
Feb 15, 2015
Messages
12
Reaction score
4
Location
Canada
I'm currently running into this error when i try to login to the game server.

[Error - mysql_real_query] Query: UPDATE players SET level = 1,group_id = 3,vocation = 0,health = 100,healthmax = 100,experience = 0,lookbody = 10,lookfeet = 10,lookhead = 10,looklegs = 10,looktype = 136,lookaddons = 0,maglevel = 0,mana = 100,manamax = 100,`
Message: Out of range value for column 'blessings' at row 1
[Error - mysql_real_query] Query: UPDATE players SET level = 1,group_id = 3,vocation = 0,health = 100,healthmax = 100,experience = 0,lookbody = 10,lookfeet = 10,lookhead = 10,looklegs = 10,looktype = 136,lookaddons = 0,maglevel = 0,mana = 100,manamax = 100,`
Message: Out of range value for column 'blessings' at row 1
[Error - mysql_real_query] Query: UPDATE players SET level = 1,group_id = 3,vocation = 0,health = 100,healthmax = 100,experience = 0,lookbody = 10,lookfeet = 10,lookhead = 10,looklegs = 10,looktype = 136,lookaddons = 0,maglevel = 0,mana = 100,manamax = 100,`
Message: Out of range value for column 'blessings' at row 1

Any help would be must appreciated <3
 

Attachments

You should know by now to include details of your server, is this TFS or what?

Anyhow, the SQL errors are self explanatory, the blessings column is usually tinyint(signed) in most servers, so your update query is trying to set blessings to a value that either precedes or exceeds tinyint.
 
Back
Top