Got a table crashed error message.

[nicedeals]

Someone please help me on this one.

got the following error message on the website where the product list is supposed to be;

 

"1194 - Table 'pd' is marked as crashed and should be repaired

 

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 25

 

[TEP STOP]" :'(

[nicedeals]

Someone please help me on this one.

got the following error message on the website where the product list is supposed to be;

 

"1194 - Table 'pd' is marked as crashed and should be repaired

 

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 25

 

[TEP STOP]" :'(

 

Its OK now..sorted itself out..what could have been wrong here?? :blink:

[nicedeals]

Its back again <_<

[nicedeals]

Figured it out..took a bit of searching on the net..I thought I'll add it here for anyone else who might get stuck with this problem.

 

OK, the solution is simple. Do what the error message is asking you to do i.e. access phpmyadmin and select the appropriate database and then the appropriate table ( pd = product description in my case ) and at the bottom of the page, select " repair table "

 

Thats it. :thumbsup:

Apparently, one should also optimize the tables every now and then to keep mySQL working fine and prevent clogging etc.