Guest Posted September 9, 2008 Share Posted September 9, 2008 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 Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted September 9, 2008 Share Posted September 9, 2008 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? Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Guest Posted September 9, 2008 Share Posted September 9, 2008 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.