Error saving character

[failkin]

[Error - mysql_real_query] Query: UPDATE players SET level = 8,group_id = 1,vocation = 1,health = 185,healthmax = 185,experience = 4200,lookbody = 63,lookfeet = 100,lookhead = 52,looklegs = 99,looktype = 129,lookaddons = 0,maglevel = 0,mana = 90,manamax = 90
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',lastlogin = 1622648207,lastip = 2429951815,conditions = '',`skulltime...' at line 1
Error while saving player: Failkin

whenever a character logs out I get this error every time they completely reset back to the temple. skull time is in my player database so i'm a little confused where else the error would be? tfs 1.2.

 

[failkin]

Bump

this has now happened on 3 clean installs of tfs 1.2 by 3 different people

 

[ayusutina]

Nostalrius bug with sex on iologindata.cpp

 

[Addams]

Check this to fix the issue ayusutina mentioned above.

Characters being reset after logging out.

I've compiled and got the current OTservBR running from this thread: https://otland.net/threads/new-ot-project-otservbr-global-10x-outdated-with-sprites-12-15.264701/ It works wonderfully, however all characters are being reset to new character stats and outfits if they log out. The error I'm...

otland.net

and if it didn't solve your character's saving maybe check this

TFS 1.X+ - No character Save - MySQL Error

Hi otlanders, This error is showing up when I switch off the character, and he doesn't save. [Error - mysql_real_query] Query: UPDATE `players` SET `level` = 8,`group_id` = 1,`vocation` = 1,`health` = 185,`healthmax` = 185,`experience` = 4200,`lookbody` = 106,`lookfeet` = 95,`lookhead` =...

otland.net

I also think that you shouldn't compile TFS 1.2 using Visual Studio 2019/vcpkg if you're doing so then you should use Toolsetv141

 

[failkin]

in IOLoginData::savePlayer(), change:
from: query << "sex = " << player->sex << ',';
to: query << "sex = " << (int)(player->sex) << ',';

if you're referring to this I've tried and it didn't work

Post automatically merged: Jun 5, 2021

Check this to fix the issue ayusutina mentioned above.

Characters being reset after logging out.

I've compiled and got the current OTservBR running from this thread: https://otland.net/threads/new-ot-project-otservbr-global-10x-outdated-with-sprites-12-15.264701/ It works wonderfully, however all characters are being reset to new character stats and outfits if they log out. The error I'm...

otland.net

and if it didn't solve your character's saving maybe check this

TFS 1.X+ - No character Save - MySQL Error

Hi otlanders, This error is showing up when I switch off the character, and he doesn't save. [Error - mysql_real_query] Query: UPDATE `players` SET `level` = 8,`group_id` = 1,`vocation` = 1,`health` = 185,`healthmax` = 185,`experience` = 4200,`lookbody` = 106,`lookfeet` = 95,`lookhead` =...

otland.net

I also think that you shouldn't compile TFS 1.2 using Visual Studio 2019/vcpkg if you're doing so then you should use Toolsetv141

Its a Linux VPS ubuntu i didnt use windows for it, the skull time line is in the players table so where would I look to actually quote the 0?

 

[ayusutina]

in IOLoginData::savePlayer(), change:
from: query << "sex = " << player->sex << ',';
to: query << "sex = " << (int)(player->sex) << ',';

if you're referring to this I've tried and it didn't work

Post automatically merged: Jun 5, 2021

Its a Linux VPS ubuntu i didnt use windows for it, the skull time line is in the players table so where would I look to actually quote the 0?

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

 

[failkin]

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

yea that didnt work either do I need to recompile or something?

 

[ayusutina]

yea that didnt work either do I need to recompile or something?

Yes, of course, if you want send me a dm

 

[failkin]

Yes, of course, if you want send me a dm

the recompile fixed it with the edits thanks!

 

[luptonicedtea]

Nostalrius bug with sex on iologindata.cpp

This was the callout that solved it for me.

iologindata.cpp
bool IOLoginData::savePlayer(Player* player)

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

to

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

If you're getting the error:
[Error - mysql_real_query] Query: UPDATE players SET level = 8,group_id = 1,vocation = 1,health = 185,healthmax = 185,experience = 4200,lookbody = 63,lookfeet = 100,lookhead = 52,looklegs = 99,looktype = 129,lookaddons = 0,maglevel = 0,mana = 90,manamax = 90
Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ',lastlogin = 1622648207,lastip = 2429951815,conditions = '',`skulltime...' at line 1
Error while saving player: Playername

You need to modify iologindata.cpp and recompile.
Change line 688 from
query << "sex = " << player->sex << ',';
to
query << "sex = " << (int)(player->sex) << ',';
or if that doesn't work, try:
query << "sex = " << static_cast<uint16_t>(player->sex) << ',';

But thank you very much, @emil92b, for your response from three years ago, and thank you @ayusutina for the reference!