Problems with products.

[xaol]

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.

[Guest]

Hi,

 

Did you try to repair that table in phpmyadmin?

 

Did your host change anything on their server?

[xaol]

i dont know how to repair it, can u tell me how??

 

thanks again

[Guest]

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.

[xaol]

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.

[Guest]

Do you have root access?

[xaol]

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

[xaol]

Yes, i have root access.

[xaol]

I have the solution.

 

REPAIR TABLE table_name

 

and that's all, with this, the problem has been resolved.

 

and thanks for your help.