I finished the site a trainee had been working on in our company. When everything was done I got an access denied for all users except my admin (the 1st user) account.

Nothing worked, I checked the permissions of authenticated users, I tried creating a new role with the necessary permissions,...

In the end I started playing with my database, replacing some of the tables that could be a problem with tables from a clean install, but also this didn't do the trick. But I noticed that there were some tables that were no longer in use that belong to the taxonomy access module.

Apparently my trainee had used "taxonomy access" on the installation and this had messed up the node access system after he disabled the module the node access table was not rebuild properly.

Then I found the following thread http://lists.drupal.org/pipermail/support/2007-February/004178.html (Thank you Greg Holsclaw)

which showed me the way to a magical button to rebuild your node access permissions table that you can find at
admin >> content management >> post settings

Click that and your node_access database should be restored. I thought I leave a trail for other people with a similar problem.

If you suspect that this is your problem and you don't get the button, reinstall and subsequently disable the taxonomy access module and you should get the button back.

Hope this helps some people out there

Comments

p6’s picture

I figured it out, the hardway myself. Node access problems no matter what I do !
Since then, I've seen atleast a good lot of 10 plus people who've had the same problem and in the same state as I have.

Nice of you to take your time out to make the suggestion.

- Pavan Keshavamurthy

- Pavan Keshavamurthy
http://grahana.net/

OSLinux’s picture

Would this not reset all the stuff, anybody??

~~

Linux, Drupal5 and Simple Machines Forum R great (got a "non-Russian Bridge yet (for me..))
http://veberu.hostfabrica.ru/index.php

DRUPAL ME BAD!!! & Feel free to contact me (4 faster repsonse) I am happy to look at your site (privately or com

socialnicheguru’s picture

http://SocialNicheGuru.com
Delivering inSITE(TM), we empower you to deliver the right product and the right message to the right NICHE at the right time across all product, marketing, and sales channels.