- activeCollab System Requirements
- Test if Your Server Meets the System Requirements
- activeCollab Installation
- Upgrade Instructions
- Upgrading from activeCollab Version 2
- Securing Your activeCollab
- Removing /public/index.php from URL-s
- Moving activeCollab to Another Server
- What are Scheduled Tasks? How to set them?
- Outgoing Mail Setup
- Incoming Mail Setup
- What is the Reply To Email tool?
- How to increase the maximum upload size?
- How to resolve an email conflict?
- Improving Search Index
- Debugging activeCollab
- File and Folder Permissions
- How do I fix missing icons and images in activeCollab?
- Solving Memory Problems
- Resolving "Failed to connect to database" Crashes
- Fixing Crashed or Corrupt MySQL Tables
- How to Turn Off eAccelerator or XCache?
- How to Backup and Restore activeCollab?
- How to configure the data cache?
- Custom Login and Logout Page
Fixing Crashed or Corrupt MySQL Tables
activeCollab uses a MySQL database to store your data. Occasionally, MySQL tables can crash or get corrupted for various reason. When something like that happens, you will get crash reports stating that the query failed because of missing file or invalid information in one of the files. Exact error messages may vary. For instance
1
Query failed with message 'Incorrect information in file: './db_name/ac_user_sessions.frm''
If you receive such a crash report, try repairing the table by using the phpMyAdmin tool:
Log in to the phpMyAdmin and navigate to the database where activeCollab is installed
Select the table that crashed by clicking on check-box in front of its name and select the Repair table option from drop-down at the bottom of the tables list.
If the Repair command fails to resolve the problem, please contact your hosting provider or system administrator for assistance.
