I have a Drupal installation that was successfully upgraded from 4.5 to 5.1 several weeks ago. At least we haven't noticed any problems.

The site didn't have nodeaccess before the upgrade and I tried to install it today putting it in the 5.1 suggested location of /sites/all/modules/nodeaccess.

When I enable the Nodeaccess module I get many errors similar to the following:

# user warning: Table 'apap-drupal.nodeaccess' doesn't exist query: SELECT nid, gid, realm, grant_view, grant_update, grant_delete FROM nodeaccess where nid = 1 in /home/apap/public_html/includes/database.mysql.inc on line 172.
# user warning: Table 'apap-drupal.nodeaccess' doesn't exist query: SELECT nid, gid, realm, grant_view, grant_update, grant_delete FROM nodeaccess where nid = 2 in /home/apap/public_html/includes/database.mysql.inc on line 172.
# user warning: Table 'apap-drupal.nodeaccess' doesn't exist query: SELECT nid, gid, realm, grant_view, grant_update, grant_delete FROM nodeaccess where nid = 4 in /home/apap/public_html/includes/database.mysql.inc on line 172.
# user warning: Table 'apap-drupal.nodeaccess' doesn't exist query: SELECT nid, gid, realm, grant_view, grant_update, grant_delete FROM nodeaccess where nid = 5 in /home/apap/public_html/includes/database.mysql.inc on line 172.
# user warning: Table 'apap-drupal.nodeaccess' doesn't exist query: SELECT nid, gid, realm, grant_view, grant_update, grant_delete FROM nodeaccess where nid = 6 in /home/apap/public_html/includes/database.mysql.inc on line 172.
# user warning: Table 'apap-drupal.nodeaccess' doesn't exist query: SELECT nid, gid, realm, grant_view, grant_update, grant_delete FROM nodeaccess where nid = 7 in

Comments

marky’s picture

marky commented

This suggests that for some reason the database tables were not created during installation of the module. They were created without errors on my clean 5.1 installation.

Try running update.php...

Anonymous’s picture

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

Yep, if the tables don't exist run update.php and select the earliest version for nodeaccess.