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
| Comment | File | Size | Author |
|---|---|---|---|
| #8 | simple_access.deactivate.patch.txt | 3.55 KB | Robrecht Jacques |
Comments
Comment #1
Sita Bhatt commentedDeleted all records from node_access with field name "realm" and values "simple_access".
All registered users are able to add/modify/delete nodes.
Comment #2
Scott commentedFor 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)
Comment #3
Justin Freeman commentedI 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).
Comment #4
bomarmonk commentedChanging back to active: the module claims to handle this on the settings page, so this should be fixed in the module's code, right?
Comment #5
bomarmonk commentedThis is probably a duplicate or at least related to this issue:
http://drupal.org/node/55477
Comment #6
giorgoskDeactivation 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)
Comment #7
giorgoskapparently this query fixed my problem
UPDATE `node_access` SET `gid` = '0' ,`realm` = 'all';
Comment #8
Robrecht Jacques commentedAttached is a patch that makes sure that deactivating the module works.
Comment #9
gordon commentedCommited to cvs, Thanks
Comment #10
(not verified) commented