Have you been using an access control module, and then turned it off? If so, sometimes the access table isn't updated correctly, it happened to me.
Under the Admin > Content > Posts page (/admin/content/node-settings) there is a 'Rebuild Permissions' button. This will force a complete rebuild of the access tables.
Greg
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Daniel Carrera Sent: Saturday, June 28, 2008 10:22 AM To: support@drupal.org Subject: Re: [support] Navigation Block has vanished
I also can't see some pages unless I am logged in. For example, you can't see the blogs. It says "Access Denied" which is ridiculous. Here, see for yourself:
http://theingots.org/community/blog
Does anyone know why permissions would go berzerk like that? More importantly, where can I reset them so that regular visitors can see the bogs again?
I've tested other pages and those can be accessed fine. It looks like it's only blogs that are somehow access-denied. And of course, the navigation bar doesn't appear.
These look like a weird sort of permission problem. Because the site works fine when you login.
Daniel.
Daniel Carrera wrote:
Hello,
For some reason, the navigation block has vanished from my website. But when you login (with any account) the block appears again. This just happened today, and I haven't touched Drupal in the last 3 days, so it is not obviously something I did. In addition, all other blocks look just fine. It is only the navigation block that is acting up.
Is there a setting somewhere that might make a block appear only for authenticated users? I have Drupal 4.7 btw.
Earlier today I also got a note from a user about what looks like a MySQL-related error. I don't know if this is at all related, but I include it below just in case.
- user warning: Got error 28 from storage engine query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (1) in /home/theingot/public_html/community/includes/database.mysqli.inc
on line 124.
- user warning: Got error 28 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid IN ('3','4','9','10','11','12','13')) AND r.nid = 1 ORDER BY v.weight, t.weight, t.name in /home/theingot/public_html/community/includes/database.mysqli.inc
on line 124
Line 124 is inside function _db_query() and the relevant lines are:
if (!mysqli_errno($active_db)) { return $result; } else { trigger_error(check_plain(mysqli_error($active_db) ."\nquery: ". $query), E_USER_WARNING); return FALSE; }
So I guess all we know is that there was some MySQL error.
I don't see how this could be connected to the navigation block disappearing, but I thought I'd include it for completeness.
I would be grateful for any assistance you may offer.
Daniel.