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

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

Memory Allocation Error. Create a custom php.ini for PHP 5.2

Some programs produce errors in which it says the memory allocation is limited to 32MB and that...

How to install X-Cart

So you want to install X-cart. We think x-cart is a great choice; its highly customizable and...

Is there a limit to the number of emails (mailing lists and newsletters) that X-cart can send?

There are limits on the emails. We have a server imposed limit of a maximum of 400 emails sent...

Is my x-cart license actually mine? What if I choose to host elsewhere?

Yes. The software is 100% yours. If you choose to move to an alternate host, just be sure to...