By Akrotiri on

Hi,

I am playing around with running a Drupal 6.x test site with XAMPP from a memory stick. I've no idea whether this is wise or not.

I've just got the following errors but don't know what the problem is or how to fix them. What does this mean? How do I sort it out? Is there a non-techy solution?

"user warning: Table 'node_access' is marked as crashed and should be repaired query: SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all')) AND grant_view >= 1 in E:\xampp\htdocs\drupal\modules\node\node.module on line 2161.
user warning: Table 'node_type' is marked as crashed and should be repaired query: SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC in E:\xampp\htdocs\drupal\modules\node\node.module on line 552.
warning: mysql_query() [function.mysql-query]: Unable to save result set in E:\xampp\htdocs\drupal\includes\database.mysql.inc on line 108. "

I'd be grateful if anyone could point me in the right direction.

⋅ Categories: Drupal 6.x

Comments

mkalbere’s picture

mkalbere commented

This is a mysql issue, have a look there http://dev.mysql.com/doc/refman/5.0/en/repair-table.html

styro’s picture

styro commented

http://drupal.org/search/apachesolr_search/table%20maked%20as%20crashed%...
http://www.google.com/search?q=mysql+table+marked+as+crashed+repair

Akrotiri’s picture

Akrotiri commented

Thanks for pointing me at the REPAIR TABLE syntax. This has worked for repairing the two tables but the last part of the error message still remains:

"warning: mysql_query() [function.mysql-query]: Unable to save result set in E:\xampp\htdocs\drupal\includes\database.mysql.inc on line 108."

I've searched but haven't been able to find a way of sorting this out. Any ideas?