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

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

Can't view images uploaded to the /

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

CDSEO X-Cart Module Links Returning "File Not Found" Errors

If you have the CDSEO BASIC X-Cart module  (NOT PRO) installed on your site and your product 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...

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