Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1034 - Incorrect key


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





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'





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





Link to comment
Share on other sites


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

  • Create New...