Patch Version: 1.0
Platform: osCommerce

Problem:
Your site has been running fine, but now you're seeing error messages like "1034 - Incorrect key file for table 'sessions'; try to repair it" or "1016 - Can't open file: 'products_description.MYI'. (errno: 145)".

Solution:
The "DB Admin Patch" is an osCommerce 2.2 add-on that provides an easy-to-use interface for performing database upkeep operations.

Five operations can be performed on any one of the tables found in your database:

• Analyze - analyze and store key distribution
• Check - Checks a table for errors
• Describe - Shows all fields and their type, etc.
• Optimize - Defragments the data file for a table.
• Repair - Repairs a possibly corrupted table.

When errors are found, using this tool you can analyze and repair your tables without having to log in to your phpMyAdmin tool and learn cryptic SQL commands.

The tables that end up having the most problems are often the 'whos_online' and 'sessions' tables. This is because with almost every request by your users, writes are being performed to these tables. With the high usage on these tables, they are more prone to having problems. Regular maintenance of these tables will keep them operating efficiently and minimize the downtime that your store experiences.

This fix is compatible with PHP v4.x and above and all versions of MySQL.