#CASHPOINTS changes cause freeze

[grandholy]

First, everything works well.

I use @cash to add a little cash to my admin char.

then I write a script which is an NPC with this command:

set #CASHPOINTS, #CASHPOINTS + 1000;

everything works well.

Then I sleep. My computer freezed in the middle of night.

When I wake up, I started my server again and re-test the NPC script.

Whenever I touch CASHPOINTS (@cash, script above...), client freeze (can zoom, change view, etc...), then server cannot connect (can login though) until I close server and start again.

What can I do now?

Edited October 31, 2018 by grandholy

[Secrets]

Check if any of your MySQL table was crashed and repair them

[Normynator]

You should check the server logs, and share the server logs (server logs means: the output on the map/char/login server consol)

[grandholy]

On 10/31/2018 at 4:14 PM, Normynator said:

You should check the server logs, and share the server logs (server logs means: the output on the map/char/login server consol)

where can I get it?

 

On 10/31/2018 at 4:19 PM, Secrets said:

Check if any of your MySQL table was crashed and repair them

I've repair all the tables but the problem is still there.

Recompiled rathena -> not work.

Repair table -> not work.

 

 

Found it, I must repair Log db too. Only repair main db is not working.

Thanks for helping me.

[Gouki]

Would this be the way on how you repaired the tables?