Compiling SQL Syntax error on Nostalrius 7.7 (TFS 1.2) dist

[loldinis]

I just compiled nostalrius 7.7, imported the sql schema and opened the server locally.

But when I disconnect a character, he cannot save the progression, the error is this:

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 '' at line 1

In advance, thanks for everyone who tried to help!

 

[Itutorial]

Look in the player.cpp file for player:Save or something like that. Look for the sql code and remove the: `s
Looks like that is the problem?

 

[loldinis]

Look in the player.cpp file for player:Save or something like that. Look for the sql code and remove the: `s
Looks like that is the problem?

`s

is soul, it does not fully show why the text is too long.




That's not the problem

Also, I didn't make any changes to the source, I just compiled

 

[Itutorial]

Maybe you should post the whole query then

 

[loldinis]

Full Query dont appear in log =(

 

[loldinis]

Solved!

In iologindata.cpp, the query that sets "sex" should be cast as uint16

 

[Igor Milagres]

Solved!

In iologindata.cpp, the query that sets "sex" should be cast as uint16

Hello friend, I have the same error, after changing the line: query << " sex=" << player->sex << ',';
for this: query << " sex=" << static_cast<uint16_t>(player->sex) << ',';

do I need to do anything else?