Greetings from Iran and also the weirdest drupal issue

Events happening in the community are now at Drupal community events on www.drupal.org.
Aleet's picture
Posted by Aleet on July 28, 2009 at 10:22am

Dear friends in La: first, I am so sorry I will miss the LA camp this year. I learned a tremendous amount last year and I hope you guys do videos. I am in Iran right now at my dad's home and won't be back till fall. There are protests in streets everyday, we hear. Don't know if Iran is still in the news over there.

I've got a the weirdest issue: I upgraded my own site from drupal 4.7 to 6.13 (by going thru 5.1, 5.18 & 6.6 first).

Now, I've noticed that every new node or every old node that I edit and save is inaccessible to authenticated and anonymous users.

Node Module: Access Content is checked for all users in Permissions page.

Any ideas on how to troubleshoot this?

Categories:

Comments

Any contrib modules?

Posted by btmash on July 28, 2009 at 3:37pm
btmash's picture

Hi Ali,

Are you using any contributed modules? One possible area where this issue may be coming from is the node_access table in drupal. I vaguely remember running into a similar issue last year when I upgraded a site from 4.6.x to 6.x. Check and see if that table is empty - if so, try the following query for your database:

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

Hopefully, that will solve your issue.

EDIT: I noticed you said you went from 5.18 to 6.6 - any reason for not going to 6.0 -> 6.13? Not sure if it has anything to do with it but it might be something to look into.

input formats?

Posted by patrickfgoddard on July 28, 2009 at 5:29pm
patrickfgoddard's picture

Did roles/permissions get screwed up for input formats? Make sure the default input format has roles assigned properly. I've had the problem before where roles that I thought should be able to edit certain nodes, but since that role wasn't assigned to the input format of that node, they could not edit.

Rebuilding Permssions / upgrading thru 6.0 not 6.6 important?

Posted by Aleet on July 29, 2009 at 12:52pm
Aleet's picture

Hi BTMash: Your point about node access table was right on. Thank you. My node access table had 960 rows! I rebuilt permissions (content mgmt > post settings) and now I have just 1 row and my access issue is resolved. This article also helped: http://www.zivtech.com/blog/drupal-node-access-explained-0

I hopped from 5.18 to 6.6 and not 6.0 because that's what I had on my hard drive. With the unreliable internet connections here, every download can be a pain in the neck. I have a host of other issues (like image nodes showing up without images). Do you think it's imporant to go through 6.0 first?

thund3rbox: my input formats are set correctly. But, unrelated to this, input formats have been a baffling issue for me: http://drupal.org/node/237906#comment-1793840