For some odd reason, after testing out some modules I was given an access denied on all content for non-admin users. If you would get such a thing, and are at the end of the road with your options, try the following commands:
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);
It will either return ‘duplicate entry’ warning (ignore this) or -maybe- fix your problem…