Table pmech/ibf_captcha' getting crashed again and again

[Saurabh Jain]

Support team says there is a problem in MYsql

webhost says there is a problem in script

but only this table getting crashed again and again.....  What can be the reason>??

 

Regards

Saurabh

 

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Mon, 16 Feb 2015 13:17:06 +0000
 Error: 145 - Table './mechanic_ipmech/ibf_captcha' is marked as crashed and should be repaired
 IP Address: 2.87.81.200 - /forum/blog/198/entry-784-designing-mechatronics-system/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: DELETE FROM ibf_captcha WHERE captcha_date < 1423876626 OR captcha_ipaddress='2.87.81.200'
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | ips_kernel/classCaptchaPlugin/default.php                                  | [db_main_mysql].delete                                                        | 681               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | ips_kernel/classCaptchaPlugin/default.php                                  | [captchaPlugin]._clearSessions                                                | 89                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | ips_kernel/classCaptcha.php                                                | [captchaPlugin].getTemplate                                                   | 77                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/comments/bootstrap.php                               | [classCaptcha].__call                                                         | 291               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/comments/bootstrap.php                               | [classCaptcha].getTemplate                                                    | 291               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/comments/bootstrap.php                               | [classes_comments_renderer].getCaptcha                                        | 266               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/blog/modules_public/display/entry.php         | [classes_comments_renderer].fetchFormatted                                    | 467               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_blog_display_entry].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

[NenaDice]

This kind of repeated crashed table points to an issue with the server.

A myisam check will be enough to get details regarding the reason as to what is causing that table to crash btw.  For more details have a look here:

http://dev.mysql.com/doc/refman/5.0/en/myisam-check.html

[ASTRAPI]

You can try to repair it using this command from ssh:

mysqlcheck --all-databases -uroot -p

then apply your mysql root password and hit enter and wait as it will need a few seconds/minutes.

or if you don't have root access you can login to sql using this command:

mysql -udbusername -p databasename

and then run this:

REPAIR TABLE tablename;