Mysql Prompt Error

When landing umail. Login to a certain user. The following error message appears.

Fatal Error: uncaught exception ' pdoexception ' with message ' sqlstate[hy000]: General error:145 Table './umail/wm_statistics ' is MA Rked as crashed and should be repaired ' in/usr/local/u-mail/data/www/webmail/admin/lib/umail/basedb.php:0stack trace:# 0/usr/local/u-mail/data/www/webmail/admin/lib/umail/basedb.php (0): Pdostatement->execute () #1 [internal Function]: Umail\basedb->callgetone (' wm_statistics ', ' mailbox_id ', ' domain_id =:d o ... ', Array, 0) #2/usr/local/ u-mail/data/www/webmail/admin/lib/umail/basedb.php (0): Call_user_func_array (array, array) #3/usr/local/u-mail/ data/www/webmail/admin/lib/webmail.php (0): Umail\basedb->__call (' Getone_statisti ... ', Array) #4/usr/local/ u-mail/data/www/webmail/admin/lib/webmail.php (0): webmail->getone_statistics (' mailbox_id ', ' domain_id =:d o ... ' , Array, 0) #5/usr/local/u-mail/data/www/webmail/admin/lib/webmail.php (0): Webmail->getstatisticsbyid (' 1 ', ' 239 ' , ' mailbox_id ', 0) #6/usr/local/u-mail/data/www/webmail/module/default/program/o_user.php(0): Webmail->setlastloginstat (' 1 ' in  /usr/local/u-mail/data/www/webmail/admin/lib/umail/basedb.phpOn line0

The inspection is caused by a problem with the table.

Find. You need to repair the index of the following table. Both myi files.

Final Solution:

[Email protected] bin]#/myisamchk-c-r/usr/local/u-mail/data/mysql/default/umail/wm_statistics. MYI
warning:using unique option prefix Read_buffer instead of read_buffer_size is deprecated and would be removed in a future Release. Please use the full name instead.
warning:using unique option prefix Write_buffer instead of write_buffer_size is deprecated and would be removed in a futur E release. Please use the full name instead.
-Recovering (with sort) myisam-table '/usr/local/u-mail/data/mysql/default/umail/wm_statistics. MYI '
Data records:95
-Fixing Index 1
[Email protected] bin]# pwd
/usr/local/u-mail/service/mysql/bin

Try landing again. Back to normal.

Mysql Prompt Error