DB error help

[darking123]

eathena svn here

 

[SQL]: DB error - Table './ragnarok/inventory' is marked as crashed and should b                                                                                        e repaired
[Debug]: at char.c:1059 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`,                                                                                         `refine`, `attribute`, `expire_time`, `card0`, `card1`, `card2`, `card3` FROM `i                                                                                        nventory` WHERE `char_id`=? LIMIT 100
[SQL]: DB error - Statement not prepared

 

[Mr BrycE]

check table, then at the bottom there's a menu named 'with selected' choose repair table

Edited October 25, 2013 by Mr BrycE

[Mr BrycE]

did you try the repair option?

[darking123]

how to repair it sir?

i am using phpmyadmin

[darking123]

check table, then at the bottom there's a menu named 'with selected' choose repair table

fixed

what is the cause of this problem sir?

[Mr BrycE]

maybe your low in disk space, or something else.

check your status logs

Edited October 25, 2013 by Mr BrycE

[15peaces]

query a sql-command in your database:

 

REPAIR TABLE `char`;
 

 

^^