How to Fix WHMCS Database Crashed (Table Marked as Crashed) Error
Running WHMCS for your web hosting business or billing platform is smooth — until you suddenly face a dreaded error:
SQLSTATE[HY000]: General error: 1194 Table 'tblticketmaillog' is marked as crashed and should be repaired
If you’re seeing this error, it means one or more MyISAM tables in your WHMCS database have crashed and require repair. This problem often occurs due to unexpected server shutdowns, disk space issues, or abrupt MySQL service interruptions.
In this guide, I’ll show you exactly how to fix WHMCS database crash errors step by step.
✅ Common Error Messages in WHMCS
- SQLSTATE[HY000]: General error: 1194 Table is marked as crashed
- MyISAM-table is corrupted, fix it using switch “-r” or “-o”
- WHMCS tblticketmaillog table marked as crashed
Why Does the WHMCS Database Crash Happen?
- Unexpected server reboots
- Low disk space
- Improper shutdown of MySQL
- Hardware or filesystem issues
How to Check for Crashed WHMCS Tables
- SSH into your server as root.
- Run this command to scan all MyISAM tables:
find /var/lib/mysql -name "*.MYI" -exec myisamchk {} \; | grep -Ei "error|corrupt|crash|not ok|recover|repair"
- This will show all tables that are either corrupted or require fixing.
How to Repair Crashed Tables in WHMCS
Step 1: Stop MySQL Service
Before repairing tables, it’s recommended to stop MySQL:
systemctl stop mysql
Step 2: Repair the Corrupted Table
Navigate to your WHMCS database directory (replace valtonetgroup_db with your DB name):
cd /var/lib/mysql/valtonetgroup_db
myisamchk -r -f tblticketmaillog.MYI
Step 3: Repair Other Tables
You might see warnings like “Table is usable but should be fixed.” You can repair them as well:
myisamchk -r -f tbladminlog.MYI
myisamchk -r -f tblconfiguration.MYI
myisamchk -r -f tbltickets.MYI
myisamchk -r -f tblemails.MYI
Step 4: Start MySQL Service Again
systemctl start mysql
Step 5: Verify Everything
find /var/lib/mysql -name "*.MYI" -exec myisamchk {} \; | grep -Ei "error|corrupt|crash|not ok|recover|repair"
If the output is clean, your WHMCS database is healthy.
Pro Tip: Automate Repairs
You can automatically repair all issues with one command:
find /var/lib/mysql -name "*.MYI" -exec myisamchk -r -f {} \;