Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problems with products.


xaol

Recommended Posts

Hey guys i have a shop running since February and no problem until now.

I dont know why but suddenly when i click on any product to see its details i have the next error:

 

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



select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '272' and opa.orders_id = opb.orders_id and opb.products_id != '272' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6



[TEP STOP

 

and it doesnt show the right modules.

 

I have tried to reinstall the application but the error is still showing up.

 

how could i repair this??

 

thanks a lot.

Link to comment
Share on other sites

Hi,

 

Go into phpmyadmin.

Click on the table on the left side.

On the right side click on "Operations".

Scroll down and you can repair table.

Link to comment
Share on other sites

well, i did it but the same error appears:

 

Can't open file: 'orders.MYI'. (errno: 145)

 

Error

 

SQL-query :

 

SHOW KEYS FROM `orders`

 

MySQL said:

 

 

Can't open file: 'orders.MYI'. (errno: 145)

 

 

 

... and the table maintenance menu doesn't appear so i can't repair it.

Link to comment
Share on other sites

what if i download the database and try to repair it from MySql Front??

can i do it from phpmyadmin?

 

i have seen this on the mysql manual:

 

"REPAIR TABLE works only on MyISAM tables and is the same as running myisamchk -r table_name on the table. "

 

perhaps running this could resolve the problem but i dont know.

help me please.

 

thanks

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...