MySQL Errors - Table Corrupted or marked as IN USE

At the top of the page it has a MySQL error that says that it can't connect to the xcart_sessions_table (or other table). The page displays ok, but the error is showing up on the page (several times sometimes) and it looks ugly.

This is a common error with MySQL tables that are using sessions to keep track of where customers are on a website. To fix these errros on your page it is a simple process:

1) Log into your CPanel

2) Click on the MySQL button

3) Click on the phpMyAdmin link at the bottom of the page

4) Select the database for your x-cart

5) On the new page there are checkboxes. Click the one next to the xcart_sessions_data and scroll to the bottom of the page

6) Using the dropdown menu, select to REPAIR table Problem should be fixed. It is also a good idea to select ALL TABLES and REPAIR TABLES this way. Optimizing tables is something else that should be done on a regular basis. Select all tables, and from the dropdown select Optimize Tables.

 

If this does not resolve your issue, and you have SHELL access, please use the following article: http://billing.handsonwebhosting.com/knowledgebase.php?action=displayarticle&id=254

  • Email, SSL
  • 7 Users Found This Useful
Was this answer helpful?

Related Articles

500 Internal Server Error when installing X-cart

If you get a 500 Internal Server error when trying to install x-cart, chances are the permissions...

Making the X-cart checkout secure

have a new SSL certificate installed, but I'm not sure how to get x-cart to recognize it. From...

How do I disable analog, webalizer, or awstat stat collection?

How do I disable analog, webalizer, or awstat stat collection?   By default, analog and...

iFrame Injection Attack - Site compromised or hacked

iFrame injection attacks are not quite as common as they once were on the web, however from time...

Microsoft Frontpage Extensions Support

Frontpage EOL (End of Life) – Important if you use MS Frontpage!In mid 2006, Microsoft announced...