Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1034 - Incorrect key


CeBepuH

Recommended Posts

This morning I received the following error:

 

 

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /httpd/virtual/rolli.bg/hali/shop/includes/functions/database.php on line 44

1034 - Incorrect key file for table: 'products'. Try to repair it

 

select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10

 

[TEP STOP]

 

 

And later i received this:

 

1016 - Can't open file: 'products.MYI'. (errno: 145)

 

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'

 

[TEP STOP]

 

 

I repaired the tables from phpmyadmin but those errors occured several times. Any idea what the problem is?

 

I'm using oscommrece2.2 milestone1, MySQL 4.0.12, Apache/1.3.27, PHP/4.3.1 under Linux...

 

Any help would be greatly appreciated.. :blink: :blink:

Link to comment
Share on other sites

It's pretty clear that the index (MYI) file became corrupted.

 

Many things could cause this, could even be a hardware disk problem,

or maybe a MYSQL restart or a server shutdown and restart.

 

However, rebuilding (repair) the index is pretty much the solution.

 

As you can see from the MYSQL site that message

 

145 = Table was marked as crashed and should be repaired

 

You can read about it here

 

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

 

HTH

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...