I'm having trouble with node access issues and think it might have something to do with the workflow module. I'm using these modules:

CCK
Organic Groups
OG Content Type Admin
Workflow
Actions

What is happening is that after a nodes has gone through the workflow and is published, it is viewable to anonymous users. If you re-edit that node, the node_access table gets changed and the anonymous user can no longer view the node. If you then go to the workflow module and resave the workflow, the permissions are reset. I don't really understand the interconnection between workflow access, og, and go content types. What exactly is the "gid" in the node_access table and does it come from the og content type module?

Any help would be appreciated.

Comments

mshaver’s picture

mshaver commented

This may have something to do with Organic Groups node access settings and workflow access. When I disable workflow_access, everything is fine. Do these access modules not play nicely together? Here is the PHP error showing up in the log:

Duplicate entry '3631' for key 1 query: INSERT INTO node_access (nid, realm, gid, grant_view, grant_update, grant_delete) VALUES (3631, 'workflow_access', 3, 1, 1, 1) in /home/www/intranet/includes/database.mysql.inc on line 186.

moshe weitzman’s picture

moshe weitzman commented

they should work together OK but you are now into expert land. anyway, it looks to me like your sequences table is confused.

Bastlynn’s picture

Bastlynn commented
Status: Active » Closed (won't fix)

Hi,

With the release of Drupal 7, Drupal 5 is no longer receiving security updates, reviews, or development from many contributed modules. Since 5 is now considered a depreciated version, you really should seriously look into upgrading to Drupal 6 or 7. The newer versions of Drupal work better, have more support, and will be safer (literally! security patches!) for your website. We are currently working on a new release for Workflow to Drupal 7. In light of that, further support for Drupal 5 issues is infeasible at the moment. Please consider upgrading to Drupal 6 or 7 in the near future - you'll be glad you did.

- Bastlynn