Database errno: 144

[magma]

I have the MS 1 Version for a few years with no problems, but in the last weeks a few problems with the database.

 

I got this error message in admin

 

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

 

select count(*) as total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '2' and ot.class = 'ot_total'

 

 

How could i fix that?

I try optimize database, clean session table.......

 

 

This shop runs on 2 different servers. One is ok without problems....the other problems in the last weeks.

 

 

Thanks for Tips.....

[♥geoffreywalton]

Gooble tells me

 

144 = Table is crashed and last repair failed

 

Try running phpmyadmin

 

Select your database and then the orders table.

 

Then at the top of the page select "Operation"

 

Finally select Repair under Table Maintenance.