console error

[dfsuno]

Could you help me, I get this error on my console.

[Error - mysql_real_query] Query: UPDATE `accounts` SET `name` = 'juanito3' , `type` = ☺ , `password` = 'ef0a2514cd3b9c97b9c84e163aff44ce21c0aa97' , `premdays` = 30 , `lastday` = 1687456447 WHERE `id` = 272

Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '☺ , `password` = 'ef0a2514cd3b9c97b9c84e163aff44ce21c0aa97' , `premdays` = 30 , ' at line 1

 

[Mateus Robeerto]

As I understand it, your database is missing the word "premmy". You will need to add it to your database.

UPDATE `accounts` SET `premdays` = `premdays` + 6 WHERE `premdays` >= 1

you can add the word "premmy" to your database by following these steps: go to the SQL and do the addition, then run it. Soon, the problem will be solved.

 

[dfsuno]

I keep getting the same error.

 

[mano368]

I keep getting the same error.View attachment 76448

Show your account table, the structure part

 

[Mateus Robeerto]

I keep getting the same error.View attachment 76448

What is your engine version?

Don't fool me, this SQL is correct. Try running it against your database."

ALTER TABLE `accounts` ADD `premdays` int NOT NULL;

 

[dfs1]

I'm usingI uniserv XV and tfs 1.3 witch znote acc @Mateus Robeerto @mano368

 

[Mateus Robeerto]

I understand, but does it save your character in the database normally, for example, when disconnecting and reconnecting, does it save correctly, without errors? If you downloaded TFS 1.3, where did you download it from? Can you show me your source in the iologindata.cpp file? Please search for

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

or

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

 

[dfs1]

if everything is saved correctly, if you enter and exit.

here it is.

Paste ofCode

paste.ofcode.org

 

[Mateus Robeerto]

I took a look at your source and found that the change was already made correctly. However, I am unable to pinpoint the reason for the errors being displayed in the console. There could be other parts of the code or external factors that are causing these errors. It would be recommended to investigate further and perform additional tests to identify the source of the problems and correct them.



Let's wait for the answer from the person in charge who requested your table and you already posted a screenshot. Let's wait until he responds with his review @mano368

 

[dfs1]

thank you @Mateus Robeerto for taking the time.

I hope to find the problem since the console is closing itself.

Post automatically merged: Jun 27, 2023

if you saw that it had an emoji?