By BilldaCat on

I had to update my sequences table manually because with my new installation (coming from vbDrupal), the counters were all set to 1, which obviously was a problem since I had a lot of existing nodes.

I set these to numbers past any existing node numbers, but now new content is not visible to users. I've tracked it down and found that entries aren't going into the node_access table. What do I need to do to fix this?

Comments

Christefano-oldaccount’s picture

Christefano-oldaccount commented

Have you tried rebuilding permissions in Administer » Content management » Post settings ?

Node access status

If the site is experiencing problems with permissions to content, you may have to rebuild the permissions cache. Possible causes for permission problems are disabling modules or configuration changes to permissions. Rebuilding will remove all privileges to posts, and replace them with permissions based on the current modules and settings.

Rebuilding may take some time if there is a lot of content or complex permission settings. After rebuilding has completed posts will automatically use the new permissions.

    http://example.com/?q=admin/content/node-settings

The Rebuild permissions button won't appear if your node_access table only has one row in it -- or if you haven't enabled an access control module. I suppose you could try rebuilding the table manually with node_access_rebuild() but I'd do it on a backup first.

  node_access_rebuild();
zahor’s picture

zahor commented

How would I use that function?

Christefano-oldaccount’s picture

Christefano-oldaccount commented

You can run this by using the Execute PHP block that the Devel module provides. Be sure to back up your database, and don't include the PHP tags when using the Execute PHP block.

You could also put that in a node (like a page) with PHP as your input format and click "Preview" instead of "Submit". Be careful with this approach, though. If you click "Submit" then you'll need to be able to delete the page when you're done with it without accidentally loading the node over and over.