By alliax on

Hello

My node permissions have been lost (mangled, whatever). I'm on Drupal 6 and my site was working fine until today, when I saw that all content (views, list of content via terms, nodes themselves, etc.) was not avaialble anymore to anonymous user.

Suddenly all my anonymous visitors can see nothing. The home page they see is the default "Welcome to your new Drupal website" text displayed when no posts can be displayed. My menus work fine but every page is "Access denied."

Logged in as admin I can browse normally and see my home page and everything, but my nice welcoming home page and all publicly viewable content is invisible to Joe Public.

This happened suddenly without anything done on my side it seems. I've checked in access right and everything is still correct, anonymous users have the access module node content checked.

So I'm really lost as to what to do now and why it happened.

I use several module, one is simplefeed which is creating nodes from RSS feeds. All the rest is pretty simple, I don't use any access control module.

Cheers,

⋅ Categories: Drupal 6.x

Comments

alliax’s picture

alliax commented

OK, I've found how to solve the problem, but not WHY IT HAPPENED!!!!

IF you know, please tell me and the world how come Drupal can suddenly loose such an entry in node_access table, this is incredible !!!

So, in Drupal 6 here's what I had to add to my database in order for anonymous users to start seeing the site as they always did:

INSERT INTO `node_access` (`nid`, `gid`, `realm`, `grant_view`, `grant_update`, `grant_delete`) VALUES
(0, 0, 'all', 1, 0, 0);

PLEASE TELL ME, BECAUSE I THINK I'M GOING TO HAVE TO CHECK ALL MY DRUPAL SITES REGULARLY BECAUSE OF THAT STRANGE THING HAPPENING !!

amireldor’s picture

amireldor commented

It's been a week before I even noticed there's a problem. I've updated my Drupal 6's core and modules but it was still there.

The MySQL command you gave solved the issue for me, but I fear some module is problematic. I suspect some database schema module is doing this. I didn't install the site, I'm just administrating it. I guess the installer got excited and put all kinds of weird modules here.

Oh well...
Thanks allax. Will let you know if this happens again. I hope the updated version of all the modules' solved this issue.

shs27’s picture

shs27 commented

My anonymous users can only see the Title fields in an upcoming event block, but not the time. Not sure what's gone wrong, or how to fix it.

alliax’s picture

alliax commented

I have no idea, you'd better create a new thread for your own problem, perhaps even an issue within the event module, because you're likely not going to get any help in my thread, especially since no one replied to my "different than yours" problem.

alliax’s picture

alliax commented

It happened again today! I mean I've noticed it today, but don't know for how many days it has been like that again.

Why?

beautifulmind’s picture

beautifulmind
he/him
Primary language Gujarati
Location Dubai
commented

http://scholarbeat.com

It happens some times when you install new module and it modifies the node access rights.
You have to rebuild the node access by navigating to admin > site configuration > post setting.
Here, you will find a button with text, "Rebuild permission".

Just click on it and you'll be back where you were before.

:)
Beautifulmind

Regards.
🪷 Beautifulmind

minesota’s picture

minesota commented

Hi thanks ! I was looking for this info. I was sure it was somewhere but forgot.
LOGICALLY it should have been atop the "access control" or "permissions" page but it is not there.

alliax’s picture

alliax commented

I can't find post setting in site configuration on drupal 6.
And this happened twice on this same site, when I haven't touched it AT ALL during this time.
I have simplefeed which create new posts every now and then, but no new comment have been posted and no user can login to this site except me!

beautifulmind’s picture

beautifulmind
he/him
Primary language Gujarati
Location Dubai
commented

http://scholarbeat.com

Okay.

Now, take a back up of the db of your live site, make a test pack on your laptop, and try removing the modules in the reverse order.
Remove the module first you installed last. And check if any one has caused the problem.

Keep looking for the message on the module list page, that asks you to rebuild the permissions.

:)
Beautifulmind

Regards.
🪷 Beautifulmind

alliax’s picture

alliax commented

It happened again ! I don't know why.
I haven't installed or removed any module even before the first time it happened.
The button is not there to be found. But you can find it by going to this url :
/admin/content/node-settings/rebuild

I have found NO REASON for this behaviour to happen on any forum thread. People give the way to restore anonymous user access, but no one seem to know what happens in the first place. Many messages talk about OG (organic groups) module, but I never used that one.

beautifulmind’s picture

beautifulmind
he/him
Primary language Gujarati
Location Dubai
commented

http://scholarbeat.com

Okay!

Can I have the url of your site please?

:)
Beautifulmind

Regards.
🪷 Beautifulmind

alliax’s picture

alliax commented

Hi, my site is not in english, what exactly do you want to know about it, I can tell you.
It's a multi install, that is I have several domains using the same drupal files but each with its own database, so the sites are completly separated. This bug happens only on this site and it's the first time in years of using drupal that it happened to me, it's also the only site where I use simplefeed, that's why I suspected this module. Now I've updated to the latest dev version of simplefeed module and will wait to see if the bug happens again. I'll tell it here if it does happen again.

victor.vhv’s picture

victor.vhv commented

node settings is available in: admin/content/node-settings
For instance, if drupal was installed in yourdrupalinstall.com: http://www.yourdrupalinstall.com/admin/content/node-settings

alliax’s picture

alliax commented

I have to say that it has now been several weeks without this bug happening again, and after last time the only thing I did to this site was to update the module SimpleFeed, and since this module was creating new nodes from RSS feeds and so perhaps playing with user something, I'll accuse an unknown bug in this module version to have created this mess. I saw no hint about that in the module issues queue, but I have no other idea why this happened to me and only on one site, except that was the only one using this module.

anoopjohn’s picture

anoopjohn commented

I have started seeing this symptom in my Drupal installation recently. The site was running fine until one fine day it started showing this symptom and it keeps getting repeated every few days. Any tips on how to debug this issue?

--
www.zyxware.com

beautifulmind’s picture

beautifulmind
he/him
Primary language Gujarati
Location Dubai
commented

You must run the cron once or twice and also the update.php
Make sure you have latest stable release installed of all modules including the drupal core.

Regards.

Regards.
🪷 Beautifulmind

ljgra’s picture

ljgra commented

link of rebuild is this: .../admin/reports/status/rebuild >> didn't work. Anonymous could still not access DA url.