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

Can't view images uploaded to the /

Images uploaded to the "files" directory of xcart aren't being displayed, and when bringing up...

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...

MySQL errors after initial X-cart Install

If you've just installed x-cart, but get a number of MySQL errors when you check the front page,...

What is the location of ImageMagick?

Is ImageMagick installed? Where is it located? Yes, we keep the latest release of the...

How do I install IonCube with a custom php.ini file?

If you create a custom php.ini file, you lose access to ioncube. Litecommerce and x-cart both...