Error 1194 Table "o" is marked as crashed....

[Guest]

Can someone help me: i am stuck!

 

I get the following error message upon calling admin.php?menu=8&mode=mysqladmin...

 

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /is/htdocs/***************/catalog/admin/includes/functions/database.php on line 45

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

 

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'

 

(n.b. with *********** i just deleted some sensitive folder info)

 

Has someone got a clue?

Table "o" does not exist and the code select count(*)...= 'ot_total' is not part of /catalog/admin/includes/functions/database.php.

 

Thank you in advance.

 

RIn67630

[♥geoffreywalton]

sql error messages are a little confusing until you get used to them. Here is a hint

 

from orders o

 

Guessed which table they are talking about now?

[Guest]

sql error messages are a little confusing until you get used to them. Here is a hint

 

from orders o

 

Guessed which table they are talking about now?

 

You mean "orders"?

 

I repaired "orders" and ... it worked again!

 

Thank you very much!

 

RIN67630