[SOLVED] DB error after changing jobs...and restarting server

[pajodex]

Hi, I just got this weird error and notice right now.. right after I change job, charserv is throwing this error..

[SQL]: DB error - Table '.\ragnarok\skill' is marked as crashed and should be repaired
[Debug]: at h:\dxro\rathena\src\char\char.cpp:420 - DELETE FROM `skill` WHERE `char_id`='150121'

I tested with other characters... still the same..

after I restart my server.. now I'm getting this error..

[SQL]: DB error - Table '.\ragnarok\skill' is marked as crashed and should be repaired
[Debug]: at h:\dxro\rathena\src\char\char.cpp:2292 - SELECT 1 FROM `skill` LIMIT 1;
[Fatal Error]: char : A tables is missing in sql-server, please fix it, see (sql-files main.sql for structure)

....

I was in the middle of testing my script and this suddenly happens. xD 

I'm not really good at this stuff so please forgive me.

 

Here is what happens when I open my sql database xD

 

 

SOLVED:
I dropped the `skill` table and made a new one xD

Edited April 30, 2018 by pajodex

[Tyrfing]

No need to drop it next time, just repair it. Open your MySQL console and execute the instruction:

USE <database> REPAIR TABLE <table_name>;