Problem with Levels

[Karbust 4909]

Hello,

I have a problem on my serverfiles, the problem is that when I gain level, that level isn't update on the database, is just valid for the session or until I reboot the server, but if I edit the level on the database this is changed, so, I guess that the server isn't updating the level...

I guess this problem started after I applied this changes: https://metin2dev.org/board/index.php?/topic/7718-cexpand-maximum-level/

I set the max level 300

Thanks

Kind regards,

charparodar

[bumxd 17]

maybe right on table player small? do 750 or 777

[Karbust 4909]

The tables have all 777 rights, and I saw that isn't jus the level that isn't being update, is the last play date, ip, coordinates, everything, the server is just reading and not editing anything...

And, when the server is iniciated I receive a lot of warnings

I guess both things are connected...

Edited August 20, 2022 by Metin2 Dev
Core X - External 2 Internal

[Vanilla 1456]

Is your database capable of storing higher values? Please check if you can manually alter a table entry and set it's level to e. g. 300.

Also make sure you have a look on syslog, maybe there's a query error there. Most likely you missed a step from the guide.

[Karbust 4909]

I already saw syslog, it says that I used the command level, but doesn't says nothing about a query, and I even tried to set level 120, but the same error...

[Karbust 4909]

BUMP

[raihan3 20]

same with me by the way did you fixed 

[bumxd 17]

mysql your 5.6?

[Karbust 4909]

2 hours ago, bumxd said:

mysql your 5.6?

Yes

3 hours ago, raihan3 said:

same with me by the way did you fixed 

I didn't understood...

[bumxd 17]

If your MySQL client/server version is a 5.6.x a way to avoid the WARNING message are using the mysql_config_editor tools:

mysql_config_editor set --login-path=local --host=localhost --user=username --password

Then you can use in your shell script:

mysql --login-path=local -e "statement"

instead of:

mysql -u username -p pass -e "statement"

[Karbust 4909]

I don't use shell scripts with MySQL commands, that error just starts appearing when I start the server...

 

By the way, I already executed that command, but I don't now where do I use that method...

[raihan3 20]

On 04/01/2016 at 8:25 PM, charparodar said:

Yes

I didn't understood...

this lvl problem on my server too but player have 777 right and mysql version 5.6

[Karbust 4909]

I have mysql 5.6 and the files are with 777 rights

[bumxd 17]

reinstall mysql to 5.5

[raihan3 20]

 

11 hours ago, bumxd said:

reinstall mysql to 5.5

same problem on my server i installed 5.6