I received the error:

Table 'drupal.nodeaccess' doesn't exist query: SELECT nid, gid, realm, grant_view, grant_update, grant_delete FROM nodeaccess where nid = 160 in C:\drupal\includes\database.mysql.inc on line 172.

After investigating I found the following, which appear to be errors, in the nodeaccess.module

line 263 db_query("DELETE FROM {nodeaccess} WHERE nid=%d", $nid);
line 396 $result = db_query("SELECT nid, gid, realm, grant_view, grant_update, grant_delete FROM {nodeaccess} where nid = %d", $node->nid);
line 287 db_query('DELETE FROM {nodeaccess} WHERE nid=%d', $node->nid);

Fix by changing "FROM {nodeaccess}" to "FROM {node_access}"

Comments

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (fixed)

You should not change the table names, I don't know why people feel compelled to do this...

If the table doesn't exist, run update.php and manually select the earliest version for nodeaccess.