Thread: SQL problem
View Single Post
  #10  
Old 12-09-2004, 09:44 AM
  jeffwill's Avatar 
jeffwill jeffwill is offline
 

Advanced Member
  
Join Date: Feb 2003
Location: US
Posts: 41
 

Default 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;
__________________
X-Cart ver 3.4.14 (LIVE!)
PHP 4.3.8
MySQL server 4.1.15-log
Web server Apache/1.3.29
Operation system FreeBSD

X-Cart ver 4.0.9 (Dev)
PHP 4.3.4 Details
MySQL server 4.0.18
MySQL client 3.23.49
Reply With Quote