No access for users upgrading drupal from 4.7

xiaoxin's picture

Upgrading to Drupal 5.0 may yield unexpected surprises. One surprise can be in a form of "access denied" errors to all but user 1. This is probably left over from an node access control module.

If you find yourself in that situation run the following sql statements:

INSERT INTO users (uid, name, mail) VALUES ('0', '', '');
INSERT INTO users_roles (uid, rid) VALUES (0, 1);
INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0);

From : http://drupal.org/node/20397#comment-111175