Help! Product can't show suddenly

[icemanchai]

My categories can show the product list without problem but when I click inside a product, the following command show in the screen:

29 File '.\zencart\reviews_description.MYD' not found (Errcode: 2)
in:
[select count(*) as count from reviews r, reviews_description rd where r.products_id = '224' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and r.status = '1']


Because I worked on my PC, I can't provide any URL. If anyone need infomation for this problem, please tell me where I can copy and paste to here. Thank you.

All happened suddenly now (Just worked perfect few hours ago). Please help!

[icemanchai]

I just used my backup file to fix the problem. Here what I have done:

1.Create a database called test.

2.Import the backup sql file to 'test' database.

3.Drop the reviews_description table (table with error) in the connected zencart database.

4.Copy the reviews_description table from 'test' to the original connected zencart database with options of 'Structure and Data', ADD DROP TABLE and ADD AUTO INCREMENT value.

Now the shop is OK. However, since I am not good for mysql operation, could anyone tell me that my procedures are corrected or not? Thanks.

[Ajeh]

As long as your original database table for the reviews and reviews_description have matching reviews_id then you should be good to go ...

Check with your hosting site to see what might have happended ... and be sure to keep regular backups ...

[icemanchai]

Thanks Ajeh. The reviews_id are matched. You are right, backup is VERY IMPORTANT.