major meltdown

[martyjoe]

i went to the admin section to see if i could turn activate the new products module. now i get this on the front page and the lower left corner of the admin section:

 

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

select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 0

 

please help.

[Mark Evans]

Click search

 

Enter error 145 in the box

 

You will find more than 1 answer to your question ;)

[martyjoe]

i went into mysql db via unix terminal:

 

went to the table "products"

 

get the following: ERROR 1016: Can't open file: 'products.MYI'. (errno: 145)

 

any mysql mavins know why?

[martyjoe]

i did a search and this sql command fixed the problem.

 

FIX:

The database table has crashed and needs to be repaired with the following SQL statement:

repair table <table>;

Replace the word "<table>" with the name of the table that needs to be repaired.

 

strange, because i really didnt' do anything except what was stated on the first post.

 

oh well..., i can breath a little now.

 

 

 

:blink:

[Mark Evans]

table crashes are usually caused by low disk space.

 

Make sure you have plenty of spare room on your hosting package.