Cpanel exim stat error >> Error: DBD::mysql::db failed: Table ‘./eximstats/ (How to Fix)

Error from delivery reporter: DBD::mysql::db selectall_arrayref failed: Table ‘./eximstats/failures’ is marked as crashed and last (automatic?) repair failed

Bu ve buna benzer hatalar DB hatalarıdır. Otomatik düzeltme denenmeli olmuyorsa alttaki diğer seçenekle göz önünde bulundurulmalıdır.

Otomatik denemek için : mysqlcheck –repair eximstats

bu işlem sonunda gelen hata

eximstats.defers OK eximstats.failures error : Can’t create new tempfile: ‘./eximstats/failures.TMD’ status : Operation failed

şeklinde ve düzelmiyor ise :

mysql use eximstats;
drop table failures;

bu iki komut ile hangi tablo bozuk ise onu siliyoruz.
sonrasında ise

bu komut ile onarıyoruz : /usr/local/cpanel/bin/updateeximstats

Eğer sorun dosya bozukluğu değil ise temizlemek te faydalı olabilir.

mysql use eximstats;
TRUNCATE TABLE sends;
TRUNCATE TABLE defers;
TRUNCATE TABLE smtp;

Bunlar sorunun kaynağını kesinlikle kökünden halledecektir.

If you get this error in WHM > View Sent Summary

Error from delivery reporter: DBD::mysql::db selectall_arrayref failed: Table ‘./eximstats/failures’ is marked as crashed and last (automatic?) repair failed
Try running this command

# mysqlcheck –repair eximstats
If you get this error as a result…

eximstats.defers OK eximstats.failures error : Can’t create new tempfile: ‘./eximstats/failures.TMD’ status : Operation failed
Something has corrupted the ‘failures’ table within eximstats. It’s unable to be repaired. To recreate it, do the following:

Via command line run these:

mysql use eximstats; drop table failures;
Then run:

/usr/local/cpanel/bin/updateeximstats
If you wish to ‘clear’ the other databases out, please note this will wipe out existing eximstats if you plan on using it for Mail Reports so keep that in mind. After you perform the above step, simply run

mysql use eximstats; TRUNCATE TABLE sends; TRUNCATE TABLE defers; TRUNCATE TABLE smtp;

Facebooktwittergoogle_plusredditpinterestlinkedinmail