[ SQL error ] picklog crashed

[Zirius 1]

Hello! Everytime I kill a monster this error shows:

 

[SQL]: DB error - Table '.hercules_logspicklog' is marked as crashed and should be repaired[Debug]: at ..srcmaplog.c:138 - INSERT DELAYED INTO `picklog` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `card0`, `card1`, `card2`, `card3`, `map`, `unique_id`) VALUES (NOW(), '1002', 'M', '909', '-1', '0', '0', '0', '0','0', 'pay_fild01', '0') 

 

How can I fix this and how to avoid? I wonder how can  repair that on phpmyadmin?

 

I am running Hercules under Xampp (Version: 1.8.3) on Windows 7 64bit platform.

 

thanks!

[jaBote 438]

It happens when forcing server quit while it's running a SQL query. Can happen with any table on any database, bit it's more frequent to happen with log tables since server logs lots of things.

 

PS: moving to General Server Support

[jaBote 438]

Just repair the table. Google how to repair a MySQL table for that.

[Zirius 1]

Done thanks. Well I guess I'll just update this thread if the problem reappeared again. Thanks!

[Zirius 1]

It happens when forcing server quit while it's running a SQL query. Can happen with any table on any database, bit it's more frequent to happen with log tables since server logs lots of things.

 

PS: moving to General Server Support

 

Well then that explains everything. Thanks!