By psr on

This is a continuation of an earlier post: http://drupal.org/node/59080

I need some help.

None of my recent content is visible to any user, including anonymous, unless I select the the 'administer nodes' permission under access control. When 'administer nodes' is not selected for a given role, then that role only sees content from a few days ago and older. I have tested this with all roles and they all do the same thing. I don't want to give this permission to all users esp anonymous.

I followed the instructions from the previous post on this topic regarding filling the empty records in the MySQL 'access_nodes' table but this did not help.

I have tested most of the other access permissions and it seems to be only the 'administer nodes' that allows new content to be displayed. I have tried turning off all non-essential modules, no change. I have added and activated the organic groups module, no change. I even tried a different theme, no change.

Why would the 'administer nodes' permission cause this difference? I do have the 'access content' permission checked and it makes no difference. Are there other database tables or modules that might be involved. Any Ideas?

⋅ Categories: Drupal 5.x

Comments

wmostrey’s picture

wmostrey commented

Did you enabled taxonomy_access? If you did, disable it and see if your problem still persists. You need to specificaly allow posts for anonymous users, an I(gnore) is not enough.

psr’s picture

psr commented

I looked over my MySQL drupal data base and there is no 'taxonomy_access' table, there's a 'term_access'
is this what you mean?

i tried disabling the taxonomy module it made no difference. right now I've got all modules except bare necessities on an still no difference. do you mean category access? what do you mean 'taxonomy_access' where is this?

mikaskay’s picture

mikaskay commented

if you have 'term_access' in your database then you did install the taxonomy_access module at one point in your life. had the same problem and i'm using taxonomy_access.

make sure you have not more than one access control going on and check your taxonomy_access rules.

'administer nodes' simply overrules 'taxonomy_access' or other access controls

if you dont want taxonomy_access drop the tables from your database: term_access' and 'term_access_defaults'.

psr’s picture

psr commented

That seems to have been exactly 100% the issue.
Thanks x10^6 for your tip this was driving me crazy.

If you have a paypal address I will send you $5usa for a beer (or warm milk, whatever you like).

Out of curiosity, how why and or what are you using the taxonomy_access module for?

mikaskay’s picture

mikaskay commented

I'm using taxonomy to restrict access well by taxonomy terms. Using it with biblio because i couldnt find any way to restrict access to only parts of the library. It works fine so far : ))

BTW, if you want to re-enable the taxonomy access module you need to create the tables manually!

CREATE TABLE term_access (
tid integer NOT NULL default '0',
rid integer NOT NULL default '0',
grant_view smallint NOT NULL default '0',
grant_update smallint NOT NULL default '0',
grant_delete smallint NOT NULL default '0',
grant_create smallint NOT NULL default '0',
grant_list smallint NOT NULL default '0',
PRIMARY KEY (tid,rid)
);

CREATE TABLE term_access_defaults (
vid integer NOT NULL default '0',
rid integer NOT NULL default '0',
grant_view smallint NOT NULL default '0',
grant_update smallint NOT NULL default '0',
grant_delete smallint NOT NULL default '0',
grant_create smallint NOT NULL default '0',
grant_list smallint NOT NULL default '0',
PRIMARY KEY (vid,rid)
);

PS: I just answered a question. BUT PLEASE you would do me a favor if you could send the money to drupal. They're doing an excellent job here... http://association.drupal.org/donate