Posted by ranoble on February 19, 2010 at 3:49pm
What is the difference between the table nodeaccess and the table node_access? Do I need both of them?
What is the difference between the table nodeaccess and the table node_access? Do I need both of them?
Comments
In my Drupal 6 sites, there
In my Drupal 6 sites, there is a node_access table but no nodeaccess table. The node_access table is created by Drupal core, so you shouldn't delete it. I'm guessing that the nodeaccess table was probably created by the "nodeaccess" module, which is a third-party module:
http://drupal.org/project/nodeaccess
Just to make things a little more confusing, you should be aware that there is also a third-party "node_access" module which is different than the third-party "nodeaccess" module:
http://drupal.org/project/node_access
However, the node_access TABLE is NOT created by the node_access module. It's created by Drupal core, so don't delete it.
If you have the nodeaccess module installed on your site, you shouldn't delete the nodeaccess table either. However, uninstalling the module should delete the table for you.
Sheldon Rampton
Senior web developer, New York State Senate
http://www.nysenate.gov
http://drupal.org/user/13085