Saurabh Jain Posted February 16, 2015 Posted February 16, 2015 Support team says there is a problem in MYsqlwebhost says there is a problem in scriptbut only this table getting crashed again and again..... What can be the reason>?? RegardsSaurabh --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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 Posted February 16, 2015 Posted February 16, 2015 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 Posted February 16, 2015 Posted February 16, 2015 You can try to repair it using this command from ssh:mysqlcheck --all-databases -uroot -pthen 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;
Recommended Posts
Archived
This topic is now archived and is closed to further replies.