Hi
I deactivated Simple Access using administer-simple access-deactivate and then deselected the module from use.
This is causing all registered users to get access denied messages for all existing content.
Even if they create new content, they can submit and are unable to view it after that.
I have even deleted old nodes (since this is a test url), but the issue is with new nodes being added as well.
I viewed the node_access table and see entries like this:

+-----+-----+---------------+------------+--------------+--------------+
| nid | gid | realm | grant_view | grant_update | grant_delete |
+-----+-----+---------------+------------+--------------+--------------+
| 1 | 0 | simple_access | 1 | 0 | 0 |
| 2 | 0 | simple_access | 1 | 0 | 0 |
| 3 | 0 | simple_access | 1 | 0 | 0 |
| 4 | 0 | simple_access | 1 | 0 | 0 |
| 5 | 0 | simple_access | 1 | 0 | 0 |
| 6 | 0 | simple_access | 1 | 0 | 0 |
| 7 | 0 | simple_access | 1 | 0 | 0 |
| 8 | 0 | simple_access | 1 | 0 | 0 |
| 9 | 3 | simple_access | 1 | 0 | 0 |
| 9 | 4 | simple_access | 1 | 0 | 0 |
| 9 | 5 | simple_access | 1 | 0 | 0 |
| 9 | 6 | simple_access | 0 | 1 | 1 |
| 9 | 7 | simple_access | 0 | 1 | 1 |
| 11 | 0 | simple_access | 1 | 0 | 0 |
| 11 | 6 | simple_access | 0 | 1 | 1 |
| 12 | 0 | simple_access | 1 | 0 | 0 |
| 12 | 6 | simple_access | 0 | 1 | 1 |
| 14 | 0 | simple_access | 1 | 0 | 0 |
| 15 | 0 | simple_access | 1 | 0 | 0 |
| 16 | 0 | simple_access | 1 | 0 | 0 |
| 17 | 0 | simple_access | 1 | 0 | 0 |
+-----+-----+---------------+------------+--------------+--------------+

I'm not sure what to do to enable access to all content.
Would appreciate any help.
Thanks & Rgds
Sita

Comments

Sita Bhatt’s picture

Assigned: Unassigned » Sita Bhatt
Status: Active » Fixed

Deleted all records from node_access with field name "realm" and values "simple_access".
All registered users are able to add/modify/delete nodes.

Scott’s picture

For anyone else with this issue...

If the above solution doesn't work, you might also need to run this query after deleting the rows with realm = simple_access:

INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0)

I ran the query using phpMyAdmin and it worked -- all nodes are accessible everyone. (Drupal 4.7)

Justin Freeman’s picture

I had this problem too and the above fixes worked. The access table still had the simple_access records even after "deactivation" was clicked (a few times).

bomarmonk’s picture

Status: Fixed » Active

Changing back to active: the module claims to handle this on the settings page, so this should be fixed in the module's code, right?

bomarmonk’s picture

This is probably a duplicate or at least related to this issue:
http://drupal.org/node/55477

giorgosk’s picture

Deactivation button did not appear to do anything when pressed even though there seems to be a request sent to the server.

There is more comments on the issue at http://drupal.org/node/67199 (might be usefull)

giorgosk’s picture

apparently this query fixed my problem
UPDATE `node_access` SET `gid` = '0' ,`realm` = 'all';

Robrecht Jacques’s picture

Status: Active » Needs review
StatusFileSize
new3.55 KB

Attached is a patch that makes sure that deactivating the module works.

gordon’s picture

Status: Needs review » Fixed

Commited to cvs, Thanks

Anonymous’s picture

Status: Fixed » Closed (fixed)

  • Commit 85c79d9 on 5.x-1.x, 5.x-2.x, 6.x-2.x, master, 8.x-3.x by gordon:
    #65640 - fix to the deactivate of simple_access.