SQL problem
 

atop my stores page i get this message(below). im not the greatest with computers so im to sure what i have to do to correct this issue.

INVALID SQL: 1016 : Can't open file: 'xcart_stats_pages_views.MYD'. (errno: 145)
SQL QUERY FAILURE: INSERT INTO xcart_stats_pages_views(pageid, date) VALUES('21','1080775865')

I talked to my server and they told me i do have pently of room in my sql. im using 3.5.1 x-cart. to view the issue

http://www.motorex.net/xcart/customer/home.php?cat=248

thanks.

Edit config.php,

find:


set it to true instead of false.

thanks, that worked. :D

im having this same problem with a client. and unfortunatly the mysql_autorepair line IS NOT in my config.php file. can anyone help me with this. thanks,
chris

I'm really not sure here, but I'm assuming you need to repair your table. Are you able to do this via shell or phpmyadmin?

http://www.mysql.com/doc/en/REPAIR_TABLE.html

Weird. I had the same problem, did what Boomer said and it didn't fix it for a couple of pages, then it was gone 8O Why is that even an option in config? Is it not good to keep it set to true?

Some people don't have proper permissions to use such features in mySQL, this could be one reason to disable this feature in config.php.

Thanks Boomer. For anyone else, it seems to be an issue with the host as mine corrected it.

Excellent post
 

Thanks for the config.php remedy - it worked!

This is a VERY helpful post!

:D

Excellent Post
 

I contacted my host and they told me they had a problem with the database I was connected to and performed some maintenance. This explained why I suddenly had SQL errors on my pages. The real problem was that they were not able to get this fixed with X-Cart, but that's why this forum is so great. Thanks for the fix BOOMER!

Always make sure to perform backups!!!

I used the following suggestion by modifying my config.php file and it worked perfectly. That's all I needed to do.

# Automatic repair of the broken indexes in mySQL tables
#
$mysql_autorepair = false;