Cara Mengatasi Error :mod_security Error : The following exception has occurred: API failure: DBD::mysql::db selectall_arrayref failed: Table ‘hits’ is marked as crashed and should be repaired

In WHM > ModSecurity Tools, if you are getting the error as below.

Error : The following exception has occurred: API failure: DBD::mysql::db selectall_arrayref failed: Table 'hits' is marked as crashed and should be repaired

Then you will have to repair the database modsec in Mysql which is the default ModSecurity Table.

To repair the table use the commands as below.

root@media~]# mysqlcheck --repair modsec

Sample OutPut

modsec.hits
info     : Wrong bytesec:   0-  0-  0 at 128841108; Skipped
info     : Wrong bytesec:   0-  0-  0 at 224654552; Skipped
info     : Wrong bytesec:   0-  0-  0 at 225377068; Skipped
info     : Wrong bytesec:   0-  0-  0 at 225518580; Skipped
info     : Wrong bytesec:   0-  0-  0 at 225750608; Skipped
info     : Wrong bytesec:   0-  0-  0 at 225767896; Skipped
info     : Wrong bytesec:   0-  0-  0 at 226412232; Skipped
info     : Wrong bytesec:   0-  0-  0 at 226562416; Skipped
info     : Wrong bytesec:   0-  0-  0 at 226900744; Skipped
warning  : Number of rows changed from 830949 to 830873
status   : OK
modsec.modsec                                      OK

Now you should not get any error in ModSecurity Tools

• Author Details

Author Details

Mr ZAMI

admin dari seorang yang terus belajar dan mencatat pengalaman kasus tentang server dan web semoga berguna untuk yang lain 🙂 untuk memecahkan masalah yang sama

gamaludinz@gmail.com

Comments

comments