Saving Player Error

[Slizzer]

Hey guys,

i have a problem with mysql. Can someone help me to solve it?

Error:
[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
Error while saving player: Playername

 

[Mateus Robeerto]

Open iologindata.cpp, and the function to save player, you have to cast sex as an actual sex.

Search for

query << "`sex` = " << player->sex << ',';

Change for

query << "`sex` = " << static_cast<uint16_t>(player->sex) << ',';

Just recompile and test.


If that doesn't work, try another link here

Database issue

Hey guys, looking for a bit of help with solving my current issue.. my database is unable to save players, i get this error code: [Error - mysql_real_query] Query: UPDATE players SET level = 8,group_id = 1,vocation = 3,health = 185,healthmax = 185,experience = 4200,lookbody = 0,lookfeet =...

otland.net

 

[lursky]

Acording to error it seems like there's an issue with blessings column.
Check type of the column in DB and how it's saved on your distro.

`blessings` tinyint NOT NULL DEFAULT '0'

Most important, what's the distro you're using? TFS 0.x/1.x? Canary?

 

[Slizzer]

I use TFS 1.3 Client 8.60

 

[middley]

You can try change 'blessings' from tinyint to int

 

[Mateus Robeerto]

run on your database

ALTER TABLE `players` ADD `blessings` INT NOT NULL DEFAULT '0';