SQL problem

cen · #1 03-31-2004, 04:08 PM

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.

B00MER · #2 03-31-2004, 04:21 PM

Edit config.php,

find:

Code:

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

set it to true instead of false.

cen · #3 03-31-2004, 05:44 PM

thanks, that worked.

tecdady · #4 04-06-2004, 09:42 AM

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

Jon · #5 04-06-2004, 10:19 AM

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

bluecat · #6 06-12-2004, 09:26 PM

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

Why is that even an option in config? Is it not good to keep it set to true?

B00MER · #7 06-13-2004, 08:01 AM

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.

bluecat · #8 06-13-2004, 08:35 AM

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

sublimebikinis · #9 09-30-2004, 01:14 PM

Thanks for the config.php remedy - it worked!

This is a VERY helpful post!

jeffwill · #10 12-09-2004, 09:44 AM

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;